The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Email Sent Summary Problem

Discussion in 'E-mail Discussions' started by proogammer, May 15, 2012.

  1. proogammer

    proogammer Member

    Joined:
    Dec 19, 2011
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    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?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    652
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    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.
     
  3. proogammer

    proogammer Member

    Joined:
    Dec 19, 2011
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Here is output for:
    Code:
    # mysqlcheck eximstats
    Output:
    Code:
    root@server [~]# 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
     
  4. ruzbehraja

    ruzbehraja Well-Known Member

    Joined:
    May 19, 2011
    Messages:
    383
    Likes Received:
    7
    Trophy Points:
    18
    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.
     
  5. Reinaldo Juárez

    Reinaldo Juárez Registered

    Joined:
    Oct 22, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Any idea for fix it, I have the same issue.

    Could you give me any document or reference for repair this.
     
Loading...

Share This Page