Email Sent Summary Problem

proogammer

Member
Dec 19, 2011
23
0
51
cPanel Access Level
Root Administrator
Even though there has been lots of email sent from my server but in WHM under Email the "view email sent summary" shows nothing no matter which date range I select. The result is "No Records Found".

I noticed this after installing afterlogic lite for cpanel. I used it in past and it was working but I am not sure what has caused this problem.

Can anyone help me to fix it?
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,884
2,254
463
Hello :)

Please verify that your "eximstats" database is not corrupted by using a command such as:

Code:
# mysqlcheck eximstats
Also, check for any specific errors in the cPanel error log when accessing this option:

Code:
# tail -f /usr/local/cpanel/logs/error_log
Thank you.
 

proogammer

Member
Dec 19, 2011
23
0
51
cPanel Access Level
Root Administrator
Here is output for:
Code:
# mysqlcheck eximstats
Output:
Code:
[email protected] [~]# mysqlcheck eximstats
eximstats.defers
warning  : 25 clients are using or haven't closed the table properly
status   : OK
eximstats.failures
warning  : Table is marked as crashed
warning  : 25 clients are using or haven't closed the table properly
warning  : Size of datafile is: 337531860       Should be: 337361760
error    : Found 279877 keys of 277664
error    : Corrupt
eximstats.sends
warning  : 30 clients are using or haven't closed the table properly
status   : OK
eximstats.smtp
warning  : Table is marked as crashed
warning  : 23 clients are using or haven't closed the table properly
warning  : Size of datafile is: 398674730       Should be: 398671710
error    : Found duplicated key at page 58613760
error    : Corrupt
 

ruzbehraja

Well-Known Member
May 19, 2011
392
11
68
cPanel Access Level
Root Administrator
Repairing the database or Truncating the database completely from PHPMyAdmin should help.

Once the database is repaired it should work as normal.