We have a bunch of nicknames that are duplicates: http://pastebin.mozilla.org/670801 We should probably write a quick script to fix these, with users who have add-ons getting to keep their nickname, followed by the oldest of the users. The duplicates should have one or more underscores appended to the nickname.
http://pastebin.mozilla.org/671663 is a list that will last a while. Query at the top if you want to grab it yourself. You can ignore the million people with a blank username, and "Deleted User" - we'll turn those into null with SQL.
Comment on attachment 401313 [details] [diff] [review] Makes all user.nicknames unique. Not even Beyonce could write a script that well. Please check in to /bin/run_once/
Attachment #401313 - Flags: review?(clouserw) → review+
Status: NEW → RESOLVED
Last Resolved: 10 years ago
Resolution: --- → FIXED
Status: RESOLVED → VERIFIED
Product: addons.mozilla.org → addons.mozilla.org Graveyard
You need to log in before you can comment on or make changes to this bug.