Auction Product Type

[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.

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

[davewest]

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.

[gonewild]

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

[gxjenkins]

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.

[gonewild]

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.

[gxjenkins]

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

[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.