Page MenuHomePhabricator

Rename reverted magically
Open, NormalPublic

Description

A month ago I renamed [[w:zh:User:Shujenchang]] to User:ZH979433 on zhwiki. It was successful and the user made many edits under the new username.

It was noticed yesterday, all of sudden, that seems the rename was somehow reverted back to User:Shujenchang


Version: unspecified
Severity: normal

Details

Reference
bz47126

Event Timeline

bzimport raised the priority of this task from to Normal.Nov 22 2014, 1:29 AM
bzimport set Reference to bz47126.
bzimport added a subscriber: Unknown Object (MLST).
Bencmq created this task.Apr 11 2013, 3:27 PM

Below are links to details:

CentralAuth shows that User:ZH979433@zhwiki has 0 edits.
[[meta:Special:CentralAuth/ZH979433]]

but tools didn't pick up the local account.
http://toolserver.org/~quentinv57/tools/sulinfo.php?username=ZH979433
Due to the replag, a few hours ago the sulinfo tool still showed that ZH979433@zhwiki had 5000 edits.

Now we have an unmerged User:Shujenchang@zhwiki. All his edits seem to be attributed under this username, however [[w:zh:Special:Contributions/ZH979433]] and [[w:zh:Special:Contributions/Shujenchang]] are showing the exact same thing.

It looks like:

user_name in user table has been reverted.

  • 1. row ******* user_id: 979433 user_name: Shujenchang

every _user_text in other tables are not affected.

  • 1. row ******* rev_id: 25406107 rev_user: 979433 rev_user_text: ZH979433

Now [[w:zh:Special:Contributions/Shujenchang]] is querying revisions for a logged-in user, revisions are listed based on rev_user. [[w:zh:Special:Contributions/ZH979433]] is querying revs for anon users, and revs are listed by rev_user_text...

I redid the renaming.

A similar situation:

mysql> select * from revision where rev_id=24215946;

+----------+----------+---------------+

rev_idrev_userrev_user_text

+----------+----------+---------------+

24215946472601Sanyi4

+----------+----------+---------------+

However this revision belongs to Kontos, who was renamed to Sanyi4 in Feburary,

https://zh.wikipedia.org/w/index.php?title=Special%3A%E6%97%A5%E5%BF%97&type=renameuser&user=Bencmq&page=User%3AKontos&year=&month=-1&tagfilter=&uselang=en

Yet his rename is also somehow reverted

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 18 2015, 6:26 AM
Restricted Application added a subscriber: Cosine02. · View Herald TranscriptDec 21 2016, 9:58 AM