Last modified: 2013-05-14 16:07:00 UTC
English Wikipedia [[User:Zoeb]] was renamed to [[User:ZoeB]] on February 12, 2013. http://en.wikipedia.org/w/index.php?title=Special%3ALog&type=renameuser&user=MBisanz&page=User%3AZoeb&year=&month=-1&tagfilter= Now I see the same set of contributions at both: http://en.wikipedia.org/wiki/Special:Contributions/ZoeB and http://en.wikipedia.org/wiki/Special:Contributions/Zoeb The system indicates the rename failed and that no user ZoeB exists, but the log shows it occurred and the contributions' history shows something was moved over.
mysql:wikiadmin@db1017 [enwiki]> select user_id, user_name from user where user_name = 'Zoeb'; +---------+-----------+ | user_id | user_name | +---------+-----------+ | 7882 | Zoeb | +---------+-----------+ 1 row in set (0.02 sec) mysql:wikiadmin@db1017 [enwiki]> select user_id, user_name from user where user_name = 'ZoeB'; Empty set (0.03 sec) Is the user even able to login now? :/
Well they've edited since the rename, so I would imagine so.
Also interesting is http://en.wikipedia.org/w/index.php?title=Special%3ALog&type=newusers&user=Zoeb&page=&year=&month=-1&tagfilter=&hide_patrol_log=1&hide_review_log=1 which shows that the account Zoeb was never created.
He can edit! http://en.wikipedia.org/w/index.php?title=User_talk:MBisanz&diff=544777258&oldid=544674546 But it's still broken.
Need to update the user table, then run renameUserCleanup.php to catch any revisions that they've made since the failed rename.
Hi! I'm the user in question. I was able to log in with the username "ZoeB" for a short while, and things were looking good, but now I can only log in as "Zoeb" again, and all my edits are showing up as "Zoeb" again, much to my chagrin. So yes, I (incidentally, "she", not "he") can log in and edit, but now only using my old username again, not my new one. Thanks for all your help!
What a mess. :-/ Sorry about the hassle, Zoë. Reedy or another shell user will fix this shortly.
Assigning this to Reedy for now. If Chris or some other shell user wants to clean this up, that'd be fine as well, of course.
No worries. Sorry I broke a bit of Wikipedia! (If it's any consolation, I've had similar issues myself using Git in OS X, with the partial case sensitivity. In that instance, renaming the thing in question to something completely different, then back again only with the new case, fixed it. I have no idea if that's applicable here though. I've never used MySQL in a case sensitive context, I'm afraid. Sorry I couldn't be of any help!)
Should be all fixed now...
Perfect, thankyou very much!