http://cs.wikipedia.org/wiki/Speci%C3%A1ln%C3%AD:Wantedcategories contains "Matematikové" and "Fyzikové" for weeks although not used anywhere.
Version: unspecified
Severity: normal
URL: http://cs.wikipedia.org/wiki/Speci%C3%A1ln%C3%AD:Wantedcategories
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | Feature | None | T18660 Database table cleanup (tracking) | ||
| Resolved | None | T12667 Category link tables sometimes contain orphaned entries |
There appear to be orphaned entries in the categorylinks table:
mysql> select * from categorylinks where cl_to='Matematikové';
+---------+---------------+------------------------+----------------+
| cl_from | cl_to | cl_sortkey | cl_timestamp |
+---------+---------------+------------------------+----------------+
| 23285 | Matematikové | Alfred North Whitehead | 20050619191505 |
+---------+---------------+------------------------+----------------+
There's no matching page record, so the category page view doesn't list anything, but it still comes up in the counts for Special:Wantedcategories.
rockmfr wrote:
Would it be possible to run a cleanup on enwiki? Category:Stub and a number of others have been clogging the list for ages :(
On lawiki, there are entries in the categorylinks table where the cl_from pageid has the value 0:
(0,'Usor_alias','I18n','2008-02-11 00:54:38','','','page'),
(0,'Usor_de-0','RunJobs.php','2008-02-11 00:54:38','','','page'),
(0,'Usor_en-0','RunJobs.php','2008-02-11 00:54:38','','','page'),
(0,'Usor_fr-0','RunJobs.php','2008-02-11 00:54:38','','','page'),
(0,'Usor_la-0','RunJobs.php','2008-02-11 00:54:38','','','page'),
(0,'Usor_ru-0','RunJobs.php','2008-02-11 00:54:38','','','page'),
These templates have been deleted several weeks ago. Therefore, these entries in the categorylinks table cause the templates wrongly to show up at Special:Wantedcategories.
Would it be possible to run a cleanup on lawiki?