Topic on Extension talk:UserMerge

[WORKAROUND; DUPLICATE Bug 39470] Can't merge blocked users: Duplicate entry for key 'ipb_address'.Database error: Duplicate entry

7
Summary last edited by Ciencia Al Poder 20:10, 30 June 2014 9 years ago

Known problem.

Will be fixed soon, filed as Bug 39470: Can't merge blocked users: Duplicate entry for key 'ipb_address'.

See workaround in bug 39470 and Thread:Extension talk:UserMerge/Duplicate entry

Work-around: unblocking the user prior to using merge/delete solves the problem until the bug can be fixed.

Please, if your problem persists, then please add your comment to bug 39470, not here.

77.12.18.199 (talkcontribs)

When i try to merge user, when i send the fomular, i get the error:

Database error A database query error has occurred. This may indicate a bug in the software.

i did not find a solution with an internet search. does anybody have an idea how to solve this?

wikimedia version 23

Wikinaut (talkcontribs)

Please indicate your version (core, database, php, UserMerge) as shown on the Special:Version page of your wiki.

77.186.59.204 (talkcontribs)

Hey Wikinaut: here are the version information: Product Version MediaWiki 1.23.1 PHP 5.3.3-7+squeeze18 (cgi-fcgi) MySQL 5.1.73-1-log User Merge and Delete 1.9.0

Ciencia Al Poder (talkcontribs)

It would be useful to set those variables in LocalSettings PHP, reproduce the problem, and pasting the full error message. It should contain at least what database query failed and the cause:

$wgShowSQLErrors = true;
$wgDebugDumpSql  = true;
$wgShowDBErrorBacktrace = true;
77.186.59.204 (talkcontribs)

this is a good advice.

im nevertheless not sure how to solve this problem:

A database query error has occurred. This may indicate a bug in the software.

    Query:
    UPDATE `ipblocks` SET ipb_user = '149',ipb_address = 'ZinaidaBryson' WHERE ipb_user = '350'
    Function: UserMerge::mergeUser
    Error: 1062 Duplicate entry 'ZinaidaBryson-149-0-0' for key 'ipb_address' (localhost)

Backtrace:

#0 /var/www/web/html/wiki/includes/db/Database.php(1123): DatabaseBase->reportQueryError('Duplicate entry...', 1062, 'UPDATE  `ipbloc...', 'UserMerge::merg...', false)
#1 /var/www/web/html/wiki/includes/db/Database.php(1986): DatabaseBase->query('UPDATE  `ipbloc...', 'UserMerge::merg...')
#2 /var/www/web/html/wiki/extensions/UserMerge/UserMerge_body.php(434): DatabaseBase->update('ipblocks', Array, Array, 'UserMerge::merg...')
#3 /var/www/web/html/wiki/extensions/UserMerge/UserMerge_body.php(260): UserMerge->mergeUser(Object(User), 'ZinaidaBryson', '149', Object(User), 'Abbotthcfo', '350')
#4 /var/www/web/html/wiki/includes/specialpage/SpecialPage.php(379): UserMerge->execute(NULL)
#5 /var/www/web/html/wiki/includes/specialpage/SpecialPageFactory.php(503): SpecialPage->run(NULL)
#6 /var/www/web/html/wiki/includes/Wiki.php(285): SpecialPageFactory::executePath(Object(Title), Object(RequestContext))
#7 /var/www/web/html/wiki/includes/Wiki.php(588): MediaWiki->performRequest()
#8 /var/www/web/html/wiki/includes/Wiki.php(447): MediaWiki->main()
#9 /var/www/web/html/wiki/index.php(46): MediaWiki->run()
#10 {main}
Wikinaut (talkcontribs)
Cmjohannes (talkcontribs)

Started own thread because I was unsure if it was the same bug as the above user.

Reply to "[WORKAROUND; DUPLICATE Bug 39470] Can't merge blocked users: Duplicate entry for key 'ipb_address'.Database error: Duplicate entry"