User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4 Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4 I have configured Bugzilla 2.19.3 with PostgreSQL backend, and when I try to add a new query for an event/whining (editwhines.cgi) a simple SQL-failure hits me. Reproducible: Always Steps to Reproduce: 1. Login as admin 2. "Edit: users" 3. "add a new user" 4. add valid info to all the fields except the disable-text 5. "Add" or 1. Make sure you're not logged in 2. "Actions: New account" 3. add valid info to the two fields (email-addr and name) 4. "Create account" Actual Results: For the admin-login: Software error: DBD::Pg::st execute failed: ERROR: function locate("unknown", character varying) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. [for Statement "SELECT eventdata FROM tokens WHERE tokentype = 'emailold' AND SUBSTRING(eventdata, 1, (LOCATE(':', eventdata) - 1)) = ? OR SUBSTRING(eventdata, (LOCATE(':', eventdata) + 1)) = ?" with ParamValues: 2='email@address.com', 1='email@address.com'] at Bugzilla/User.pm line 1142 Bugzilla::User::is_available_username('email@address.com') called at editusers.cgi line 175 And for the request of new user (not logged in): Software error: DBD::Pg::st execute failed: ERROR: function locate("unknown", character varying) does not exist HINT: No function matches the given name and argument types. You may need to add explicit type casts. [for Statement "SELECT eventdata FROM tokens WHERE tokentype = 'emailold' AND SUBSTRING(eventdata, 1, (LOCATE(':', eventdata) - 1)) = ? OR SUBSTRING(eventdata, (LOCATE(':', eventdata) + 1)) = ?" with ParamValues: 2='email@address.com', 1='email@address.com'] at Bugzilla/User.pm line 1142 Bugzilla::User::is_available_username('email@address.com') called at createaccount.cgi line 67 Expected Results: Confirmation of the added user

This looks like a duplicate of Bug 292718. Have you updated to the latest code in CVS?

Yeah, updating to CVS should fix this. *** This bug has been marked as a duplicate of 292718 ***