Last modified: 2011-01-25 00:15:56 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 16861 - opening e-mail address confirmation link produces database error
opening e-mail address confirmation link produces database error
Product: Wikimedia
Classification: Unclassified
Site requests (Other open bugs)
All All
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
: shell
Depends on:
  Show dependency treegraph
Reported: 2009-01-02 16:31 UTC by Stephen Bannasch
Modified: 2011-01-25 00:15 UTC (History)
5 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Description Stephen Bannasch 2009-01-02 16:31:31 UTC
I registered an account at 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 (".

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.
Comment 1 Raimond Spekking 2009-01-02 16:38:42 UTC
Adding shell keyword. Investigations by a server admin needed.
Comment 2 Aaron Schulz 2009-01-02 17:32:24 UTC
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.
Comment 3 Aaron Schulz 2009-01-02 17:35:29 UTC
Possibly related to CentralAuth
Comment 4 Brion Vibber 2009-05-28 18:58:52 UTC
Has this issue ever reoccurred?
Comment 5 Mike.lifeguard 2010-05-02 20:42:50 UTC
(In reply to comment #4)
> Has this issue ever reoccurred?

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

Note You need to log in before you can comment on or make changes to this bug.