Trouble editing WIKI

[SteveC]

I'm trying to add a page to the WIKI, and am getting the following error:

Database error
From PhatHack Wiki
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 "SearchUpdate::doUpdate". MySQL returned error "145: Table './phathackwikidb/phw_searchindex' is marked as crashed and should be repaired (localhost)".


Any ideas?

Edit: This appears to be a non-critical error. The new WIKI page (http://wiki.phathack.com/Windows_Hack_Procedure) is working just fine.

[sbingner]

I've had that happen a few times... but I can't track down what causes it...

[SteveC]

I'm sure you've seen this already, but it sounds like you need to run the CHECK TABLE procedure against the database (or at least the tables referenced in that script). Also, you may want to update your MySQL install if it is an older version - there appear to have been several bugs related to this message.

http://mail.directfb.org/pipermail/directfb-dev/2006-March/001564.html
http://www.databasejournal.com/features/mysql/article.php/3300511
http://mysqld.active-venture.com/Repair.html

Sorry if this is all stuff you've seen before.

[sbingner]

Yea, I run check table on it... and sometimes it makes a difference, but it often just still has the error... very strange... what I don't understand is what's making it get marked as crashed

[sbingner]

I Updated MediaWiki to the newest version and moved it to the faster/newer box that's running the forums -- hopefully that'll more permanently fix it