WeBid Bug Tracking - WeBid
View Issue Details
0000211WeBidAuctionspublic2011-01-24 06:102011-04-18 11:11
h20boynz 
 
urgentminorhave not tried
resolvedfixed 
1.0.1 
1.0.2 
213
0000211: cron error when auction closes with no bids
Getting an error everytime an auction closes without any bids having been placed.

The cron.php file looks in the bid table for a record with an auction id matching the record it is trying to close. Doesn't find one and throughs an exception.

Error log shows the following:



24-01-2011, 19:01:15:: Database access error. Please contact the site administrator. DELETE webid_bids WHERE auction = 8

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 'WHERE auction = 8' at line 1

page:/usr/home/rehablab/domains/myrehablab.co.nz/public_html/webid/cron.php line:234



I am using the NON_BATCH setting as I cannot setup cronjobs with my host (budget hosting plan).
No tags attached.
Issue History
2015-04-01 13:17renlokNew Issue
2015-04-01 13:17renlokimport_id => 213
2015-04-01 13:17renlokDate Submitted2015-04-01 13:17 => 2011-01-24 06:10
2015-04-01 13:17renlokLast Update2015-04-01 13:17 => 2011-04-18 11:11

Notes
(0000500)
h20boynz   
2011-01-24 20:53   
(edited on: 2011-01-24 22:03)
This is an issue. Other than going in and manually deleting the auction from the auction table, I cannot remove this error. It occurs everytime the cron.php file attempts to close an auction with no bids. Here is the error as shown on the error.php page:

ErrorArray ( [0] => Database access error. Please contact the site administrator. DELETE webid_bids WHERE auction = 10 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 'WHERE auction = 10' at line 1 page:/usr/home/rehablab/domains/myrehablab.co.nz/public_html/webid/cron.php line:234 )

and here is the error in the error log:

25-01-2011, 09:49:05:: Database access error. Please contact the site administrator. DELETE webid_bids WHERE auction = 10
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 'WHERE auction = 10' at line 1
page:/usr/home/rehablab/domains/myrehablab.co.nz/public_html/webid/cron.php line:234

and here is the cron.log output:

=============== STARTING CRON SCRIPT: January 24, 2011 21:59:12 ++++++ Closing expired auctions 2 auctions to close Processing auction: 10 mail to seller: <myemail>@<mydomain>.com

Hope someone can help.
(0000516)
chronic   
2011-02-02 13:27   
(edited on: 1970-01-01 00:00)
yeah I can confirm I am getting the same thing. Sorry I dont know how to fix other then manually removing it from the the table as the above.

Interestingly going into the admin then to 'auctions' and deleting the auction from there will stop the site from displaying the error msg too.

02-02-2011, 05:47:33:: Database access error. Please contact the site administrator. DELETE webid_bids WHERE auction = 12
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 'WHERE auction = 12' at line 1
page:/home/castabid/public_html/WeBid/cron.php line:234
(0000544)
chronic   
2011-02-19 09:31   
(edited on: 1970-01-01 00:00)
I worked out a fix.

I found this code in cron.php


               
Someone wrote

// delete auction
        $query = "DELETE FROM " . $DBPrefix . "auctions WHERE id = '" . $AuctionInfo['id'] . "'";
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);

        // delete bids for this auction
        $query = "DELETE FROM " . $DBPrefix . "bids WHERE auction='" . $AuctionInfo['id'] . "'";
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);

        // Delete proxybid entries
        $query = "DELETE FROM " . $DBPrefix . "proxybid WHERE itemid = " . $AuctionInfo['id'];
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);

        // Delete counter entries
        $query = "DELETE FROM " . $DBPrefix . "auccounter WHERE auction_id = " . $AuctionInfo['id'];
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);


I replaced it with this code.


           
Someone wrote

// delete auction
        $query = "DELETE FROM " . $DBPrefix . "auctions WHERE id = " . $AuctionInfo['id'];
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);

        // delete bids for this auction
        $query = "DELETE FROM " . $DBPrefix . "bids WHERE auction= " . $AuctionInfo['id'];
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);

        // Delete proxybid entries
        $query = "DELETE FROM " . $DBPrefix . "proxybid WHERE itemid = " . $AuctionInfo['id'];
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);

        // Delete counter entries
        $query = "DELETE FROM " . $DBPrefix . "auccounter WHERE auction_id = " . $AuctionInfo['id'];
        $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);


Works fine now.
(0000548)
pryc   
2011-02-20 08:29   
(edited on: 2011-02-20 08:38)
I have same problem fix doesnt works

helped deleting auction in admin
(0000549)
bid4abook   
2011-02-21 18:51   
(edited on: 1970-01-01 00:00)
Ditto! Every time an auction closes the error message appears and disables the site until you either delete or relist the auction:

