Closed Bug 516020 Opened 12 years ago Closed 12 years ago

Unique-ify nicknames

Categories

(addons.mozilla.org Graveyard :: Developer Pages, defect, P1)

defect

Tracking

(Not tracked)

VERIFIED FIXED

People

(Reporter: fligtar, Assigned: oremj)

Details

Attachments

(1 file)

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.
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: clouserw → jeremy.orem+bugs
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
Closed: 12 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.