I notice that the group mail account is not able to import email anymore. The message from the log is
AND jt1.deleted=0 where (schedulers.status=‘Active’ AND NOT EXISTS(SELECT id FROM job_queue WHERE scheduler_id=schedulers.id AND status!=‘done’)) AND schedulers.deleted=0: MySQL error 145: Table ‘./diw_suitecrm/job_queue’ is marked as crashed and should be repaired
Thu Sep 4 12:38:01 2014 [3][1][FATAL] Query Failed: SELECT id FROM job_queue WHERE execute_time <= ‘2014-09-04 04:38:01’ AND status = ‘queued’ ORDER BY date_entered ASC LIMIT 0,1: MySQL error 145: Table ‘./diw_suitecrm/job_queue’ is marked as crashed and should be repaired
Thu Sep 4 12:38:01 2014 [3][1][FATAL] Get One Failed:SELECT id FROM job_queue WHERE execute_time <= ‘2014-09-04 04:38:01’ AND status = ‘queued’ ORDER BY date_entered ASC: MySQL error 145: Table ‘./diw_suitecrm/job_queue’ is marked as crashed and should be repaired
Thu Sep 4 12:39:02 2014 [3][1][FATAL] Query Failed: SELECT id FROM job_queue WHERE status=‘running’ AND date_modified <= ‘2014-09-03 04:39:02’: MySQL error 145: Table ‘./diw_suitecrm/job_queue’ is marked as crashed and should be repaired
Thu Sep 4 12:39:02 2014 [3][1][FATAL] Query Failed: SELECT schedulers.* , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , ‘Users’ created_by_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod FROM schedulers LEFT JOIN users jt0 ON jt0.id=schedulers.created_by AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON schedulers.modified_user_id=jt1.id AND jt1.deleted=0
I did a repair and rebuild, and execute the script under the heading Differences found between database and vardefs. I got an error message
Database failure. Please refer to sugarcrm.log for details.
These are the message from the log
AND jt1.deleted=0 where (schedulers.status=‘Active’ AND NOT EXISTS(SELECT id FROM job_queue WHERE scheduler_id=schedulers.id AND status!=‘done’)) AND schedulers.deleted=0: MySQL error 145: Table ‘./diw_suitecrm/job_queue’ is marked as crashed and should be repaired
Thu Sep 4 12:47:02 2014 [3][1][FATAL] Query Failed: SELECT id FROM job_queue WHERE execute_time <= ‘2014-09-04 04:47:02’ AND status = ‘queued’ ORDER BY date_entered ASC LIMIT 0,1: MySQL error 145: Table ‘./diw_suitecrm/job_queue’ is marked as crashed and should be repaired
Thu Sep 4 12:47:02 2014 [3][1][FATAL] Get One Failed:SELECT id FROM job_queue WHERE execute_time <= ‘2014-09-04 04:47:02’ AND status = ‘queued’ ORDER BY date_entered ASC: MySQL error 145: Table ‘./diw_suitecrm/job_queue’ is marked as crashed and should be repaired
Any help?