SOLVED Database Error: Table './eximstats/sends

If you login to WHM and go to check your email sent summary, or any other function like looking at your email queue, you may have run across the following error:

Error from delivery reporter: DBD::mysql::db selectall_arrayref failed: Table ‘./eximstats/sends’ is marked as crashed and should be repaired

This is an easy fix. If you are unfamiliar with root, please do not try the following tutorial. First, you will need to login to shell as the root user. Run the following command

mysqlcheck —repair eximstats

When running that command, you will receive something along the lines of:

status : Operation failed

If that happens, then it means it cannot be repaired and will need to be recreated. Run:

mysql
use eximstats;
drop table failures;

Then (important) run:

/usr/local/cpanel/bin/updateeximstats

That should do it. What that last line of code will do is fix the database scheme since you just dropped the failures table. You can also ‘clear’ the other databases to get a clean start. Just know that this will clear all of your current eximstats so if you have important stats you don’t want deleted, don’t clear the rest.

To clear the other stats, run:

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

That’s it! Now run your WHM reports and you shouldn’t receive any other errors.

MinhAngela