Last modified: 2009-12-12 14:46:46 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 12168 - Ghost entries in bgwiki.categorylinks; wanted categories affected
Ghost entries in bgwiki.categorylinks; wanted categories affected
Status: RESOLVED FIXED
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: Normal trivial (vote)
: ---
Assigned To: Rob Halsell
http://bg.wikipedia.org/wiki/Special:...
: 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: ---


Attachments

Description Borislav Manolov 2007-11-30 19:19:08 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.
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.


Navigation
Links