Last modified: 2012-07-06 17:00:36 UTC
Created attachment 10352 [details] Commons files with type "page" in categorylinks table The Commons database contains categorylinks for files with type "page". But files should have type "file". I think this error may exist in other databases too. Bug 29787 was about a category in English Wikipedia, but that was fixed by null edits. Now null edits does not seem to fix the errors at Commons. Bug 29787 has an example of problems caused by this bug.
Moving attachment contents to url field.
The content of attachment 10352 [details] has been deleted by Mark A. Hershberger <mah@everybody.org> who provided the following reason: should be in url field The token used to delete this attachment was generated at 2012-04-02 16:58:03 UTC.
All of these appear to have cl_collation field set to ''. Thus running updateCollations.php should fix the issue. My query on toolserver db said that there were 48331 such affected rows on commons. And they seem to have happened on July 7, 2011. I don't know what happened at that time. The pages I looked at weren't edited at that time. In the server admin log the only thing happening to commons at that time that i saw was CleanupTitles.php and NamespaceDupesWT.php were running. I'm not sure how that could cause this. Anyhow running updateCollation.php should fix the issue as it will see it as an old style row and update it appropriately.
Note, there is also 15695 such rows on enwiki.
mysql> explain select count(*) from categorylinks where cl_collation = ''; +----+-------------+---------------+------+---------------+--------------+---------+-------+--------+--------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------+------+---------------+--------------+---------+-------+--------+--------------------------+ | 1 | SIMPLE | categorylinks | ref | cl_collation | cl_collation | 34 | const | 115866 | Using where; Using index | +----+-------------+---------------+------+---------------+--------------+---------+-------+--------+--------------------------+ 1 row in set (0.00 sec) Running updateCollation.php against commonswiki currently...
mysql> explain select count(*) from categorylinks where cl_collation != 'uppercase'; +----+-------------+---------------+-------+---------------+--------------+---------+------+-------+--------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------+-------+---------------+--------------+---------+------+-------+--------------------------+ | 1 | SIMPLE | categorylinks | range | cl_collation | cl_collation | 34 | NULL | 60341 | Using where; Using index | +----+-------------+---------------+-------+---------------+--------------+---------+------+-------+--------------------------+ 1 row in set (0.02 sec)
Enwiki is clean now. Running it via foreachwiki, seems most wikis are clean, but not all, just noticed cawiki and dewiki weren't (for a couple of examples)
Doned
