InMotion Hosting Support Center

Error in WHM Mail Reports

Category: Whm

2014-09-25 10:16 am EST

Hits: 1,864

WHM throw an error when I ask for a mail delivery report or any kind of summary. The error i:

DeliveryReporter API internal failure: DBD::mysql::db selectall_arrayref failed: File './eximstats/smtp.MYD' not found (Errcode: 2) at /usr/local/cpanel/Cpanel/ line 96 Cpanel::Exception::new('Cpanel::Exception::Database::Error', 'Cpanel::ExceptionMessage::Raw=SCALAR(0x2444950)', 'HASH(0x29abdb8)') called at /usr/local/cpanel/Cpanel/ line 47 Cpanel::Exception::create('Database::Error', 'Cpanel::ExceptionMessage::Raw=SCALAR(0x2444950)', 'HASH(0x29abdb8)') called at /usr/local/cpanel/Cpanel/ line 55 Cpanel::Exception::create_raw('Database::Error', 'DBD::mysql::db selectall_arrayref failed: File \'./eximstats/...', 'HASH(0x29abdb8)') called at /usr/local/cpanel/Cpanel/ line 79 Cpanel::DBI::_create_exception('Cpanel::DBI::Mysql::db=HASH(0x2a1ada8)', 'DBD::mysql::db selectall_arrayref failed: File \'./eximstats/...', undef) called at /usr/local/cpanel/Cpanel/ line 70 Cpanel::DBI::_error_handler('DBD::mysql::db selectall_arrayref failed: File \'./eximstats/...', 'Cpanel::DBI::Mysql::db=HASH(0x2a1ada8)', undef) called at /usr/local/cpanel/Cpanel/ line 477 Cpanel::DeliveryReporter::query('Cpanel::DeliveryReporter=HASH(0x2a15810)', 'success', 1, 'maxsendunixtime', 1411654260, 'deliverytype', 'remote', 'dir', 'desc', ...) called at /usr/local/cpanel/bin/emailtrack line 53 eval {...} called at /usr/local/cpanel/bin/emailtrack line 53

Tks in advance

Andre Sa

You must login before you can ask a follow up question.

You must login before you can submit an answer.



31,633 Points
2014-09-25 10:50 am EST
Hello Andre,

Thank you for your question. This problem is typically caused by a database issue.

You can repair databases via command line:
  1. Login to your server via SSH.
  2. Run this command:

    mysqlcheck --all-databases --auto-repair

After the databases are repaired,you should be able to access reports.

If you have any further questions, feel free to post them below.

Thank you,

You must login before you can post a comment about this answer.

Like this Question?

Forum Login

You are NOT logged in. You can still browse our Support Center.

To participate within our Community Support Forum:

Need more Help?

Ask the Community!

Get help with your questions from our community of like-minded hosting users and InMotion Hosting Staff.

Current Customers

Chat: Click to Chat Now E-mail:
Call: 888-321-HOST (4678) Ticket: Submit a Support Ticket

Not a Customer?

Get web hosting from a company that is here to help. Sign up today!