mysql error 145: Table './webmail/schedulers_time' is marked as crashed...

[kirkdrob]

Email stopped showing up in users Inbox. The mail is verified on the server, email setup test passes, and I get no error when I Check Mail.
Investigation reveals that the 'schedulers_times' table is crashed and needs repaired.
Here is what did NOT work:

1. Quick repair and rebuild: developed a script to execute to re-sync the db w/ vardefs. It produced an error. Executing repair query: Query Failed:ALTER TABLE schedulers_times add column id char(36) NOT NULL , add column deleted bool DEFAULT '0' NOT NULL , add column date_entered datetime NOT NULL , add column date_modified datetime NOT NULL , add column scheduler_id char(36) NOT NULL , add column execute_time datetime NOT NULL , add column status varchar(25) DEFAULT 'ready' NOT NULL , ADD INDEX idx_scheduler_id (scheduler_id, execute_time)::MySQL error 145: Table './webmail/schedulers_times' is marked as crashed and should be repaired
2. Rebuild Shedulers: Said it rebuilt the schedulers but did not fix the 'schedulers_times' table.
3. Looked at the 'schedulers_times' table: It is has no Definitions.
4. Looked at the 'emails_cache' table: It is also has no Definitions

Afraid to try to copy table definitions from another instance?
Not very comfortable going directly to MySQL to make changes.

OS Fedora Core 11
Sugar 5.2.0k Community Edition
Web Apache 2.2.14
PHP 5.2.13
MySQL 5.1.45

This was all working!
Thanks in advance for any advice.

[kirkdrob]

OK, my desperation overruled my fear of messing with the database, like they say "necessity is the mother of all invention..."

Solution: Opened MySQL Administrator v. 1.2.12 then navigated to Catalogs then the appropriate folder. This displayed a list of the tables and the 2 that were corrupt. In this case the 'email_cache' and 'schedulers_time' tables. Right click the table and click on 'Repair' I performed an Extended repair on both tables and poof, problem solved.

Went into sugar and did a Quick Repair and Rebuild, double checked the Schedulers (which were already running) went to my email and all was well.

Hope this helps anyone in the future

[mickjsn]

I was also having the same problem, to resolve the problem i used a third party tool for MySQL repair, and i think i must share the link with you all guys from where i downloaded it. http://www.mysqlrepair.net.;)