WeBid Bug Tracking

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000211WeBidAuctionspublic2011-01-24 06:102011-04-18 11:11
Reporterh20boynz 
Assigned To 
PriorityurgentSeverityminorReproducibilityhave not tried
StatusresolvedResolutionfixed 
PlatformOSOS Version
Product Version1.0.1 
Target VersionFixed in Version1.0.2 
Summary0000211: cron error when auction closes with no bids
DescriptionGetting 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).
TagsNo tags attached.
import_id213
Thread
Attached Files

- Relationships

-  Notes
(0000500)
h20boynz (reporter)
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 (viewer)
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 (viewer)
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 (viewer)
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 (reporter)
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 (viewer)
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 (administrator)
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 (viewer)
2011-02-24 08:13
edited on: 1970-01-01 00:00

Thanks for the fix :)
(0000556)
peter2011 (viewer)
2011-02-25 01:38
edited on: 1970-01-01 00:00

many thanks for your help
(0000643)
kid (viewer)
2011-04-07 18:03
edited on: 1970-01-01 00:00

Excellent. Thanks much for this!
(0000661)
Ovcharoff (reporter)
2011-04-18 11:11
edited on: 1970-01-01 00:00

Thanks a lot for the fix ! :)

- Issue History
Date Modified Username Field Change
2015-04-01 13:17 renlok New Issue
2015-04-01 13:17 renlok import_id => 213
2015-04-01 13:17 renlok Date Submitted 2015-04-01 13:17 => 2011-01-24 06:10
2015-04-01 13:17 renlok Last Update 2015-04-01 13:17 => 2011-04-18 11:11


Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker