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

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T18861, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 16861 - opening e-mail address confirmation link produces database error
opening e-mail address confirmation link produces database error
Status: RESOLVED WORKSFORME
Product: Wikimedia
Classification: Unclassified
Site requests (Other open bugs)
unspecified
All All
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
: shell
Depends on:
Blocks:
  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: ---


Attachments

Description Stephen Bannasch 2009-01-02 16:31:31 UTC
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.
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.


Navigation
Links