WeBid Bug Tracking

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0000055WeBidBiddingpublic2009-09-23 16:332009-10-08 14:18
Assigned To 
PrioritylowSeverityminorReproducibilityhave not tried
PlatformOSOS Version
Product Version0.8.0 
Target VersionFixed in Version0.8.2 
Summary0000055: SQL Syntax bug when auto time extension is used
DescriptionIf you have the automatic auction time extension feature turned on and you perform a bid within the last two minutes of the auction, you get the following error (at least I did using MySQL 5.1):

23-09-2009, 16:16:55:: Database access error. Please contact the site administrator. UPDATE FROM webid_auctions SET ends = ends + 300 WHERE id = 5

    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 'FROM webid_auctions SET ends = ends + 300 WHERE id = 5' at line 1

    page:C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\rf\auction08\bid.php line:79

The problem is that the word FROM should be taken out.

This bug was reported a while back, and i'm surprised to see it in the 0.8 source code.

One other thing: the countdown timer in the item detail is all very nice, but it isn't accurate when auctions get extended.
TagsNo tags attached.
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2015-04-01 13:17 renlok New Issue
2015-04-01 13:17 renlok import_id => 55
2015-04-01 13:17 renlok Date Submitted 2015-04-01 13:17 => 2009-09-23 16:33
2015-04-01 13:17 renlok Last Update 2015-04-01 13:17 => 2009-10-08 14:18

Copyright © 2000 - 2019 MantisBT Team
Powered by Mantis Bugtracker