Closed Bug 296075 Opened 20 years ago Closed 20 years ago

SQL-fault when trying to add a new user account (PostgreSQL)

Categories

(Bugzilla :: User Accounts, defect)

2.19.3
defect
Not set
normal

Tracking

()

RESOLVED DUPLICATE of bug 292718

People

(Reporter: werner, Unassigned)

References

Details

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
Blocks: bz-postgres
Version: unspecified → 2.19.3
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 ***
Status: UNCONFIRMED → RESOLVED
Closed: 20 years ago
OS: Linux → All
Hardware: PC → All
Resolution: --- → DUPLICATE
You need to log in before you can comment on or make changes to this bug.