| Bug #27842 | 'DB Error: syntax error' on user update | ||
|---|---|---|---|
| Submitted: | 16 Apr 2007 5:15 | Modified: | 17 Apr 2007 1:50 |
| Reporter: | Schalk Neethling | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | Eventum | Severity: | S3 (Non-critical) |
| Version: | 2.0 beta 1 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | db error, syntax error | ||
[16 Apr 2007 5:48]
Bryan Alsdorf
Hi, There should be a backtrace in the error message from Eventum. Can you post it for this bug please? /bryan
[16 Apr 2007 23:36]
Schalk Neethling
Backtrace
Attachment: bug001.txt (text/plain), 8.24 KiB.
[17 Apr 2007 1:50]
Bryan Alsdorf
This is fixed in SVN now. Unfortunately the tarball for 2.0 is already propogating to the mirrors. Fortunately this error is not critical as it only happens when all users are un-assigned from an issue. This will be in the followup release to 2.0
Description: Hello, An error was found at 04/16/2007 07:56:16 (1176699376) on line '711' of script 'C:\Program Files\Apache Software Foundation\Apache2.2\htdocs\eventum\include\class.user.php'. The error message passed to us was: 'DB Error: syntax error' A more detailed error message follows: 'SELECT usr_full_name FROM eventum.eventum_user WHERE usr_id IN () [nativecode=1064 ** 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 6]' That happened on page '/eventum/update.php' from IP Address '0.0.0.0' coming from the page (referrer) 'http://10.200.64.234:90/eventum/update.php?id=28&new_status=10';. The user agent given was 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.0.11) Gecko/20070312 Firefox/1.5.0.11'. -- Sincerely yours, Automated Error_Handler Class How to repeat: Not sure, it seems to be happening when a user is created or updated. Suggested fix: Fix SQL sytax for specific query.