[Mediawiki-l] Strange DB error

Herta Van den Eynde herta.vandeneynde at gmail.com
Thu Jan 10 07:59:08 UTC 2008


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



More information about the MediaWiki-l mailing list