Page MenuHomePhabricator
Create Task
Maniphest T47035

Error while merging accounts with MergeAccount on WikiVoyage: "1062: Duplicate entry for key 'wl_user'"
Open, MediumPublic
Actions

Description

Several times we got database error like the following one:

Es ist ein Datenbankfehler aufgetreten. Der Grund kann ein Programmierfehler sein. Die letzte Datenbankabfrage lautete:
transl: A database error occurs. Maybe, the cause could be a programmer's mistake. The last query was:

(Die SQL-Datenbankabfrage ist verborgen.)
transl: The sql query is hidden.

aus der Funktion „DatabaseBase::update“. Die Datenbank meldete den Fehler „1062: Duplicate entry '5567-2-Celsius' for key 'wl_user' (10.64.16.8)“.

transl.: from the function „DatabaseBase::update“. The database returned the error message: „1062: Duplicate entry '5567-2-Celsius' for key 'wl_user' (10.64.16.8)“.

Version: REL1_20-branch
Severity: normal

Details

Reference
bz45035

Event Timeline

• bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:30 AM
• bzimport added a project: MediaWiki-extensions-CentralAuth.
• bzimport set Reference to bz45035.
• bzimport added a subscriber: Unknown Object (MLST).
RolandUnger created this task.Feb 15 2013, 6:20 AM
Aklapper added a comment.Feb 18 2013, 10:09 AM

Hi Roland, please see http://www.mediawiki.org/wiki/Manual:How_to_debug#SQL_errors for how to display the hidden SQL query, and paste it here. Thanks!

RolandUnger added a comment.Feb 18 2013, 10:26 AM

Hi Andre,
because Wikivoyage is a WMF project we have no access to LocalSettings.php

Aklapper added a comment.Feb 18 2013, 10:59 AM

Ah. Wasn't clear to me that it's about Wikivoyage, sorry. Thought this is a private MediaWiki installation... :)

Legoktm added a comment.Sep 16 2014, 9:39 PM

Was this Special:MergeAccount or Special:UserMerge?

RolandUnger added a comment.Oct 1 2014, 11:09 AM

I think it was Special:MergeAccount. But this service was stopped some time ago to our wiki. It seems that the error occurs if users edited the user pages of the account to merge.

• werdna unsubscribed.Dec 10 2014, 5:24 PM
Paladox set Security to None.Apr 26 2015, 6:00 PM
Liuxinyu970226 subscribed.May 25 2015, 1:41 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL