MediaWiki Repair

From Sequenza21/NetNewMusic Wiki

Here's a listing of some of the repair work performed here that might benefit other MediaWiki users:

---

1. Simple Table Corruptiion:

Error: A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

   (SQL query hidden)

from within function "". MySQL returned error "1016: Can't open file: 'searchindex.MYI'. (errno: 145) (localhost)".

Fix:

From phpMyAdmin or mysql shell type this SQL:

CHECK TABLE SEARCHINDEX (or the table mentioned like searchindex.MYI).

If it says there's corruption or errors:

Execute this:

REPAIR TABLE SEARCHINDEX

---