Last modified: 2014-01-09 01:39:24 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 T18674, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 16674 - Broken revisions with rev_page=0
Broken revisions with rev_page=0
Status: NEW
Product: Wikimedia
Classification: Unclassified
Site requests (Other open bugs)
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
Blocks: 16660 Wikisource
  Show dependency treegraph
Reported: 2008-12-16 18:29 UTC by Brion Vibber
Modified: 2014-01-09 01:39 UTC (History)
4 users (show)

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


Description Brion Vibber 2008-12-16 18:29:27 UTC
244 revisions on sourceswiki have rev_page=0, so they can't be loaded properly.

They date from 2004-2005, and at least some of them are current revisions on their pages (referenced by rev_latest).

Noted from

> The above links are appearing in Uncategorized Pages, but when I go to them, it says like
> > The database did not find the text of a page that it should have found, named "ऋग्वेद: सूक्तं 1.50" .
> > This is usually caused by following an outdated diff or history link to a page that has been deleted.
> > If this is not the case, you may have found a bug in the software. Please report this to an administrator, making note of the URL.
> hence reporting to you. Please suggest what is to be done. I have otherwise removed the problems of some > 400 Pages of Hindi/ Sanskrit that were listed in Uncategorized Pages yesterday.
Comment 1 Brion Vibber 2008-12-16 18:31:40 UTC
Ouch, only 3 are current. It may be difficult to recover the rest cleanly. :(

mysql> select page_id,page_latest from page,revision where page_latest=rev_id and rev_page=0;
| page_id | page_latest |
|   43896 |      133785 |
|   43898 |      133789 |
|   43910 |      133813 |
3 rows in set (0.13 sec)
Comment 2 John Mark Vandenberg 2011-09-25 05:31:59 UTC
On sourceswiki, there are now 245 revisions with rev_page=0; the extra one has a date stamp of 20081627
On enws there are two revisions with rev_page=0, both with datestamp of 20031218
For comparison, on enwp there are 709 revisions with rev_page=0
Comment 3 Ryan Kaldari 2013-01-04 19:09:47 UTC
There are 318 orphaned revisions on mediawikiwiki. This was the cause of bug 43625.
Comment 4 Ryan Kaldari 2013-01-04 21:03:15 UTC
Looks like new revs are still getting assigned to page_id 0 somehow.
Comment 5 This, that and the other (TTO) 2014-01-09 01:39:24 UTC
Bumping severity per comment 4

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