MySQL upgrade causes parse error and corrupted content

I upgraded my server yesterday from mysql 4.1.2 to 5.1.4.

After the db upgrade, all of my modx installations appeared to load OK. But when attempting to edit/save a page, I received this parse error:

MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - Incorrect key file for table ’./xxxx_modx/modx_site_content.MYI’; try to repair it »

When I investigated my db, phpmyadmin reported that it couldn’t open the modx_content table because it was corrupted. Repair failed to correct the problem. Finally, I dropped the table, reinstalled my backup table content and all appears to work OK now.

This has now happened to two more of my modx sites.

Does anyone have a fix without having to drop/recreate each site’s content table?

(evolution 1.0.2 on apache 2.2.14, mysql 5.1.4, php 5.2.1)

It simply sounds like you did not properly upgrade the MySQL table data when upgrading the server.

Thanks for responding and yes, it does appear that way. Still, the upgrade was completed correctly as best I can ascertain.

Nonetheless, a search for "incorrect key file for table" over at mysql turns up a long history of this problem when upgrading mysql.

This doesn’t appear to me to be a modx problem, but worth a heads up for anyone contemplating upgrading mysql.