Last modified: 2010-05-15 15:42:46 UTC
When I try to change a contents in a page the following error occurs:
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 "SearchMySQL4::update". MySQL returned error "145:
Table './hwasungmars_mw/mediaWiki_searchindex' is marked as crashed and should be repaired (localhost)".
I tried the mysql check table command with ALL of the options available, but I could not find any
errors. One amazing this is that even though the error message pops out, if I refresh it, it works.
Here are some version information:
PHP: 5.1.6 (apache2handler)
OS: Ubuntu Linux Server Edgy
I hope this is not a big problem.
This is not a MediaWiki bug; your database server simply crashed at some point
and requires the MyISAM tables which were open at the time of the crash to be
checked for consistency.
The searchindex table is especially vulnerable to this due to the use of
MyISAM table format instead of more reliable InnoDB, as required for the
(This is a general MySQL issue, so I'm going ahead and closing the bug here.)
You most likely simply need to issue MySQL's 'REPAIR TABLE' command, such as:
REPAIR TABLE mediaWiki_searchindex;
For more information, please see: