Weird MODx Parse Error stopping me from saving any documents, it seems.

« MODx 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 ’./wynen_cms/modx_site_content.MYI’; try to repair it »
      SQL: UPDATE `wynen_cms`.`modx_site_content` SET introtext=’’, content=’
Leon Magnus
\r\n
\"Leon\r\n\r\nHe is a member of Doplund\’s chapter of Ad Libitum.

\r\n\r\nHe is a loner who doesn\’t like to converse with others. Some of his friends jokingly tease him because of that fact.
\r\n\r\n[[charinfo? &age=`16` &height=`159` &weight=`48` &seiyuu=`Hikaru Midorikawa`]]’, pagetitle=’Leon Magnus’, longtitle=’Leon Magnus - Characters - Tales of the World: Radiant Mythology’, type=’document’, description=’Leon Magnus first appeared in Tales of Destiny. View his full bio at Tales Union.’, alias=’leon’, link_attributes=’’, isfolder=1, richtext=1, published=1, pub_date=0, unpub_date=0, parent=642, template=10, menuindex=’5’, searchable=1, cacheable=1, editedby=1, editedon=1240176927, publishedon=publishedon, publishedby=publishedby, contentType=’text/html’, content_dispo=’0’, donthit=’0’, menutitle=’’, hidemenu=’0’ WHERE id=653;
      [Copy SQL to ClipBoard]

Parser timing
  MySQL: 0.0007 s (6 Requests)
  PHP: 1240176927.0987 s
  Total: 1240176927.0994 s

Any idea what the heck this is being caused by? It only happens when the data is changed from what was already there (i.e., if I just resaved the same document, it works fine.)

EDIT: It seems it’s only on pages that had a TV that I manually deleted. But I’ve never had that issue before...

Sounds like a corrupted database table.

See this for more details (from a Google search for mysql incorrect key file for table try to repair it) http://www.karakas-online.de/forum/viewtopic.php?t=5173

I ran the Optimize command in SQL Buddy and that seemed to have fixed it.

I wonder what caused it, though...

I have just had this error on my site.
I could update the TVs OK but not the document content window
I have to my knowledge not been updated to higher php or MySQL versions.
I have been running 1.0.2 since 26/12/09 with no issues although I did manually copy my old database from 0.9.6.3 as the installer would not permit an upgrade.

## message for admin ##

Would I need to log this error issue in any other debug forum post or error log to assist the future debug or updates of MODx ??

If you are still using 0.9.6.3 and wonder about upgrading I think 1.0.2 is vgood in spite of this little error, which I seem to have fixed by going to phpMyAdmin and optimising my modx_site_content table.

Thanks

Steve