User Merge and Delete: 1.6.31
When attempting to merge/delete a users who was blocked for spamming, I got the following 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 "DatabaseBase::update". Database returned error "1062: Duplicate entry 'Spammer-2-0-0' for key 'ipb_address' (db.camera-wiki.org)".
Work-around: unblocking the user prior to using merge/delete solves the problem until the bug can be fixed.
Additional info: Our wiki has an account called "Spammer" into which we merge/delete all spammers. This process worked great up until MediaWiki 1.18 at which point we started getting numerous SQL errors during the process. We have already applied the ipb_id to ipb_user change to fix a previous SQL bug.