Last modified: 2014-01-09 01:39:24 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.
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)
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
There are 318 orphaned revisions on mediawikiwiki. This was the cause of bug 43625.
Looks like new revs are still getting assigned to page_id 0 somehow.
Bumping severity per comment 4
