Page MenuHomePhabricator

Broken logs after special page name change
Closed, ResolvedPublic

Description

Hi. Once upon a time the page to create and change wikisets was called Special:EditWikiSets. Changes were logged at the global rights log as this (taking Special:EditWikiSets/2 as example [the global bot wikis]):

https://meta.wikimedia.org/w/index.php?title=Special%3ALog&type=gblrights&user=&page=Special%3AEditWikiSets%2F2&year=&month=-1&tagfilter=

Now, the page is called Special:WikiSets, so changes are logged as Special:WikiSets/<number of wikiset>:

https://meta.wikimedia.org/w/index.php?title=Special%3ALog&type=gblrights&user=&page=Special%3AWikiSets%2F2&year=&month=-1&tagfilter=

So, because of the rename of the special page the logs ore split in two. This causes confusion and lack of transparency.

I hope the explanation is clear. Notwithstanding I've CCd another steward who can explain better.

Thank you.


Version: unspecified
Severity: major

Details

Reference
bz34877

Event Timeline

bzimport raised the priority of this task from to Low.Nov 22 2014, 12:17 AM
bzimport set Reference to bz34877.
bzimport added a subscriber: Unknown Object (MLST).

Fixed "blocks" section. Bug number was incorrect.

This should be done by establishing a special page alias.

It has an alias. But logs use the stored canonical version, which has changed.

MariaDB [metawiki_p]> select count(*) from logging where log_type="gblrights" and log_namespace=-1 and log_title like "EditWikiSets/%";
+----------+

count(*)

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

304

+----------+
1 row in set (0.05 sec)

I think all we need to do is fix the log_title field. Will this work?

UPDATE logging SET log_title = REPLACE(log_title, 'EditWikiSets', 'WikiSets') WHERE log_type="gblrights" AND log_namespace=-1 AND log_title like "EditWikiSets/%";

Krenair claimed this task.
Krenair subscribed.

Ran on metawiki:

mysql> /* T36877 */ UPDATE logging SET log_title = REPLACE(log_title, 'EditWikiSets', 'WikiSets') WHERE log_type="gblrights" AND log_namespace=-1 AND log_title like "EditWikiSets/%";
Query OK, 304 rows affected (0.84 sec)
Rows matched: 304  Changed: 304  Warnings: 0

I don't think we need to provide anything generic in the extension, so closing this.