Database crashed and needs to be repaired (SOLVED)

One one of my 1.04 Evo sites I get this:

« MODx Parse Error »

MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table ’./databasename/modx_site_content’ is marked as crashed and should be repaired »

What are the steps here?

Thanks!

Logging into the manager gives me this:

Warning: Cannot modify header information - headers already sent by (output started at /home/site/public_html/basenji-shaun.com/manager/includes/header.inc.php:7) in /home/site/public_html/basenji-shaun.com/manager/includes/document.parser.class.inc.php on line 2732
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table ’./sitedatabase/modx_site_content’ is marked as crashed and should be repaired »
SQL: SELECT published FROM `sitedatabase`.`modx_site_content` WHERE id=1

Use your domain’s control panel mysql client (usually phpMyAdmin) to attempt a repair of the table. It’s in the Operations tab.

I find it rather alarming that there are suddenly so many of these turning up in the forums.

Please, people, backup your sites!

OK, I am in. I clicked on the table that gets mentioned in the front end MODx error and then clicked on the Operations tab.

I see several options like Alter table order, Table options, Table maintenance, Move table, and Copy table...

Inside the Table maintenance is a blue "Flush" link.

How do I repair the table specifically?

Thanks!

OK< I found the repair option from the Structure tab. The repair option is a small pull down selector at the bottom. Seems to have done the trick...

Interested in Susans comment about this happening more and more

We have a number of sites and over the last 3 weeks have had this happen 5 times so far to different sites at different times. They are on different shared servers although same host. Does anyone have any thoughts on what might be happening here, as whatever it is - it is becoming a big problem as we can’t see how to predict this.

Incidentally they are not all 1.0.4, but all different EVO versions.

Mark

Is it always the same table in these different sites?

Yes, always site_content

Hmm, it may be indicative of paricular update/replace/insert/delete operations your sites happen to be doing to the site content table combined with many other variables such as your MYSQL version etc. This is difficult to pin down, one thing you could do is move one of the sites to a different hosting provider with maybe a different MYSQL version(easier said than done I know), usage of you site won’t vary, your users should carry on doing what they do regardless of where your site is, so if the prob goes away it would seem to point back to your current hosts environment, if not its something to do with your site environment/usage.

You could also canvass other users on the same host to see if they have any probs like this.

I was thinking it must be the host, but seeing more here is making me think.
Will be looking more closely when it happens again.
Have just been looking at the MySQL version, which is 5.1.48, maybe others with the issue could check to see if the MySQL version is always the same