Error: DBD::mysql::db failed: Table ‘./eximstats/failures’ (How to Fix)

If you get this error in WHM > View Sent Summary

Error from delivery reporter: DBD::mysql::db selectall_arrayref failed: Table './eximstats/failures' is marked as crashed and last (automatic?) repair failed

Try running this command

# mysqlcheck --repair eximstats

If you get this error as a result…

eximstats.defers OK
eximstats.failures
error : Can't create new tempfile: './eximstats/failures.TMD'
status : Operation failed

Something has corrupted the ‘failures’ table within eximstats. It’s unable to be repaired. To recreate it, do the following:

Via command line run these:

mysql
use eximstats;
drop table failures;

Then run:

/usr/local/cpanel/bin/updateeximstats

If you wish to ‘clear’ the other databases out, please note this will wipe out existing eximstats if you plan on using it for Mail Reports so keep that in mind. After you perform the above step, simply run

mysql
use eximstats;
TRUNCATE TABLE sends;
TRUNCATE TABLE defers;
TRUNCATE TABLE smtp;

Tags: , ,