Hello, guest. We have noticed that you are not registered at this bug tracker. Your experience will be greatly enhanced if you log in. To do so, you first must register by clicking on the Register tab at the top. If you are already registered, you can login at the Login tab.
Syndicate Syndicate Listing Display Search Login/Register
Bug Id ?
62
Reporter ?
CJD
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 ?
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
» File: /tracker/search.php

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:
if i write on browser "http://192.168.0.128/tracker/search.php?new=1" the search screen apears, and i can search.

if i not search, error is repeat, i write http://192.168.0.128/tracker/search.php?new=1 again, and search some.

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: