Last modified: 2014-01-09 01:39:24 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 16674 - Broken revisions with rev_page=0
Broken revisions with rev_page=0
Status: NEW
Product: Wikimedia
Classification: Unclassified
Site requests (Other open bugs)
unspecified
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
http://wikisource.org/wiki/%E0%A4%8B%...
:
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: ---


Attachments

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 http://wikisource.org/wiki/Wikisource:Scriptorium#database_did_not_find_the_text_of_a_page

> http://wikisource.org/wiki/%E0%A4%8B%E0%A4%97%E0%A5%8D%E0%A4%B5%E0%A5%87%E0%A4%A6:_%E0%A4%B8%E0%A5%82%E0%A4%95%E0%A5%8D%E0%A4%A4%E0%A4%82_1.36
> http://wikisource.org/wiki/%E0%A4%8B%E0%A4%97%E0%A5%8D%E0%A4%B5%E0%A5%87%E0%A4%A6:_%E0%A4%B8%E0%A5%82%E0%A4%95%E0%A5%8D%E0%A4%A4%E0%A4%82_1.38
> http://wikisource.org/wiki/%E0%A4%8B%E0%A4%97%E0%A5%8D%E0%A4%B5%E0%A5%87%E0%A4%A6:_%E0%A4%B8%E0%A5%82%E0%A4%95%E0%A5%8D%E0%A4%A4%E0%A4%82_1.50
> 
> 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.


Navigation
Links