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.
» 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:
- Status from "Unconfirmed" to "Assigned"
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.
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.
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.
--------------- 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:
- Status from "Assigned" to "Closed"
- Resolution from "Open" to "Fixed"
- Fixed in Revision from "" to "1373 [b], 1374 [t]"