Last modified: 2009-12-12 14:46:46 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T14168, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 12168 - Ghost entries in bgwiki.categorylinks; wanted categories affected
Ghost entries in bgwiki.categorylinks; wanted categories affected
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
All All
: Normal trivial (vote)
: ---
Assigned To: Rob Halsell
: shell
Depends on:
Blocks: 16660
  Show dependency treegraph
Reported: 2007-11-30 19:19 UTC by Borislav Manolov
Modified: 2009-12-12 14:46 UTC (History)
3 users (show)

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


Description Borislav Manolov 2007-11-30 19:19:08 UTC
There are two categories on bgwiki ( 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

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.
Comment 1 Brion Vibber 2009-05-28 19:12:54 UTC
Sounds like it needs a refresh. May already be clear by now, this was a while ago...
Comment 2 Borislav Manolov 2009-05-28 20:45:42 UTC
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;
Comment 3 Rob Halsell 2009-08-07 19:53:34 UTC
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)
Comment 4 Roan Kattouw 2009-12-12 14:46:46 UTC
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.

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