InMotion Hosting Support Center

Error in WHM Mail Reports

Category: Whm

Andre_
Asked:
2014-09-25 10:16 am EST

Hits: 1,864
Hi,

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/Exception.pm line 96 Cpanel::Exception::new('Cpanel::Exception::Database::Error', 'Cpanel::ExceptionMessage::Raw=SCALAR(0x2444950)', 'HASH(0x29abdb8)') called at /usr/local/cpanel/Cpanel/Exception.pm line 47 Cpanel::Exception::create('Database::Error', 'Cpanel::ExceptionMessage::Raw=SCALAR(0x2444950)', 'HASH(0x29abdb8)') called at /usr/local/cpanel/Cpanel/Exception.pm line 55 Cpanel::Exception::create_raw('Database::Error', 'DBD::mysql::db selectall_arrayref failed: File \'./eximstats/...', 'HASH(0x29abdb8)') called at /usr/local/cpanel/Cpanel/DBI.pm 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/DBI.pm 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/DeliveryReporter.pm 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.

OTHER ANSWERS

0

John-Paul
Staff
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,
John-Paul

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: support@InMotionHosting.com
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!