Last modified: 2013-07-16 18:31:53 UTC
Please see bug 20446 Please create a maintenance script to convert all user rights log entries at Meta-Wiki in the type User:A@metawiki to User:A. Example: <https://meta.wikimedia.org/w/index.php?title=Special%3ALog&type=rights&user=&page=User%3AMike.lifeguard%40metawiki&year=&month=-1&tagfilter=>; although there are a lot more from other stewards before the bug I cite above was fixed. This, as it is, splits the user rights log of a single user in two, which is annoying. Best regards.
Priority set to low, tho should be done eventually.
Gerrit change #43689
Based on Tyler Romeo's comments I think this single SQL query may actually do it: UPDATE logging SET log_title = SUBSTR(log_title, 1, INSTR(log_title, '@metawiki') - 1) WHERE log_title LIKE '%@metawiki'; Therefore we may not even need a maintenance script. Third-party users of the interwiki userrights system would just need to replace @metawiki with their $wgUserrightsInterwikiDelimiter and wiki ID (database name and table prefix IIRC).
I see 272 rows in metawiki.logging for 71 different users. I also can confirm that the above query generates the expected outcome when run as a select on a slave.
mysql:wikiadmin@db1041 [metawiki]> UPDATE logging SET log_title = SUBSTR(log_title, 1, INSTR(log_title, -> '@metawiki') - 1) WHERE log_title LIKE '%@metawiki'; Query OK, 272 rows affected (16.55 sec) Rows matched: 272 Changed: 272 Warnings: 0
