On 10/01/2008, Craig White <craig(a)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