We've been running mediawiki 1.5.5 for a significant period of time
(more than a year), on a RHEL 3 box with Mysql 4 on it.
Recently we upgraded the box (well, really rebuilt the box) to RHEL5,
which has mysql5 on it.
Now we're seeing a sporadic error when editing entries in mediawiki:
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
'./wikidb/searchindex' is marked as crashed and should be repaired
(localhost)".
The entry updates, and I can go in and run a table repair in mysql, that
works just fine, however, it's a bit annoying.
I assume (maybe incorrectly) that the media wiki we are running is
expecting mysql4, and we're now running mysql 5 and this is the problem.
Would upgrading to 1.11.0 resolve the issue? Or perhaps there's
something else going on.
Thanks for your time,
Scott