A few months ago I had an exact same issue but with a different table. This time tiki_sessions table crashed.

I still don’t understand what is causing the crash. Luckily I know how to get rid of this issue quickly once I discover it.

executing the following command fixes the issue:
mysqlcheck –auto-repair -u{username} -p{password} {database_name} {database_table_name}

output:

{database.name}.tiki_sessions
error    : Table ‘./{database.name}/tiki_sessions’ is marked as crashed and should be repaired

Repairing tables
{database.name}.tiki_sessions
warning  : Number of rows changed from 0 to 2
status   : OK

This entry was posted on Wednesday, June 25th, 2008 at 2:35 pm and is filed under Agile. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.