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

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:

                    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 '' coming from the page (referrer) ''.

The user agent given was 'Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv: Gecko/20070312 Firefox/'.

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

There should be a backtrace in the error message from Eventum. Can you post it for this bug please?

[16 Apr 2007 23:36] Schalk Neethling

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