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.
Topic on Project:Support desk
You can consolidate usernames using Extension:UserMerge!
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!
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.