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)

Product:
Bugzilla
Component:
User Accounts
Version:
2.19.3
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
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.