Steps to Reproduce:
https://wiki.travellerrpg.com/index.php?title=Instruments,_surgical&action=edit
I have looked through all the existing documentation around this issue, including many of the issues here, on stack overflow, and other places. I an unable to find any database corruption from these sources. All of the SHA1 fields in the revisions and content tables are populated. All of the links between the page, revision, slots, and content pages are correct (to my ability to query the database)
Relevant History:
The wiki was founded in Wikia in 2006. In 2013 the decision was to move out of Wikia. We got wikipedia export. Because Wikia was set up with a shared user database, the export had no user information in it. So when we imported the database into our new, local Mediawiki, all of the user information was not included. The import was brought into mediawiki version 1.21. We rebuilt the users by having them sign up again.
Late last year we upgrade from 1.24 to 1.31. The upgrade went perfectly to the best of our knowledge. There were no errors in the upgrade process. But we began to find a few of these pages with no data on them, they would display this "revision does not exist" error.
I've gone through the various fix scripts for this issue, but can't find any data corruption.
In digging further, I found that there are several entries in the revisions table where the rev_user_text is set but the rev_user is not (it has a value of 0). These are users who were active while we were in Wikia, but never showed back up in our new location, or we never fixed the entries. The revisions table has a name but no ID and there is no corresponding entry in the users table (or supporting tables).
This didn't cause problems in earlier versions of the database. So I selected one of these missing users "Marm6902". and chased this down further.
select page_id, page_namespace, page_title from mw_page, mw_revision where page_latest = rev_id and rev_user_text = 'Marm6902' page_id page_namespace page_title 8841 0 Instruments,_surgical 9662 1 Autopop 10581 0 Autoserver 10584 1 Foldsword 10852 1 Siliwishisee 10863 0 Auto-Angel 10865 14 Food_and_Drink 10868 1 Everfresh_Sandwiches 10884 14 Martial_arts 10934 1 GC96/B
Every one of these pages has this problem. The query find the pages which the active revision were edited by one of these missing users.
What broke? and how do I fix the underlying database to allow viewing / editing of these articles.