Error while run report for Mail Delivery Reports in whm

irTech

• October 19, 2014 05:38

Hello When i wanted to run report for Mail Delivery Reports in whm, i have faced with this error
DeliveryReporter API internal failure: DBD::mysql::db selectall_arrayref failed: Table './eximstats/sends' is marked as crashed and should be repaired at /usr/local/cpanel/Cpanel/Exception.pm line 96 Cpanel::Exception::new('Cpanel::Exception::Database::Error', 'Cpanel::ExceptionMessage::Raw=SCALAR(0x224e248)', 'HASH(0x2725338)') called at /usr/local/cpanel/Cpanel/Exception.pm line 47 Cpanel::Exception::create('Database::Error', 'Cpanel::ExceptionMessage::Raw=SCALAR(0x224e248)', 'HASH(0x2725338)') called at /usr/local/cpanel/Cpanel/Exception.pm line 55 Cpanel::Exception::create_raw('Database::Error', 'DBD::mysql::db selectall_arrayref failed: Table \'./eximstats...', 'HASH(0x2725338)') called at /usr/local/cpanel/Cpanel/DBI.pm line 79 Cpanel::DBI::_create_exception('Cpanel::DBI::Mysql::db=HASH(0x2796ff8)', 'DBD::mysql::db selectall_arrayref failed: Table \'./eximstats...', undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 70 Cpanel::DBI::_error_handler('DBD::mysql::db selectall_arrayref failed: Table \'./eximstats...', 'Cpanel::DBI::Mysql::db=HASH(0x2796ff8)', undef) called at /usr/local/cpanel/Cpanel/DeliveryReporter.pm line 477 Cpanel::DeliveryReporter::query('Cpanel::DeliveryReporter=HASH(0x1ed9d08)', 'success', 1, 'maxsendunixtime', 1413801180, 'inprogress', 1, 'deliverytype', 'all', ...) called at /usr/local/cpanel/bin/emailtrack line 53 eval {...} called at /usr/local/cpanel/bin/emailtrack line 53
please tell me how can i fix this error.... thanks a lot

• 

  24x7server

  • October 19, 2014 12:52

  Hello, I can see there is an issues with the eximstats databases. I will suggest please take a backup of eximstats database and then try to flush it.

  0
• 

  cPanelMichael

  • October 20, 2014 16:30

  Hello :) Please try repairing the eximstats database with a command such as:
  mysqlcheck --repair eximstats
  Thank you.

  0

Please sign in to leave a comment.