Last modified: 2012-07-13 14:44:47 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 10667 - Category link tables sometimes contain orphaned entries
Category link tables sometimes contain orphaned entries
Status: NEW
Product: MediaWiki
Classification: Unclassified
Categories (Other open bugs)
unspecified
All All
: Low normal (vote)
: ---
Assigned To: Nobody - You can work on this!
http://cs.wikipedia.org/wiki/Speci%C3...
:
Depends on:
Blocks: 16660
  Show dependency treegraph
 
Reported: 2007-07-23 14:51 UTC by Danny B.
Modified: 2012-07-13 14:44 UTC (History)
4 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Danny B. 2007-07-23 14:51:52 UTC
http://cs.wikipedia.org/wiki/Speci%C3%A1ln%C3%AD:Wantedcategories contains "Matematikové" and "Fyzikové" for weeks although not used anywhere.
Comment 1 Brion Vibber 2007-07-23 15:47:43 UTC
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.
Comment 2 Brion Vibber 2007-07-23 17:53:55 UTC
Running a cleanup on that wiki, but there's still the general problem.
Comment 3 Aryeh Gregor (not reading bugmail, please e-mail directly) 2007-07-23 19:20:51 UTC
Clearly we need to declare foreign keys.  ;)
Comment 4 RockMFR 2007-08-07 18:48:32 UTC
Would it be possible to run a cleanup on enwiki? Category:Stub and a number of others have been clogging the list for ages :(
Comment 5 uv.wiki 2011-12-13 17:57:06 UTC
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?
Comment 6 Umherirrender 2012-07-13 14:44:47 UTC
See bug 16112/bug 36195

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links