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