opening e-mail address confirmation link produces database error
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	• bzimport
	Jan 2 2009, 4:31 PM

Description

Author: stephen.bannasch

Description:
I registered an account at en.wikipedia.org with the username stepheneb.

I received an e-mail address confirmation and when I clicked on the link the site reported a Database error:

Database error
A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:
(SQL query hidden)
from within function "User::addToDatabase". MySQL returned error "1062: Duplicate entry 'Stepheneb' for key 2 (10.0.0.235)".

I have been able to login using the new account.

I don't think I had created this account previously but is is possible I had several years ago.

There was no indication until clicking the confirm link that this could be a duplicate account.

Version: unspecified
Severity: major

Details

Reference: bz16861

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 21 2014, 10:28 PM

• bzimport added projects: Wikimedia-Site-requests, Shell.

• bzimport set Reference to bz16861.

• bzimport added a subscriber: Unknown Object (MLST).

• bzimport created this task.Jan 2 2009, 4:31 PM

Adding shell keyword. Investigations by a server admin needed.

Confirmemail should not be calling addToDatabase().

Anyway, I just removed and re-added my email to get the confirmation email. I clicked it, and it worked fine.

Possibly related to CentralAuth

Has this issue ever reoccurred?

mike.lifeguard+bugs wrote:

(In reply to comment #4)

Has this issue ever reoccurred?

Barring evidence it has, this is just clogging up bugzilla.

opening e-mail address confirmation link produces database errorClosed, DeclinedPublicActions

Description

Details

Event Timeline

opening e-mail address confirmation link produces database error
Closed, DeclinedPublic
Actions