Last modified: 2013-09-20 19:39:44 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 T39417, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 37417 - templatelinks corruption
templatelinks corruption
Status: NEW
Product: Wikimedia
Classification: Unclassified
General/Unknown (Other open bugs)
unspecified
All All
: Low normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on: 36195
Blocks:
  Show dependency tree / graph
 
Reported: 2012-06-08 21:43 UTC by Betacommand
Modified: 2013-09-20 19:39 UTC (History)
3 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Betacommand 2012-06-08 21:43:34 UTC 
I am doing some querying with regards to templates and the first template that I decided to work with exposed an issue. I just ran  select count(*) from templatelinks where tl_namespace = 10 and tl_title = "Don't_know"; and it returned 255 however when you join tl_from to page_id (to get where the template is being used) all results are NULL. This shouldn't happen. I suspect either database corruption or incorrect processing of template links.
Comment 2 Betacommand 2012-06-08 21:57:01 UTC 
Doing some investigations and it looks like the newest page is from 2006
Comment 3 db [inactive,noenotif] 2012-06-16 20:24:43 UTC 
Some ghost entries are left in template links, see bug 36195 for maintenance script to be run for that case. Please compare your result of the select against live site (link in comment 1), if that is the same, the NULL entries are not a problem.
Comment 4 Betacommand 2012-06-16 22:02:19 UTC 
Errors are still present in the database
Comment 5 db [inactive,noenotif] 2012-09-16 07:19:59 UTC 
depends on bug 36195 to get the ghost entries removed.

Add a condition/join to check, if the pages exist or use the api to receive the data.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links