My host upgraded to php5 and mysql5.1 and now im having problems with the modx_site_content table. The table seems to go corrupt randomly.
The table modx_site_content gives a small notice about the table: Key in wrong position at page 5120
This is the error i get:
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Table './10992canva/modx_site_content' is marked as crashed and should be repaired »
SQL: SELECT sc.* FROM 10992canva.modx_site_content sc LEFT JOIN 10992canva.modx_document_groups dg ON dg.document = sc.id WHERE sc.id = '3' AND (sc.privateweb=0) LIMIT 1;
[Copy SQL to ClipBoard]
Parser timing
MySQL: 0.0014 s s (0 Requests)
PHP: 0.0519 s s
Total: 0.0533 s s
There seemed to be a same kind of problem with the ipb boards, which was fixed there:
http://www.internetvibes.net/forum/index.php?showtopic=3238
Im really clueless here and im not a mysql guru, so i have no idea how to fix this.
/edit
It seems that all joins have to be rewritten when using mysql 5.0.12 or later:
Bug:
http://bugs.mysql.com/bug.php?id=2098
Docs:
http://dev.mysql.com/doc/refman/5.0/en/join.html
☆ A M B ☆