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 ?
Reporter ?
Bugdar / 1.1.4
Status ?
Severity ?
Duplicate Of ?
- none -
Fixed in Revision ?
1375 [b], 1376 [t]
Mstone ?
Summary ?
mysql error (to add new user)
Report Time ?
December 29, 2006 05:44 PM
Assignment ?
Resolution ?
Priority ?
Dependencies ?
- none -
Mstone (old) ?

patch.diff Patch file
For: 0 (0%)
Against: 0 (0%)
Total: 0

December 29, 2006 05:44 PM CJD

on screen, adduser section is displayed OK, but mail section only displayed header and...

» Query:

SELECT * FROM useremail WHERE userid =

» 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 1
» Additional Notes: Invalid SQL query
» File: /tracker/admin/user.php

December 29, 2006 09:21 PM Robert
Closed and fixed. I also discovered a bug with the way email options are saved in the add new user screen in the admin section, which I've also fixed. Thanks!

--------------- AUTOMATIC RESPONSE ---------------
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 December 29, 2006 09:21 PM, Robert changed:
December 29, 2006 09:22 PM Robert
Here's the fix for this bug as well as the other issue I discovered (mentioned above). Patch applied to both 1.1.x branch and the trunk.