On 10/01/2008, Craig White craig@galbijim.com wrote:
Sorry if the last email submission didn't work right.
I'm starting to get an increase of database errors when editing random pages. This is the error I am getting:
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 "1034: Incorrect key file for table 'searchindex'; try to repair it (localhost)".
Any ideas on how to resolve and why this is suddenly happening out of the blue?
Thanks, Craig
Don't know how it happened but you could check your <prefix>_search_index.MYI for errors. Cf. http://dev.mysql.com/doc/refman/5.0/en/check.html for syntax. If a corruption is found, you can then try to repair it. Cf. http://dev.mysql.com/doc/refman/5.0/en/repair.html.
Kind regards,
Herta