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