Page MenuHomePhabricator

Category link tables sometimes contain orphaned entries
Open, LowPublic

Description

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

Details

Reference
bz10667

Related Objects

Event Timeline

bzimport raised the priority of this task from to Low.Nov 21 2014, 9:50 PM
bzimport set Reference to bz10667.
bzimport added a subscriber: Unknown Object (MLST).
Danny_B created this task.Jul 23 2007, 2:51 PM
brion added a comment.Jul 23 2007, 3:47 PM

There appear to be orphaned entries in the categorylinks table:

mysql> select * from categorylinks where cl_to='Matematikové';
+---------+---------------+------------------------+----------------+

cl_fromcl_tocl_sortkeycl_timestamp

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

23285MatematikovéAlfred North Whitehead20050619191505

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

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.

brion added a comment.Jul 23 2007, 5:53 PM

Running a cleanup on that wiki, but there's still the general problem.

ayg wrote:

Clearly we need to declare foreign keys. ;)

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 :(

UV added a comment.Dec 13 2011, 5:57 PM

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?

See bug 16112/bug 36195