Listing Display
Bug Id ?
46
Reporter ?
Pavle Gardijan
Product/Version ?
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 ?
Robert
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