Last modified: 2010-05-15 15:56:49 UTC
I'm running mediawiki 1.68, an i got an error on most pages. 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 "Revision::fetchRow". MySQL returned error "1016: Can't open file: 'revision.MYI'. (errno: 145) (localhost)". If i look at the mysql server, it says that table Revision is in use. But there is nobody which use it right now. Can i unlock this table somehow? This site runs for a long time without problems. I did not any updates within the last days, so it should not be related to an update. It runs on a debian woody with mysql Ver 12.22 Distrib 4.0.24, for pc-linux-gnu (i386)
After some time spending in google, i found a solution. http://wiki.cotch.net/index.php/EvoWiki:Bug_reports REPAIR TABLE revision fixed this problem. But i still don't know the reason. cheers
MySQL problem - not MediaWiki.