Auction Product Type

also, why doesnt magiczoom work on the auction page.

Quote:

---

Originally Posted by AndyII

setup a test auction with 10 cent bids or something, nice stuff but ........:blink:

---

Its not real products yet, they are just pretend for now. The price doesnt matter.

ok I see you mabe a bid,

I "as webmaster" got this email:
The original message was received at Sun, 5 Oct 2008 18:53:04 -0700
from clubina@localhost

----- The following addresses had permanent fatal errors -----
<>
(reason: 550 5.1.1 User unknown)

----- Transcript of session follows -----
550 5.1.1 <>... User unknown

With an attachment telling me "the webmaster" I was out bid.

WHat did you see?

you have a .htaccess file in your store or public folder?. make a backup of it , then remove for a test
if this file contains
instructions which the web server doesn't know how to parse, then it will generate this error message

Quote:

---

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [email protected] and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.

Apache/1.3.33 Server at clubina.com Port 80

---

Quote:

---

Originally Posted by AndyII

you have a .htaccess file in your store or public folder?. make a backup of it , then remove for a test
if this file contains
instructions which the web server doesn't know how to parse, then it will generate this error message

---

I have a backup of my entire site along with the htaccess file.
I should delete the htaccess file from my production server and see if it still works?

Also, why cant dreamweaver read the htaccess file?

1st a .htaccess file is considered a hidden file, perhaps thats why.
2nd yes just remove the .htaccess file and we will test to eliminate or condemn it LOL
if so, post your .htaccess file and maybe we can figure the trouble.

? .....:smile:

Quote:

---

Originally Posted by AndyII

you have a .htaccess file in your store or public folder?. make a backup of it , then remove for a test
if this file contains
instructions which the web server doesn't know how to parse, then it will generate this error message

---

There are no .htaccess files in my root or store directory already. There are a few in the sub folders such as admin ETC.

Which ones should I worry about?

Also ,
1. Did you see an error page after you placed a bid?
2. Did you get an error email?

I really think the issue is that the module thinks the webmaster is a buyer just because I put a starting bid in when I created the product.

Then it tries to notify me that I have been outbid upon the first real buyer bid.

I think it discovers an unexpected complication in the code when trying to treat the outbid notification email to a webmaster as opposed to a buyer.

any thoughts?

I really think the issue is that the module thinks the webmaster is a buyer just because I put a starting bid in when I created the product.

Then it tries to notify me that I have been outbid upon the first real buyer bid.

I think it discovers an unexpected complication in the code when trying to send the outbid notification email to a webmaster as opposed to a buyer.

It pobbably cant find a member email to send the outbid notice to because its the admin that made the first bid when they set the peramiters for the product.

Therefore it sends the error email to the admin.

Can there be an if else statement to check to see if the customer has an email in the propper place in the member database or is not a registered or logged in administrator who uploads the product starting bid?

any thoughts?

Actually,

The if else statement should check to see if the admin starting bid price is equal to the current bid price. Then do not even send an email notification of either being out bid or having anyone win the auction.

Can someone write this code?

Regards,
Nadia

Quote:

---

Originally Posted by NadiaUSA

Actually,

The if else statement should check to see if the admin starting bid price is equal to the current bid price. Then do not even send an email notification of either being out bid or having anyone win the auction.

Can someone write this code?

Regards,
Nadia

---

I've noticed the blank email once the bidding started and will eventually fix it.

Is the other emails sending ok?

I'm working on a better admin side for tracking auctions before I go live with mine, but got side tracked writing a new free shipping mod. About done with it so should be working on the auction mod again.

Quote:

---

I've noticed the blank email once the bidding started and will eventually fix it.

---

here a fix for it... simple check for a blank email address.

edit \includes\modules\pages\product_auction_info\header_php.php

around line 95 find,

Quote:

---

