Database Error

[evp]

HI, I was in the middle of sending out a large email campaign, when my server crashed. Now when I go into the campaign stats I receive the following error on the bottom:

Error running count query for Campaign List: Query Failed:SELECT count(*) c FROM emailman LEFT JOIN users ON users.id = emailman.related_id and emailman.related_type ='Users' LEFT JOIN contacts ON contacts.id = emailman.related_id and emailman.related_type ='Contacts' LEFT JOIN leads ON leads.id = emailman.related_id and emailman.related_type ='Leads' LEFT JOIN prospects ON prospects.id = emailman.related_id and emailman.related_type ='Prospects' LEFT JOIN prospect_lists ON prospect_lists.id = emailman.list_id LEFT JOIN email_addr_bean_rel ON email_addr_bean_rel.bean_id = emailman.related_id and emailman.related_type = email_addr_bean_rel.bean_module and email_addr_bean_rel.deleted=0 LEFT JOIN campaigns ON campaigns.id = emailman.campaign_id LEFT JOIN email_marketing ON email_marketing.id = emailman.marketing_id where emailman.campaign_id= '5f115ce4-c699-ff95-cff3-4ac5db6a07e9' AND emailman.deleted=0 AND emailman.deleted=0::MySQL error 145: Table './evp_bd/emailman' is marked as crashed and should be repaired

I have tried to repair the database, but I keep getting these errors.

Any ideas on how to fix this?

[salesagility]

emailman is the table that emails scheduled for sending are stored.

you should run phpmyadmin against this table and "repair" it

failing that ... you can empty the contents of the table ... but you'd lose all the emails still in the queue

[andopes]

You need to repair this table, which is crashed.
Log in into phpMyAdmin and run thes queries:

check <database_name>
repair <database_name>
optimize <database_name>

Cheers

[historicslunk]

Just wanted to say thank you !

we had this issue with our 5.5rc1 db and we were very worried! I know we are not supposed to use it for production but we get ever so excited about new stuff

We used Mysql Admin (third party not web based) tool to run the check and repair and it worked a treat!

So thank you ever so much!!

Sharif