Database crashed and needs to be repaired (SOLVED)

just chiming in, i’ve had it happen twice in the past... probably 2 months. hasn’t happened for like 3 weeks now. database version 5.1.48 as well. both times was the `site_content` table, both times it was a simple REPAIR TABLE statement to fix it. someone was supposed to check for any error logs on the server (don’t have access to them), but never got back to me.

both times it happened were on different domains (so different modx installations, with different databases), but on the same server.

Quote from: slush at Sep 10, 2010, 11:36 AM

just chiming in, i’ve had it happen twice in the past... probably 2 months. hasn’t happened for like 3 weeks now. database version 5.1.48 as well. both times was the `site_content` table, both times it was a simple REPAIR TABLE statement to fix it. someone was supposed to check for any error logs on the server (don’t have access to them), but never got back to me.

both times it happened were on different domains (so different modx installations, with different databases), but on the same server.

Just had this happen to me the other day, also the same table. First and only time it’s ever happened. It is with a different host than I usually use. I’ll have to look into the differences between my preferred host and the host of this particular client.

Really interested to hear that others might be having the same issue.

Have been working on this today, and this thread is as far as I have got so far
http://modxcms.com/forums/index.php/topic,54174.0.html

Maybe some issue with 5.1.48 is starting to sound more likely

Interesting...

I am the OP, but so far this has only happened once to just one of my sites...

Hi guys,

I am having the same problem with the Site_Content table on my db. My hosting media temple has a way to repair broken db’s from the admin panel, but so far we have not been successful. PLEASE HELP!!!!

ponscreative - access your database through phpmyadmin and try running this sql query:

where `theTableName` will probably be `modx_site_content`

i use mediatemple, but have not seen this happen on my web server, it’s always been on my employer’s web server. are you using (gs) or (dv)?

Hello.
I has the same issues on one of my sites. It is repeating then manager doing some 'save' operations.
MODX 1.0.5
mysql serv & client 5.1.56
php 5.2.17
apache 2.2.22