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: MediaWiki: 1.8.2 PHP: 5.1.6 (apache2handler) MySQL: 5.0.24a-Debian_9-log CPU: x86_64 OS: Ubuntu Linux Server Edgy Kernel: 2.6.17-10-server Website: http://www.hwasungmars.net 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 fulltext index. (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: http://dev.mysql.com/doc/refman/5.0/en/repair-table.html http://dev.mysql.com/doc/refman/5.0/en/crashing.html http://dev.mysql.com/doc/refman/5.0/en/myisam-table-problems.html
