Sugar is Down PLEASE HELP

[cburn]

I am receiving this error in reference to the emails table:

061120 16:10:10 [ERROR] /usr/libexec/mysqld: Can't open file: 'emails.MYI' (errno: 144)


From the sugar log
Error running count query for Email List: Query Failed:SELECT count(*) c FROM emails LEFT JOIN emails_contacts ec ON emails.id = ec.email_id LEFT JOIN contacts ON ec.contact_id = contacts.id LEFT JOIN users ON emails.assigned_user_id=users.id WHERE emails.assigned_user_id = '7d23080a-7365-3fa5-dbb5-451e7e69c82d' AND emails.type = 'inbound' AND emails.status != 'archived' AND emails.deleted=0 ::MySQL error 1016: Can't open file: 'emails.MYI' (errno: 144)



Has anyone seen this before?

Chad

[mch423]

I'm no DB expert but did a quick search on Google for that error and you should verify that you have enough disk space left. Here's a thread that you can follow up on how to resolve the corrupted DB.

http://forums.mysql.com/read.php?35,4876,4894#msg-4894

- Max