Status

defect
P1
normal
VERIFIED FIXED
10 years ago
3 years ago

People

(Reporter: fligtar, Assigned: oremj)

Tracking

unspecified

Details

Attachments

(1 attachment)

(Reporter)

Description

10 years ago
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.
(Reporter)

Updated

10 years ago
Assignee: nobody → clouserw
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.
(Assignee)

Updated

10 years ago
Assignee: clouserw → jeremy.orem+bugs
(Assignee)

Comment 2

10 years ago
Attachment #401313 - Flags: review?(clouserw)
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+
r51819, thanks!
Status: NEW → RESOLVED
Last Resolved: 10 years ago
Resolution: --- → FIXED
No longer blocks: 518717
Verified, 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.