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).

pgehres wrote:

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