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)
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
Reporter | ||
Updated•20 years ago
|
Blocks: bz-postgres
Version: unspecified → 2.19.3
Comment 1•20 years ago
|
||
This looks like a duplicate of Bug 292718.
Have you updated to the latest code in CVS?
Comment 2•20 years ago
|
||
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.
Description
•