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;
Originally posted on October 16, 2016 @ 8:08 pm
