Our Wiki at http://www.mega-tokyo.com/osfaq2/ has been severely corrupted, apparently the "recents" table got killed. That means, all pages are still there if you request them by URL, but PhpWiki fails to "know" them for the sake of WikiLinks, AllPages, or dumping contents as ZIP.
Now, what could we do to recover this mess? This is pretty urgent, as our Wiki is more or less rendered inoperable, and we would be reluctant to fall back to some older backup. Help would be much appreciated.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
replace into wiki136_recent select id, version as latestversion, version as latestmajor, NULL from wiki136_version order by id asc, version asc
I then purged the markup cache...
and it recreated the table the same as after I did the mysqlcheck --repair.
we still have loads of links missing... all other tables are fine and all page data is there in the version table etc.
my only other option is to open the page thats missing, save the markup from edit mode, delete the page and re-create it... luckily the todo page lists all the pages that have become unlinked...
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Our Wiki at http://www.mega-tokyo.com/osfaq2/ has been severely corrupted, apparently the "recents" table got killed. That means, all pages are still there if you request them by URL, but PhpWiki fails to "know" them for the sake of WikiLinks, AllPages, or dumping contents as ZIP.
Now, what could we do to recover this mess? This is pretty urgent, as our Wiki is more or less rendered inoperable, and we would be reluctant to fall back to some older backup. Help would be much appreciated.
let's talk per email, please.
you'd need to recreate your recent table with some sql commands, which should be doable.
what about mysqlcheck --repair?
if really only the recent table is broken, this generates a new one!
replace into recent select id, version as latestversion, version as latestmajor, NULL from version order by id asc, version asc;
I ran
i emptied the table and ran;
replace into wiki136_recent select id, version as latestversion, version as latestmajor, NULL from wiki136_version order by id asc, version asc
I then purged the markup cache...
and it recreated the table the same as after I did the mysqlcheck --repair.
we still have loads of links missing... all other tables are fine and all page data is there in the version table etc.
my only other option is to open the page thats missing, save the markup from edit mode, delete the page and re-create it... luckily the todo page lists all the pages that have become unlinked...
So your link table is broken also.
To recreate all your links automatically I would do a dumphtml.
This renders all pages and stores the links again.
I dumped the pages, emptied the tables and reloaded the dump... Any pages there were there but unlinked in have disappeared....
i dropped all tables and restored a mysql dump I did prior to doing the wiki dumphtml...
when i did the 'edit page, copy markup, delete page, relick on the ?.. paste markup. save'. it created all the other pages that were haning!
problems solved I guess...