Last modified: 2013-07-25 09:16:41 UTC
Generally, the extension:UserMerge works fine, but while trying to merge and delete one specific user, the operation fails. 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 "DatabaseBase::update". Database returned error "1062: Duplicate entry '1-0-VIAF' for key 'wl_user' (localhost)".
The problem is already mentioned here https://www.mediawiki.org/wiki/Extension_talk:UserMerge#Workaround and happens, when the old user ("merge from old user") and the new user ("merge to new user") have same active watch list entries. The error message is then this one Cannot set `wl_user` = '1234' WHERE `wl_user` = '10'. MySQL error 1062: - Duplicate entry '1234-0-Main Page' for key 1" One suggested solution is: ========================== to delete ***one*** of those both watchlist entries which old and new user have in common, and then to merge.
patch in gerrit https://gerrit.wikimedia.org/r/#/c/69017/ see requirements (requires MediaWiki after 2013-06-25)
solved: https://gerrit.wikimedia.org/r/#/c/69017/ is already merged after review
