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 ?
46
Reporter ?
Pavle Gardijan
Bugdar / 1.1.3
Status ?
Closed
Severity ?
Minor
Duplicate Of ?
- none -
Fixed in Revision ?
1273
Mstone ?
Summary ?
SQL error in editreport.php
Report Time ?
October 25, 2006 07:01 PM
Assignment ?
Resolution ?
Fixed
Priority ?
Normal
Dependencies ?
- none -
Mstone (old) ?
1.1.4


Attachments
patch.diff Patch for the fix
Votes
For: 0 (0%)
Against: 0 (0%)
Total: 0

October 25, 2006 07:01 PM Pavle Gardijan
After updating an anonymously contributed report (without e-mail address?!) the following SQL error occurs...

» Query:

SELECT user.*, useremail.*
FROM bugdar_useremail AS useremail
LEFT JOIN bugdar_user AS user
ON (user.userid = useremail.userid)
WHERE useremail.userid IN ()



» 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 ')' at line 5
» Additional Notes: Invalid SQL query
» File: /bug/editreport.php

October 26, 2006 02:34 AM Robert
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 October 26, 2006 02:34 AM, Robert changed:
October 26, 2006 02:34 AM Robert
I'm attaching the patch for this bug.

On October 26, 2006 02:34 AM, Robert changed:
October 26, 2006 09:29 AM Pavle Gardijan
thank you for this *very* fast response