21-02-2011, 11:48:04:: Unknown error type: [2] Division by zero on /home/bid4aboo/public_html/auction/profile.php line 107
21-02-2011, 11:48:04:: Unknown error type: [2] Division by zero on /home/bid4aboo/public_html/auction/profile.php line 108
21-02-2011, 11:48:04:: Unknown error type: [2] Division by zero on /home/bid4aboo/public_html/auction/profile.php line 109
21-02-2011, 13:49:48:: Database access error. Please contact the site administrator. SELECT cat_id FROM webid_categories WHERE left_id > AND right_id <
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 'AND right_id <' at line 1
page:/home/bid4aboo/public_html/auction/includes/functions_categories.php line:377
21-02-2011, 14:04:27:: Database access error. Please contact the site administrator. SELECT cat_id FROM webid_categories WHERE left_id > AND right_id <
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 'AND right_id <' at line 1
page:/home/bid4aboo/public_html/auction/includes/functions_categories.php line:377
21-02-2011, 14:48:36:: Unknown error type: [2] fopen(uploaded/29/thumb-auction1_5.jpg) [function.fopen]: failed to open stream: No such file or directory on /home/bid4aboo/public_html/auction/getthumb.php line 38
21-02-2011, 15:28:57:: Unknown error type: [2] Division by zero on /home/bid4aboo/public_html/auction/profile.php line 107
21-02-2011, 15:28:57:: Unknown error type: [2] Division by zero on /home/bid4aboo/public_html/auction/profile.php line 108
21-02-2011, 15:28:57:: Unknown error type: [2] Division by zero on /home/bid4aboo/public_html/auction/profile.php line 109
21-02-2011, 18:28:07:: Database access error. Please contact the site administrator. DELETE webid_bids WHERE auction = 1
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 'WHERE auction = 1' at line 1
page:/home/bid4aboo/public_html/auction/cron.php line:234
21-02-2011, 18:28:25:: Database access error. Please contact the site administrator. DELETE webid_bids WHERE auction = 1
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 'WHERE auction = 1' at line 1
page:/home/bid4aboo/public_html/auction/cron.php line:234
21-02-2011, 18:30:15:: Database access error. Please contact the site administrator. DELETE webid_bids WHERE auction = 1
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 'WHERE auction = 1' at line 1
page:/home/bid4aboo/public_html/auction/cron.php line:234
21-02-2011, 18:30:34:: Database access error. Please contact the site administrator. DELETE webid_bids WHERE auction = 1
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 'WHERE auction = 1' at line 1
page:/home/bid4aboo/public_html/auction/cron.php line:234
21-02-2011, 18:37:17:: Unknown error type: [2] Division by zero on /home/bid4aboo/public_html/auction/profile.php line 107
21-02-2011, 18:37:17:: Unknown error type: [2] Division by zero on /home/bid4aboo/public_html/auction/profile.php line 108
21-02-2011, 18:37:17:: Unknown error type: [2] Division by zero on /home/bid4aboo/public_html/auction/profile.php line 109
(0000550)
peter2011   
2011-02-23 00:11   
(edited on: 1970-01-01 00:00)
Hi this is my first time posting but i have a serious issue and need help urgently.

I have an error come up. My url is http://www.psychicbids.com" [^" title="]]http://www.psychicbids.com[/URL] [^] and now it is http://www.psychicbids.com/error.php[/url][/B] [^]

I went to check error log: Database access error. Please contact the site administrator. DELETE webid_bids WHERE auction = 42
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 'WHERE auction = 42' at line 1

Ive looked in database and i have no idea what to do to correct this as im new to this stuff. I am praying this can be fixed as my site already has members and items for sale etc.

Please can someone assist me in this issue... I have had to close the site due to this error...
(0000551)
renlok   
2011-02-23 14:55   
(edited on: 2011-02-23 16:02)
Sorry its taken so long for me to look into this, but heres the fix

in cron.php find (about line 233)
[php]$query = "DELETE " . $DBPrefix . "bids WHERE auction = " . $Auction['id'];
            $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);
            $query = "DELETE " . $DBPrefix . "proxybid WHERE itemid = " . $Auction['id'];
            $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);[/php]
and replace with
[php]$query = "DELETE FROM " . $DBPrefix . "bids WHERE auction = " . $Auction['id'];
            $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);
            $query = "DELETE FROM " . $DBPrefix . "proxybid WHERE itemid = " . $Auction['id'];
            $system->check_mysql(mysql_query($query), $query, __LINE__, __FILE__);[/php]
(0000553)
infin8   
2011-02-24 08:13   
(edited on: 1970-01-01 00:00)
Thanks for the fix :)
(0000556)
peter2011   
2011-02-25 01:38   
(edited on: 1970-01-01 00:00)
many thanks for your help
(0000643)
kid   
2011-04-07 18:03   
(edited on: 1970-01-01 00:00)
Excellent. Thanks much for this!
(0000661)
Ovcharoff   
2011-04-18 11:11   
(edited on: 1970-01-01 00:00)
Thanks a lot for the fix ! :)