if ($customer_high_bidder != $_SESSION['customer_id']) {

---

above it add this.

Code:

---

if ($previous_bidders_email_address != "") {

---

around line 114 find,

Quote:

---

zen_mail($name, $previous_bidders_email_address, EMAIL_SUBJECT, $email_text, STORE_NAME, EMAIL_FROM, $html_msg, 'welcome');

---

below that line add an } to close the if statement.

This checks for a blank email address and bypass the email creation if it is so.

Thanks for the fix, it works perfect!!

Quote:

---

Originally Posted by NadiaUSA

Thanks for the fix, it works perfect!!

---

Did this also fix the error after the first bid?

Quote:

---

Originally Posted by gonewild

did this also fix the error after the first bid?

---

yes it is fixed

I still get the error page following the first bid. But only after the first bid.

Quote:

---

Originally Posted by gonewild

I still get the error page following the first bid. But only after the first bid.

---

It works for me. I integrated the code as directed above.

In my admin I set the product minimum price at 200.
and the starting bid as 200.00

Then I logged in my cart as the first shopper and made a bid for 300 and it worked fine.

no error page and no email was sent to me as an admin trying to tell myself I was outbid.

Quote:

---

Originally Posted by NadiaUSA

It works for me. I integrated the code as directed above.

In my admin I set the product minimum price at 200.
and the starting bid as 200.00

Then I logged in my cart as the first shopper and made a bid for 300 and it worked fine.

no error page and no email was sent to me as an admin trying to tell myself I was outbid.

---

Where do you set the product minimum price? I do not see that option.

the reserve prive is the minimum price it can be sold for.

Hi,
I'm glade to see this is being updated, and it seems to be working much better than the 0.95 version I was using.

I'm still having a strange problem with emails, and a Security Warning. I also had the Security Warning back in 2007
http://www.zen-cart.com/forum/showpo...6&postcount=20

As for emails, the only one that is going out is the "Out Bid" email. I'm not getting the Winning Bid email at all.

Now for a little history. I installed version 0.95 and had a few problems but did get it working (pretty well).

When I installed version 0.99a I installed it over the old version. All seemed to go well. It's working with only the two problems I listed.

You only get the Security Warning if you login using the " Login to Bid" icon, but not the Store Login.

Since I am getting the "Out Bid" email I don't see why it's not sending the "Winning Bid" email.

So, I have two questions, should I use the "uninstall" sql to remove the new version, and then go into phpadmin and delete anything else left that would be from the old version. Then re-install the new version. I ask that because I didn't get a "Server Error" with the new install, but I did with the old version, and now I don't remember how I got around that.

Or, is there something I can do to fix my current install.

Thanks,
Gary

P.S. I'm using zencart 1.38a

Quote:

---

Originally Posted by gxjenkins

Hi,
I'm glade to see this is being updated, and it seems to be working much better than the 0.95 version I was using.

I'm still having a strange problem with emails, and a Security Warning. I also had the Security Warning back in 2007
http://www.zen-cart.com/forum/showpo...6&postcount=20

As for emails, the only one that is going out is the "Out Bid" email. I'm not getting the Winning Bid email at all.

Now for a little history. I installed version 0.95 and had a few problems but did get it working (pretty well).

When I installed version 0.99a I installed it over the old version. All seemed to go well. It's working with only the two problems I listed.

You only get the Security Warning if you login using the " Login to Bid" icon, but not the Store Login.

Since I am getting the "Out Bid" email I don't see why it's not sending the "Winning Bid" email.

So, I have two questions, should I use the "uninstall" sql to remove the new version, and then go into phpadmin and delete anything else left that would be from the old version. Then re-install the new version. I ask that because I didn't get a "Server Error" with the new install, but I did with the old version, and now I don't remember how I got around that.

Or, is there something I can do to fix my current install.

Thanks,
Gary

P.S. I'm using zencart 1.38a

---

The DB schema changed between .95 and .99. You need to read the readme. I think there is an update.sql file that will handle it, but the safest thing to to is uninstall and reinstall.

The .99a version is built on 1.3.8a + SQL patch per Dr. Byte,

Good luck!

I uninstalled the new version .99a. I still had the Product Type Auction in Product Types from the old version so I deleted it in phpadmin.

Sofar so good. I ran the "zen_auction.sql" (not the update).

Got this error:
"1062 Duplicate entry 'SHOW_PRODUCT_AUCTION_INFO_MODEL' for key 2"

I also tried to run the sql in phpadmin and got the same error. I checked the forum and found a post that said something was missing from one of the files, but would be added in .99a.
I'll check that anyway.

Now I do have a new Product Type for Auctions, but I don't have a "Auction Manager" under Configuration.

I still have 3 auctions showing but I can't click on them, and can't delete in Admin.

And, the best part of all this is after going thru the sql install.

I got the two emails telling me I won the auctions.

I did a DB backup just before starting this so I should be able to get back to only getting the "outbid" emails, but I would like to fix the error.

Any ideas?

Thanks.
Gary

Quote:

---

Originally Posted by gxjenkins

Got this error:
"1062 Duplicate entry 'SHOW_PRODUCT_AUCTION_INFO_MODEL' for key 2"

Any ideas?

Thanks.
Gary

---

Sorry no... I cannot explain why you are getting a duplicate index error on a table that should have been deleted when you ran the uninstall SQL.

I would look at the DB schema and see what it thinks it has. I would also do a test install of just 1.3.8a and 99a and see if that fails.

AHB

Hi
Just to bring everyone up to date on this weird ongoing problem.

Again I ran the "uninstall sql" and it ran no errors.
Then I restored the backup I had done just before making any of the changes yesterday.

Right after doing the restore I got the two Winning Emails. I went back into zencart admin > config, and "Auction Manager" was back. I expected that since it was there when I did the backup, but now there was a setting to active the CRON job, and that wasn't there when I started the backup. I changed the settings for the CRON to "1" and in 5 mins. I got the Winning Emails again.

I also noticed that when looking at the auction when I started the backup the button to login said "Login To Bid", and now it says, "Login To Place Bid".

I placed a couple of bids on a running auction and the emails telling the old bidder they had been "outbid" did go out.

Then I changed the auction end time and waited. About 30 mins. before the auction ended I placed another bid and got the email that I had been outbid. When the auction ended no email went out. I waited, and waited, still no email. I remembered the emails did go out before I set the CRON setting so I changed it back to "0", and the Winning Email was sent, but to me, and I wasn't the last or highest bidder. I had been outbid within 30 mins of the auction end. I logged into the store, but couldn't buy the auction, so the store knew I wasn't the winner. I logged in with the ID that had placed the winning bid and was able to complete the purchase.

I have an auction ending later today and I'll see if it sends the email to the correct bidder. I changed permissions on "CRON.PHP" to 755 this morning to see if that will help with the emails. I'll let you know

I'm still getting the Security Warning message if I login using the "Login To Place Bid" icon. I'll try using the login file from 1.3.7 to see if that stops the error, it did in version .95

All and all it's working better than it's ever worked before. I'll let you know what I find out.

Thanks,
Gary

Quote:

---

Originally Posted by gxjenkins

Hi
Just to bring everyone up to date on this weird ongoing problem.

Again I ran the "uninstall sql" and it ran no errors.
Then I restored the backup I had done just before making any of the changes yesterday.

---

If you ran the uninstall why did you restore?

If you had 95 installed, there is no uninstall. I had to hand clean my install before upgrading to 98.

As for the mail, it works in two ways. If you installed the code in application_top and have cron set to 0, then ever time a page loads, any page that uses application_top, the auctions class runs and checks to see the status of any auctions. If you set cron to 1, then you need to set a cronjob to run as per the instructions. Access cron through your host cpanel and have it run cron.php to access the auction class. "php -f /YOUR STORE PATH/admin/cron.php >> /dev/null"

I like the first blank email, was the only way I could tell the bidding started.

I ran the uninstall sql successfully. Then when I try to reinstall I get an error saying duplicate entries.
I ran the sql in phpmyadmin and get the following error. Even with this error the auctions function with the server error after the first bid. But I also do not have the auction manager in admin. Any ideas what is wrong with the sql?

Error
SQL query:

SELECT *
FROM Array
WHERE CONCAT_WS( "-", '', 'Show Model Number', 'SHOW_PRODUCT_AUCTION_INFO_MODEL', '1', 'Display Model Number on Product Info 0= off 1= on', last_insert_id( ) = "show_product_auction_info_model"
ORDER BY '', 'Show Model Number', 'SHOW_PRODUCT_AUCTION_INFO_MODEL', '1', 'Display Model Number on Product Info 0= off 1= on', last_insert_id(
LIMIT 0 , 30

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY '' , 'Show Model Number' , 'SHOW_PRODUCT_AUCTION_INFO_MODEL' , '1' , 'D' at line 1

I think you don't have "Auction Manager" because the sql didn't finish. That's what happened to me after running the uninstall sql and trying to run the sql. I got the error from my earlier post and no "Auction Manager".

Since I had version 0.95 installed and "Auction Manager" from that version was there when I did the restore I got "Auction Manager" back with the new CRON option which was not there after installing version .99a.

That should answer your question "davewest" why I did the restore. I was trying to get back to where the mod was working except for the emails. Now the only two problem I see left for me is Security Warning, and the Winner Email going to the right person.

I found a typo in the CRON and fixed that so I think it should run O.K. now. I'll try using the login file from zen version 1.37 to see if that fixes the Security Warning.

Gonewild, are you opening the sql file in notepad, or something else? I didn't get that error I got a 162 error. I was thinking maybe when you did your copy and paste you might have picked up an extra character or something like that.

Like I said earlier the only reason mine is working is because I had an older version already installed. The sql file for the new version has never finished for me but because the files for new version are on the server and the settings for Auction Manager were in the DB from the older version the new version seems to be working pretty well now.

With that in mind you could run the sql from an older version then install the files for the new version and try running the new sql file. I don't think the new sql file will finish but the older version sql may give you enough of what you need to get the new version running.

BACKUP YOUR DATABASE BEFORE MAKING ANY CHANGES...

Good luck.. let us know what happens

Gary

I'm going to setup a new zen install with no mod's and try to install.

I opened the sql in notebook to copy it. I also ran it with the sql upload tool in admin and both give the same duplicate error problem.

You are corect the sql is not finishing. It only adds 2 tables....
products_auctions and product_auction_extras.
How many tables are supposed to be created?

I tried to run sql from several old versions 95, 96.... and they won't finsih either and only add the same two tables.

At some point I did have the Auction Manager (maybe from and old version as well) but after I uninstalled it disappeared. Now I can get the sql to complete.

Any other ideas? Could this be a php version conflict? My server is php5.

I'm sure I would have the same problem not being able to run the sql file if I had not backed up the DB before running the uninstall sql file.
Checking phpadmin I only see two tables:
Product_auction
Product_auction_extra
and there are settings in "configuration_group

I did a couple of screenshots, but I can't upload them because they are too big.

You can download them here:
http://www.nascarlives.com/configuration_group.doc

http://www.nascarlives.com/configuration_group_1.doc

Hope this helps.

Gary

Version 95 created:

two tables
product_auction_extra
products_auctions

inserted...
product_types one key
product_type_layout 17 keys
configuration_group one key 'Auction Manager'
configuration 6 keys

Most of which are used in version 98 and 99. If you don't remove them all, you'll get errors when running the install sql statements. When the sql errors, it stops reading the statements. you can re-paste the file and delete the one that error up to the beginning, then run it again. Keep running the statements after the error until it completes.

The error is due to the keys already existing, not due to miss formed sql statements or php5.

Once it's installed your find 'Auction Manager' under configuration, and convert type under tools with a new product type call product auction.

I think I'm good to go! I'll know for sure in 8 hours when my test auction ends.

I only had to delete 2, or 3 entries in Product_Layout table but once I knew the sql would complete I ran the uninstall and I still had 1 "Auction Manager", and 1 Auction Product Type from the old install. I deleted those in the DB, and re-ran the install.

I know that I'm getting the "outbid" emails, and as long as the winner email goes out I should be O.K. for now.

Any ideas about why the Security Warning is popping up, and only when using the "Login To Place Bid" icon?

Thanks for your help.
Gary

Quote:

---

Originally Posted by gxjenkins

Any ideas about why the Security Warning is popping up, and only when using the "Login To Place Bid" icon?

---

Not having a problem with the login to bid button, but I'm still on my testing server without SSL.

in tpl_product_auction_info_display.php around line 158 is your button code. Should look like below.

Code:

---

  <td align="center" class="main"><?php if (!$_SESSION['customer_id']) {
      $_SESSION['navigation']->set_snapshot(); echo '<a href="' . zen_href_link(FILENAME_LOGIN) . '">' . zen_image_button(BUTTON_IMAGE_AUCTION_LOG_IN, BUTTON_AUCTION_LOG_IN_ALT) . '</a>'; } ?></td>

---

The above works, but to make use of ssl it should read and more then likly fix your problem it should look like below,

Code:

---

<td align="center" class="main"><?php if (!$_SESSION['customer_id']) {
      $_SESSION['navigation']->set_snapshot(); echo '<a href="' . zen_href_link(FILENAME_LOGIN, '', 'SSL') . '">' . zen_image_button(BUTTON_IMAGE_AUCTION_LOG_IN, BUTTON_AUCTION_LOG_IN_ALT) . '</a>'; } ?></td>

---

Of coarse ssl should be the norm, but you could force it to use non-ssl by replacing 'SSL' with 'NONSSL'

:clap:

I am happy to report that the last 4 test Auctions sent out both the "Out Bid" , and the "Winner" emails to both test accounts.

Now, maybe I can get rid of some of the stuff crowding me out of my house.

Thanks, for ALL the help.
Gary

Quote:

---

Originally Posted by davewest

Version 95 created:

two tables
product_auction_extra
products_auctions

inserted...
product_types one key
product_type_layout 17 keys
configuration_group one key 'Auction Manager'
configuration 6 keys

Most of which are used in version 98 and 99. If you don't remove them all, you'll get errors when running the install sql statements. When the sql errors, it stops reading the statements. you can re-paste the file and delete the one that error up to the beginning, then run it again. Keep running the statements after the error until it completes.

The error is due to the keys already existing, not due to miss formed sql statements or php5.

Once it's installed your find 'Auction Manager' under configuration, and convert type under tools with a new product type call product auction.

---

I tried deleting and pasting the sql as you described but it still did not work. Maybe I do not understand the method you described. can you explain it a little more?

How can I manually delete and clean up the inserted:
product_types one key
product_type_layout 17 keys
configuration_group one key 'Auction Manager'
configuration 6 keys

I think I need to get it completely uninstalled so I can get the sql to run.

thanks for your help!

Quote:

---

Originally Posted by davewest

Not having a problem with the login to bid button, but I'm still on my testing server without SSL.

in tpl_product_auction_info_display.php around line 158 is your button code. Should look like below.

Code:

---

  <td align="center" class="main"><?php if (!$_SESSION['customer_id']) {
      $_SESSION['navigation']->set_snapshot(); echo '<a href="' . zen_href_link(FILENAME_LOGIN) . '">' . zen_image_button(BUTTON_IMAGE_AUCTION_LOG_IN, BUTTON_AUCTION_LOG_IN_ALT) . '</a>'; } ?></td>

---

The above works, but to make use of ssl it should read and more then likly fix your problem it should look like below,

Code:

---

<td align="center" class="main"><?php if (!$_SESSION['customer_id']) {
      $_SESSION['navigation']->set_snapshot(); echo '<a href="' . zen_href_link(FILENAME_LOGIN, '', 'SSL') . '">' . zen_image_button(BUTTON_IMAGE_AUCTION_LOG_IN, BUTTON_AUCTION_LOG_IN_ALT) . '</a>'; } ?></td>

---

Of coarse ssl should be the norm, but you could force it to use non-ssl by replacing 'SSL' with 'NONSSL'

---

I made the changes but it didn't stop the error message.

I wondering if anyone else is having this problem because I'm only getting it in FireFox. If I login using IE 6, or 7 I don't get the error message. But, with IE7 one of my test ID's can't login to the store, it will not recognize the password. With IE6 I don't get the error message and I can sign in with both test accounts without problems. I see the error msg in FireFox on XP, and 2000. So, maybe it's FireFox that has the problem?

BTW, what table are the current bids stored in? I looked for them in the two Auction tables, and didn't see them.

Thanks
Gary

Quote:

---

Originally Posted by gonewild

I tried deleting and pasting the sql as you described but it still did not work. Maybe I do not understand the method you described. can you explain it a little more?

How can I manually delete and clean up the inserted:
product_types one key
product_type_layout 17 keys
configuration_group one key 'Auction Manager'
configuration 6 keys

I think I need to get it completely uninstalled so I can get the sql to run.

thanks for your help!

---

gonewild your error listed the same table I had trouble with and that was Product_type_layout, so start there. Go into phpadmin and in your store's DB on the left find Product_type_layout, and click on it. That will bring up that table on the right. Scroll down the right side looking for any setting for Auction and delete it. Delete them all. Then go to the next table mentioned and do the same. Once you've gone thru the whole list of tables run the install sql and it should run without giving you an error.

Gary

Quote:

---

Originally Posted by gxjenkins

gonewild your error listed the same table I had trouble with and that was Product_type_layout, so start there. Go into phpadmin and in your store's DB on the left find Product_type_layout, and click on it. That will bring up that table on the right. Scroll down the right side looking for any setting for Auction and delete it. Delete them all. Then go to the next table mentioned and do the same. Once you've gone thru the whole list of tables run the install sql and it should run without giving you an error.

Gary

---

Thanks, I found all the entries, deleted them and the sql ran correctly. Now I have the auction manager.

But I still have the problem with the Internal server error after the first bid is placed.
Does anyone else have this problem?

Quote:

---

Originally Posted by gonewild

Thanks, I found all the entries, deleted them and the sql ran correctly. Now I have the auction manager.

But I still have the problem with the Internal server error after the first bid is placed.
Does anyone else have this problem?

---

Gonewild, here is a post from April last year I had the same Server error:
http://www.zen-cart.com/forum/showpo...1&postcount=16

This worked for me on version .95 on Zencart 1.3.7, and at the time it fixed the Security Warning also. I don't know if it's being caused by the same thing but you can give it a shot.

Back then this also fixed the Security Warning. I'm getting that warning again, but only with FireFox.

If you try it let me know if it works.

Gary

I've just uploaded this mod to my site but get 404 errors when trying to add an auction item. SQL file was executed using the ZC SQL patch uploader. Auction settings in ZC admin and DB tables are all present. Any ideas and help will be appreciated.

ZC: v1.3.8
Mods: Glacial Age template
URL: www.nsabaits.com/nsabaits_shop/

Quote:

---

Originally Posted by NSABaits

I've just uploaded this mod to my site but get 404 errors when trying to add an auction item. SQL file was executed using the ZC SQL patch uploader. Auction settings in ZC admin and DB tables are all present. Any ideas and help will be appreciated.

ZC: v1.3.8
Mods: Glacial Age template
URL: www.nsabaits.com/nsabaits_shop/

---

It sounds like you may not have a "Product Type" for Auctions. Check under Catalog > Product Type and see if it's there.

Also, did you have an earlier version installed?

If you didn't get an error when you ran the SQL it should be there if it is try uploading the files again.

Gary

Product type is there. Is there a setting in the product type which I'm setting up incorrectly?

This is also my first zencart site so the version is also a clean install with just the template mod.

Check the error logs in your cpanel to see what page is being requested and not found.
The only time I got a 404 is when I had two "Products Type" for Auctions. I ran the uninstall for the new version, then deleted the other in phpmyadmin. Reinstalled and all was well.
As for the settings in the product type I don't think I changed anything in there.
I did create a category for auctions and set it to the Auction Product Type only.
Hope this helps.
Gary

Hey all,

What great progress on this mod!! Glad to see it has got to this level!
I am however stuck at this point - I am wanting to use the cron.php file but am confused at what the instructions are asking me to do with this.

Quote:

---

If you change the value to 1, you MUST add a line to your crontab that looks like this: "php -f /YOUR STORE PATH/admin/cron.php >> /dev/null" and set it to run every few minutes... 5 should be fine

---

Thanks in advance,
Nick.

(BUMP!)... Still stuck with this one... any help?

Also with the YOU STORE PATH bit, is that the entire web address or what?

Cheers,
Nick.

Your store path is going to be something like

home/YOUR_ID/public_html/STORE

You can find this in your cpanel in the panel on the left.

Good Luck,
Gary

Cheers for that, only thing is where is my "Crontab" and where do I put that line?!?!?

Quote:

---

Originally Posted by fightthefourwalls

Cheers for that, only thing is where is my "Crontab" and where do I put that line?!?!?

---

Hey Nick, I believe this has been answered a few time already... So...

You need a way to check if an auction has closed. You can add the code from the install.txt file to application_top.php which will run the class.productauction.php to check your auction tables for closed auctions and do the email notifications. This happens whenever one of your site page loads. Or you can setup a cron job to run cron.php whcih runs class.productauction.php and does the checks as above if your not getting enugh page loads.

So... now you know why... your best answer would be to ask your hosting service how to run a command ever so often. As to what address to use, depends on where you put corn.php....

Quote:

---

Originally Posted by davewest

Hey Nick, I believe this has been answered a few time already... So...

You need a way to check if an auction has closed. You can add the code from the install.txt file to application_top.php which will run the class.productauction.php to check your auction tables for closed auctions and do the email notifications. This happens whenever one of your site page loads. Or you can setup a cron job to run cron.php whcih runs class.productauction.php and does the checks as above if your not getting enugh page loads.

So... now you know why... your best answer would be to ask your hosting service how to run a command ever so often. As to what address to use, depends on where you put corn.php....

---

Thanks for that mate. Checked through the thread before posting but must have missed it.
Will check it out and give it a shot.

Thanks again,
Nick.

Have downloaded the Auction file and do not know how to get it to work. I am very green to all this and would like some advise as to were to go. I have read over the last few days that this may not be able to work with version 1.3.7.1. I noticed the post ahead of me was going to try it. Was it successful? Any help would be greatly appreciated!!!

I've recently installed this mod for a client and it's working PERFECTLY! Thanks so much!

BUT, as client's go, they always want more!

Client would like to add a countdown to the auction listing similar to what's on the bidz dot com site.

Any ideas? (other than write the mod myself ~ :shocking: wouldn't know where to begin!)

Thanks,

Tina

Quote:

---

Originally Posted by charmedbytina2

I've recently installed this mod for a client and it's working PERFECTLY! Thanks so much!

BUT, as client's go, they always want more!

Client would like to add a countdown to the auction listing similar to what's on the bidz dot com site.

Any ideas? (other than write the mod myself ~ :shocking: wouldn't know where to begin!)

Thanks,

Tina

---

Cute idea. It would require the insertion of some Javascript (JS). It actually wouldnt be all that hard to do for someone who knows how to code Javascript.

The other option is a non-java script option which will calc & display the time left, but It would not change. Each time the page is loaded it would print the new time remaining.

I am not JS skilled so I would need to figure it out (then again I never coded a line in PHP before I picked up V.95 of this mod). The PHP version, I would think, would be more straight forward.

If I were to do this, I wont have time till mid December.

AHB

bramnick,

Thanks! I can't code even if I do it by copy/paste! :wacko:

If this is something you want to tackle - keep me posted and I'll help whatever way I can - even if that means staying out of your way. :D

Tina

I just installed this, but when I go to the frontend I get a blank page, instead of my home page. If I revert back to my original includes/application_top.php, my site loads normally. I have looked at my original includes/application_top.php and the one in the download package and the only difference is right at the end, the auctions application_top.php has this tagged on the end:

if (AUCTION_CRON_ENABLE == '0') {
require(DIR_WS_CLASSES . 'class.productauction.php');
productAuction::checkAuctionStatuses();
}

Can anyone tell me why this should make my site not load, I am using Zen 1.3.8a and auction 0.99a.

I changed:

if (AUCTION_CRON_ENABLE == '0') {
require(DIR_WS_CLASSES . 'class.productauction.php');
productAuction::checkAuctionStatuses();
}

to

if (AUCTION_CRON_ENABLE == '1') {
require(DIR_WS_CLASSES . 'class.productauction.php');
productAuction::checkAuctionStatuses();
}

and it now seems to work. I have a layout problem though, my site uses the center and right columns, on the auction pages, the right column is moved to below the center column. How do I resolve this please?

Quote:

---

Originally Posted by Nellie

I changed:

if (AUCTION_CRON_ENABLE == '0') {
require(DIR_WS_CLASSES . 'class.productauction.php');
productAuction::checkAuctionStatuses();
}

to

if (AUCTION_CRON_ENABLE == '1') {
require(DIR_WS_CLASSES . 'class.productauction.php');
productAuction::checkAuctionStatuses();
}

and it now seems to work. I have a layout problem though, my site uses the center and right columns, on the auction pages, the right column is moved to below the center column. How do I resolve this please?

---

I suspect the problem is that the PHP engine cant find the include file productauction.php where it is looking for it (in DIR_WS_CLASSES)

Thanks, any idea how I fix the layout? I have zen cart 1.3.8a with apple zen template and Aucion 99a.

Quote:

---

Originally Posted by Nellie

Thanks, any idea how I fix the layout? I have zen cart 1.3.8a with apple zen template and Aucion 99a.

---

Sorry, I dont really play with templates so I dont know what might be causing that

AHB

Thanks, I'll try find someone who knows this template

Quote:

---

Originally Posted by Nellie

I changed:

if (AUCTION_CRON_ENABLE == '0') {
require(DIR_WS_CLASSES . 'class.productauction.php');
productAuction::checkAuctionStatuses();
}

to

if (AUCTION_CRON_ENABLE == '1') {
require(DIR_WS_CLASSES . 'class.productauction.php');
productAuction::checkAuctionStatuses();
}

and it now seems to work. I have a layout problem though, my site uses the center and right columns, on the auction pages, the right column is moved to below the center column. How do I resolve this please?

---

The CRON code works without making this change. Try using this error loging tool to see why the page is blank. You may have something else causing the problem.
http://www.zen-cart.com/index.php?ma...roducts_id=860

As for the layout... you can redesign it to not us tables, just takes some time to do. Look at the template how your other products are displaying and do some design changes. I'd tell you which ones to change, but I'm out doing maps for the Sayre fire... once I get back home I plan on going live with my auctions.

Thanks Dave, will see what I can do, I am not a coder unfortunately, but will try to understand what the differences are between this page and other pages that seem to be working.

I just installed the auction product module and everything seemed to go smoothly. I created a category 'LIVE AUCTIONS' and added an auction product 'DELUXE CHAKRA KIT' and everything seemed to flow seemlessly...

then i went to the storefront, clicked on the new LIVE AUCTIONS category and got a PAGE NOT FOUND error displayed where the product should be... :ohmy:


http://maidenmotherandcrone.com/PageNotFound.jpg

I renamed my admin folder during my original zencart installation... could the renaming of the admin folder be affecting something somewhere? If so, where is the /admin/ folder referenced in the auction product mod so i will know where to go and rename it.

Any help would be appreciated since this seems like a GREAT mod...

I am running zencart version 1.3.8
My website is: http://www.ZenCrystals.com

Zencart ROCKS!

Can someone please point me to the download link for this mod?

Also...... This does not change an existing site into a straight up auction site, does it?

Are we able to have our regular store items and then somehow there is an auction part to our cart?

Quote:

---

Originally Posted by taogem

Can someone please point me to the download link for this mod?

---

Forget about the previous questions......

Just a link to download would be great.. :smile:

Quote:

---

Originally Posted by taogem

Forget about the previous questions......

Just a link to download would be great.. :smile:

---

http://www.zen-cart.com/index.php?ma...ex&cPath=40_50

Quote:

---

Originally Posted by bramnick

The .99a version is built on 1.3.8a + SQL patch per Dr. Byte,

Good luck!

---

I have been looking through this thread... :lookaroun

Does this 99a version seem to be working a-ok with 1.3.8a and the addition of the SQL patch?

Quote:

---

Originally Posted by taogem

I have been looking through this thread... :lookaroun

Does this 99a version seem to be working a-ok with 1.3.8a and the addition of the SQL patch?

---

99a is a combination of .99 (1.3.8a based) + small enahacement + SQL patch per Dr. Byte.

Works for me

Should all be in the Readme

AHB

I have installed the auction99.a to a new zen cart install Zen Cart v1.3.8a/v1.3.8 but nothing is working. All the files are uploaded correctly and the changes were made to the 2 files, but there is no auction option in the product types to list an auction, and there are no auctions listed under configerations in the admin panel. Please help! thank you

Quote:

---

Originally Posted by roseblossom222

I have installed the auction99.a to a new zen cart install Zen Cart v1.3.8a/v1.3.8 but nothing is working. All the files are uploaded correctly and the changes were made to the 2 files, but there is no auction option in the product types to list an auction, and there are no auctions listed under configerations in the admin panel. Please help! thank you

---

Sounds like you didnt run the SQL file to change the DB to add the auction stuff. If you DID do that I dont know why it isnt working.

AHB

Thank you so much...it works! :clap: :D

I am getting a PAGE NOT FOUND error displayed where the auction product should be...

I installed the auction product module and the SQL file and everything seemed to go smoothly.

I then created a category 'LIVE AUCTIONS' and was able to do so and it showed the 'product type - auction' ... yay!

I then added an auction product 'DELUXE CHAKRA KIT' and everything seemed to flow seemlessly...

then i went to the storefront, clicked on the new LIVE AUCTIONS category and got the 404 error BUT the new product name is showing in the breadcrumb trail...

:frusty:

any suggestions would be appreciated

Zencart ROCKS

Quote:

---

Originally Posted by Craft Magick

I am getting a PAGE NOT FOUND error displayed where the auction product should be...

I installed the auction product module and the SQL file and everything seemed to go smoothly.

I then created a category 'LIVE AUCTIONS' and was able to do so and it showed the 'product type - auction' ... yay!

I then added an auction product 'DELUXE CHAKRA KIT' and everything seemed to flow seemlessly...

then i went to the storefront, clicked on the new LIVE AUCTIONS category and got the 404 error BUT the new product name is showing in the breadcrumb trail...

:frusty:

any suggestions would be appreciated

Zencart ROCKS

---

I am so embarrassed but in the hopes of helping anyone else that may experience this here is how i solved the issue...

i installed the INCLUDES folder, too! (when i went to uninstall everything i found out that i had never actually uploaded the INCLUDES folder, only the cron.php file and the admin folder :oops:)

Onward and upward...

the mod works PERFECTLY and thank you so much for such a wonderful mod

Zencart ROCKS :clap:

Where to begin.....

I did not install correctly the first try. During that process I tried to copy the sql patch twice.

I think that is why I have two "auction-product" in the drop down menu for selecting the product listing type.

I have tried for a third time and now I have three "auction-product" in the drop down menu.

Before I get into the steps that I did and the resulting 404 error page issue, would like to know how to uninstall everything so I can start from scratch.

Is there an option someplace to uninstall the mod completely?

Ok, sorry......

Uninstalled the three previously copied patches. Pasted the patch again, so now there is only one "auction-product" option in the listing type drop down menu.

My ZC is a subdomain to my main domain which is my WordPress blog.

What is happening is that when I select the "auction-product" from the drop down menu in admin, and then hit the "new product" tab, I am directed to a 404 error page for my blog.

Suggestions?

are you positive you uploaded all the files?
you can go through each folder/file in ftp comparing all files and their respective structure, check for size and date as well, even a uploaded file that has become corrupted can/will cause havoc

Hey, hey, hey !! :D

Got it !!!!!!!! :clap:

Now.....

I had hoped that after listing an auction item that a Live Auction link of some type would appear on the main page of the cart. There is not one.

The auction listing was placed within the general category that lists the General Products.

Can someone tell me how to create a separate page for auction items and how to make the auction items list on that page please?

If the owner of Zen Crystals, Spheres Pyramids Pendulums Chakra kits Reiki Stones Meditation tools is reading this.

You are using the same template as I am.

Maybe you could tell me how you created yours?

I also like your navigation bar at the top of your cart.

Any way..... Any help organizing a Live Auction page would be greatly appreciated !

create a category called "Auctions"?

Quote:

---

Originally Posted by AndyII

create a category called "Auctions"?

---

Geeezz, that makes sense.

Sometimes I am a bit slow :blush:

Thanks!

Can someone tell me how to set the "expiration hour" to things like 6:30 pm.

I have tried 18:30, and 1830 in there, but keeps rounding to the hour.

Thanks... :flex:

I don't mean to post a bunch of questions. Sorry..

They are just coming up as I go.

When someone tries to bid they are getting this message:


Email Error: Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport.

It also seems to be affecting my SSL. The pop ups are coming up saying the site is not secure.

I believe found the fixes for both the email and ssl earlier on in this thread.

I have another problem though.

After I got things going I posted a test item. The process worked with the exception of the couple of issues still working on.

At the time when I clicked on the test item a new page would open and display the auction item. Even bid on it.

I have since added 10 more items, but not only is the first test item, but all of the auction items open up a blank page when they are clicked on.

Completely blank.

I checked my error log but nothing there.

Any ideas why all the auction item pages are blank?

Quote:

---

Originally Posted by taogem

I believe found the fixes for both the

Completely blank.

Any ideas why all the auction item pages are blank?

---

Ok.... Soooooo Close !!

I found a Debug Utility and tracked down the problem with the blank auction item pages. :smile:

It was in the head_php_php folder that I edited to try and correct the email problem based on this thread. So for what ever reason, editing line 21 caused the blank pages. I had to put that back to original. So far that is the only code fix I have found that might have corrected the email glitch.

That aside.....

When I go to bid on an item, it is telling me about being encrypted and that can be seen by a third party.

I think will need to get my hosting company to help with that. It's strange, because it did this one time and has not done it since. I think I read something about that someplace in this thread.

Still..... Hopefully they can fix it from doing it at all.

But....... I really could use some help with the email issue.

When I place a bid, I am getting this:

Email Error: Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport.

That is set by default to PHP.

Since I believe my server is Apache, I don't believe am suppose to change it to the SMTP.

Then the email confirmation subject line reads "Mail failure - no recipient addresses"

Then the very first line in the email reads:

"A message that you sent contained no recipient addresses, and therefore no delivery could be attempted."

Most of the rest looks ok as best I can tell, except for a line that reads:

"Dear
You have been outbid on taogem.com"

Why would my confirmation say I outbid myself ?

Again, I feel like need to apologize for all the posts.

If someone could help me understand the email part then I believe everything else will be ok once my hosting Co gets the SSL straightened out.

Help please ? :lamo:

the php mail function does not work with the auction as far as I have seen
You can use sendmail, or the SMTP, just dedicate an email address for it.
I am using sendmail and it works fo the most part, some say emails are not sent or wrong email sent.
I personally havent had any big issue with this once I changed to sendmail, your host may or may not allow sendmail, and you may need to know the correct path to sendmail

ran out of edit time, sorry

And for the blank page, this is usually cased by erroneous characters that get put in by some of the editors .
This may help explain why you need a Plain Text Editor when playing in PHP

Code:

---

http://php.about.com/od/phpbasics/p/text_editor.htm

---

there are many free editors out htere, a quick Google seach gave me this site

Code:

---

http://lorelle.wordpress.com/2005/11/25/free-text-only-editors-for-templates-php-html-css-and-more/

---

Quote:

---

Originally Posted by taogem

When I go to bid on an item, it is telling me about being encrypted and that can be seen by a third party.

But....... I really could use some help with the email issue.

Email Error: Could not instantiate mail function. Please check Admin->Configuration->Email Options->Email Transport.

That is set by default to PHP.

Then the email confirmation subject line reads "Mail failure - no recipient addresses"

If someone could help me understand the email part then I believe everything else will be ok once my hosting Co gets the SSL straightened out.

---

There was a fix some time back for the blank email... as for the mail issue, try running through some of the Tutorials https://www.zen-cart.com/tutorials/index.php?category=9

I'm not having any issues using PHP mail function! I'm running my auction live right now without any problems.

If your SSl was installed and working right for the rest of your site, then it shouldn't be any different for the auction page.

Quote:

---

Originally Posted by taogem

Hey, hey, hey !! :D

Got it !!!!!!!! :clap:

Now.....

I had hoped that after listing an auction item that a Live Auction link of some type would appear on the main page of the cart. There is not one.

The auction listing was placed within the general category that lists the General Products.

Can someone tell me how to create a separate page for auction items and how to make the auction items list on that page please?

If the owner of Zen Crystals, Spheres Pyramids Pendulums Chakra kits Reiki Stones Meditation tools is reading this.

You are using the same template as I am.

Maybe you could tell me how you created yours?

I also like your navigation bar at the top of your cart.

Any way..... Any help organizing a Live Auction page would be greatly appreciated !

---

Hi taogem,
Thank you for your kind words.

I think someone else already answered your question about creating a separate Live Auctions page but just in case... I just created a separate category named 'Live Auctions' and list all of my auctions in that category.

As for the top header navigation menu bar, it came with the zencart_zen template. If you let me know what particular 'tweaks' you are referring to I'd be glad to share any helpful info I can.

Zencart has been GREAT to me and I'd love to give back in any way possible...

Zencart ROCKS :clap:

Question: Can an auction be resintated after it ends? I can't seem to get this to work for me. One of my auctions ended iwth a bid, and I cannot reset again. Does that mean I have delete and create a new one?

Quote:

---

Originally Posted by Craft Magick

Hi taogem,


As for the top header navigation menu bar, it came with the zencart_zen template. If you let me know what particular 'tweaks' you are referring to I'd be glad to share any helpful info I can.

---

Hi Craft Magick..

I am using the zencart_zen. Guess I don't know where or how to get that navigation bar with the drop down menu selections that you have at the top of your site.

My categories and and things are in a sidebar to the left of the page.

So yes, I would sure appreciate knowing how to have the same drop down menus at the top of my site as you do.


Also would like to share a Helpful Auction Mod installation thread

Chain_man from over at CST walked through an install with me.

I just wanted to share where he helped me at in case someone here would like to consider using the steps he had me use for my install.

Here is the thread

Hi taogem,
My mistake, the css horizontal drop menu was a separate mod...

you can download it from the downloads section and here's a quick link to it:

http://www.zen-cart.com/index.php?ma...roducts_id=479

hope this helps. btw, i'm going to check out your website over the weekend and mayber we can chat :smile:

Zencart ROCKS :clap:

Quote:

---

Originally Posted by Craft Magick

Hi taogem,
My mistake, the css horizontal drop menu was a separate mod...

you can download it from the downloads section and here's a quick link to it:

http://www.zen-cart.com/index.php?ma...roducts_id=479

hope this helps. btw, i'm going to check out your website over the weekend and mayber we can chat :smile:

Zencart ROCKS :clap:

---

Thanks for the link Craft Magick..

Yes, happy to have a chat any time!

Quote:

---

Originally Posted by davewest

There was a fix some time back for the blank email... as for the mail issue, try running through some of the Tutorials https://www.zen-cart.com/tutorials/index.php?category=9

I'm not having any issues using PHP mail function! I'm running my auction live right now without any problems.

If your SSl was installed and working right for the rest of your site, then it shouldn't be any different for the auction page.

---

Not sure why, but everything is working just fine now. The bidders are getting confirmations, for their bids and also when they are outbid.

No more security pop up windows with the third party encrypted messages either.

One thing though......

Should we not be getting something ourselves via email for the various auction activities? Are we going to get any at all up through and including the end of auctions?

Also, just to make sure I have it right. The cron job is suppose to be set to zero, correct? That is how I am understanding it. It seems like it would be opposite so as to make sure everything is completed at auction end.

Quote:

---

Originally Posted by taogem

...
Also, just to make sure I have it right. The cron job is suppose to be set to zero, correct? That is how I am understanding it. It seems like it would be opposite so as to make sure everything is completed at auction end.

---

If you have not setup a CRON job (if you dont know what this is they you didnt set it up) then you need it set to 0 so that the code that does auction close is run.

If you set it to 0 then only when someone goes to your sencart site (any page) will the system check to see if any auctions have closed. If no one visits for 10 hours, then the closed auction wont be detected during that time of inactivity.

AHB

Thank you bramnick..

Another question :smile:

The text that tell the status of the auctioned item. It is right under the title of the item. I can't show it here because you would have to be logged in to view it.

It tells how many bids, the current high bid, time remaining..

Any hooo..

How and where might I go to change the size of that text. It is presently almost microscopic :shocking:

Thanks and having a lot of fun with this mod!

Quote:

---

Originally Posted by taogem

How and where might I go to change the size of that text. It is presently almost microscopic

---

You need to edit the css class or add one for the area you wish to change.

The class 'main' is used throughout the auction page, tpl_product_auction_info_display.php if you add main to your style sheet and add a text size, that would work. you could add your own classes to do more.

Code:

---

.main {
  font-size: 12px ;
    }

---

I've redesign mine to not use tables and setup my own style classes

Glad to hear you got the email issue sorted out.

Hi Dave,

Thanks for the response.

I found this:

/public_html/taogemst_myzencart/admin/includes/templates/template_default/templates/tpl_product_auction_info_display.php


Here is an area that looks like it is what I am after:

<tr>
<td align="center" class="main"><?php echo TEXT_DATE_AVAILABLE .$days_left." days ".$hours_left." hours ".$minutes_left." minutes"; ?>
<?php if (AUCTION_INFO_DISPLAY_PREVIOUS_BIDS_COUNT == '1') echo '&nbsp;-&nbsp;' . $previous_bids->RecordCount() . '&nbsp;' . AUCTION_BIDS; ?></td>
</tr>


If I am in the ball park, then just not sure where exactly to edit in the code you suggested.

Quote:

---

Originally Posted by taogem

Hi Dave,

Thanks for the response.

I found this:

/public_html/taogemst_myzencart/admin/includes/templates/template_default/templates/tpl_product_auction_info_display.php


Here is an area that looks like it is what I am after:

<tr>
<td align="center" class="main"><?php echo TEXT_DATE_AVAILABLE .$days_left." days ".$hours_left." hours ".$minutes_left." minutes"; ?>
<?php if (AUCTION_INFO_DISPLAY_PREVIOUS_BIDS_COUNT == '1') echo '&nbsp;-&nbsp;' . $previous_bids->RecordCount() . '&nbsp;' . AUCTION_BIDS; ?></td>
</tr>


If I am in the ball park, then just not sure where exactly to edit in the code you suggested.

---

Have to keep in mind that I'm not using tables and I'm also using a round corner wrapper, but this is how my code looks after editing class="main".

Quote:

---

<td class="productAuction biggerText"><?php echo TEXT_DATE_AVAILABLE .$days_left." days ".$hours_left." hours ".$minutes_left." minutes"; ?>
<?php if (AUCTION_INFO_DISPLAY_PREVIOUS_BIDS_COUNT == '1') echo '&nbsp;-&nbsp;' . $previous_bids->RecordCount() . '&nbsp;' . AUCTION_BIDS; ?></td>

---

Notice I replaced 'main' with two, 'productAuction biggerText'. The 'productAuction' replaced 'main' and 'biggerText' does just that... makes that text larger then normal. Here's what the class is in my '/includes/templates/CUSTOM/css/stylesheet.css' file..

Code:

---

.productAuction  {
    text-align: center;
    vertical-align: top;
    padding: 1.2em;

.biggerText {
    font-size: 1.2em;
    }

---

I replaced the div with td so not to be confusing. Once you add the classes then all you need do is change the style sheet to make changes to your page.

Also,
/includes/templates/template_default/templates/tpl_product_auction_info_display.php
This is your default file structure, if you don't use the override, you'll have a had time upgrading your site later on.

Thanks Dave..

I got it.... !

I opted not to do the :

.productAuction {
text-align: center;
vertical-align: top;
padding: 1.2em;

The text looks good right where it is now. Nice to know I can move it if need be though.

Actually, this was a neat little practice CSS. I learned a little something by doing this.

Any way...... Thanks a bunch.. :smile:

Is there some way to tell who is bidding on what?

I looked around but can't see anything. Just seems that since it is required to log in before bidding that there must be a record of some kind.

Is there ? :unsure:

Quote:

---

Originally Posted by taogem

Is there some way to tell who is bidding on what?

---

This is supposed to be a list of the account numbers of the previous bidders listed on the bid page.

:dontgetit

AHB

Ok,

Several auction items just ended.

Bidders are not receiving any kind of winning email notifications. Shouldn't they be?

Just not exactly sure what the exact closing auction process is suppose to include.

Also....

I guess in order to have ended items not show with others that are still up for auction, we have to manually delete them?

Just looking for a little help in regards to how the mod is suppose to ideally work when auction ends.

Thank you :smile: