Topic on Project:Support desk

Upgrade from MW 1.18.1 to 1.23.5 left duplicate users with Uppercase Uppercase rest lowercase USernames and now apparently standard Uppercase rest lowercase Usernames.

4
Tcaton-nm (talkcontribs)

Upgrade from MW 1.18.1 to 1.23.5 left duplicate users with Uppercase Uppercase rest lowercase USernames and now apparently standard Uppercase rest lowercase Usernames.

Is there a script to consolidate duplicate users and switch old userids in other tables to new single userid?

Thank You.

88.130.80.152 (talkcontribs)
Tcaton-nm (talkcontribs)

Attempted to use Extension:UserMerge to merge: USername to Username.
Error: The old and new usernames need to be distinct.

Change Username to Username1 in database.
Merge USername to Username1 fails:
Error: Invalid old username.

Changing USername to USername1
Merge USername1 to Username fails:
Error: Invalid old username.

Only way to fix is delete all USernames from database and leave orphaned records!

Tcaton-nm (talkcontribs)

Renamed in Database: USername to U1ername.

Merged: U1ername to Username, with success.


Can anyone tell me if this will either break anything or leave orphaned records?


Thanks.

Reply to "Upgrade from MW 1.18.1 to 1.23.5 left duplicate users with Uppercase Uppercase rest lowercase USernames and now apparently standard Uppercase rest lowercase Usernames."