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:
None 
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:15] Schalk Neethling
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.
[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