https://bugzilla.wikimedia.org/show_bug.cgi?id=39470
Web browser: ---
Bug #: 39470
Summary: error "1062: Duplicate entry 'Spammer-2-0-0'
Product: MediaWiki extensions
Version: unspecified
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: UserMerge
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
Mobile Platform: ---
Versions:
MediaWiki: 1.18.3
PHP: 5.2.17
MySQL: 5.1.39
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.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
