Last modified: 2009-12-12 14:46:46 UTC
There are two categories on bgwiki (http://bg.wikipedia.org) which are listed as wanted categories but do not contain any real pages. This happens because the database table bgwiki.categorylinks contains entries for this categories where the column cl_from does not refer to any real page_id from the table bgwiki.page. The two categories are "Транс-нептунови_обекти" and "Катедрала". Here is an extract from the table bgwiki.categorylinks. +---------+------------------------+----------------------------+-------------------- | cl_from | cl_to | cl_sortkey | cl_timestamp +---------+------------------------+----------------------------+-------------------- | 50238 | Транс-нептунови_обекти | Харон (спътник) | 2005-04-28 05:54:32 | 50239 | Транс-нептунови_обекти | Харон (спътник) | 2005-04-28 05:54:32 | 53857 | Катедрала | Парижката Света Богородица | 2005-05-27 16:48:23 +---------+------------------------+----------------------------+-------------------- These ghost entries should be deleted manually from the table bgwiki.categorylinks as there is no such possibility to do this through the MediaWiki interface.
Sounds like it needs a refresh. May already be clear by now, this was a while ago...
Currently there are 25 entries in the bgwiki.categorylinks table with a cl_from key which doesn't correspond to any page_id from the page table. Their timestamps lie between 2005-04-28 and 2005-06-01. Hopefully they will not become evergreens. :-) Only two of the categories from these entries do not exist so they show up on the Wanted Categories list. These are our old friends, Транс-нептунови_обекти and Катедрала. A quick check SQL query: SELECT c.* FROM categorylinks c LEFT JOIN page ON cl_from = page_id WHERE page_id IS NULL AND cl_from > 0;
I am currently running the refreshLinks script against bgwiki. Unfortunatly, this will take atleast a couple of hours to run. Once it is finished, I will close out this ticket. (Currently running script in a screen session on Hume)
mysql> SELECT c.* FROM categorylinks c -> LEFT JOIN page ON cl_from = page_id -> WHERE page_id IS NULL AND cl_from > 0; Empty set (5.98 sec) Looks like this was fixed.
