Listing Display
Bug Id ?
62
Reporter ?
CJD
Product/Version ?
Bugdar / 1.1.4
Status ?
Closed
Severity ?
Moderate
Duplicate Of ?
- none -
Fixed in Revision ?
1373 [b], 1374 [t]
Mstone ?
Summary ?
some times, an user can't search (tab search give an error)
Report Time ?
December 26, 2006 10:49 PM
Assignment ?
Robert
Resolution ?
Fixed
Priority ?
Normal
Dependencies ?
- none -
Mstone (old) ?


Attachments
patch.diff Potential fix
Votes
For: 0 (0%)
Against: 0 (0%)
Total: 0

December 26, 2006 10:49 PM CJD
two times, for different user, this happened

» Query:

SELECT * FROM bug WHERE bugid IN () LIMIT 0, 21


» Error Number: 1064
» Error Message: 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 ') LIMIT 0, 21' at line 1
» Additional Notes: Invalid SQL query

and this user never more can search. new user was added for "normalize" situation.

i thing maybe if an user are logged into 2 different pc at sometime, it crashed. maybe not!

sorry my english. spanish is better for me. and thank you.

December 26, 2006 11:04 PM Robert
Is this a registered and logged-in user, or a guest? I have attached a potential fix for this problem. Please apply the patch and tell me if it fixes the issue.

On December 26, 2006 11:09 PM, Robert changed:
December 26, 2006 11:09 PM Robert
Marking assigned as this is being addressed.

December 27, 2006 05:42 PM CJD
hi! i will try the patch more later.

now, i find something:


thank, later write how the patch run.

December 27, 2006 08:21 PM Robert
When you search do you get any search results displayed ever? The patch basically prevents the SQL error and offers to stick &new=1 at the end of the URL for you--so it should fix everything.

December 29, 2006 05:39 PM CJD
hi, don't have any other error of this type.
thanks for the patch, and i waiting a new version. i like some features/requests.


December 29, 2006 09:01 PM Robert
Marking fixed. Change applied on both the 1.1.5 branch and on the trunk (1.2.0).

--------------- AUTOMATIC RESPONSE ---------------
Thank you for your bug report. This issue has been closed and fixed in Subversion. This change will be available in a future release, but you can download the change at any time from the Subversion server.

On December 29, 2006 09:01 PM, Robert changed: