1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Controlpanel issue

Discussion in 'Plesk for Linux - 8.x and Older' started by |kent|, Aug 12, 2005.

  1. |kent|

    |kent| Guest


    I get this error after i have logged into the controllpanel and want to view the client lists:


    Unable to query: Can't find file: './psa/ClientsTraffic.frm' (errno: 5)


    0: /usr/local/psa/admin/plib/common_func.php3:177 psaerror(string "Unable to query: Can't find file: './psa/ClientsTraffic.frm' (errno: 5)")
    1: /usr/local/psa/admin/plib/class.TrafficData.php:87 db_query(string "SELECT c.id, l.value FROM clients c LEFT JOIN ClientsTraffic ct ON ct.cl_id=c.id LEFT JOIN Limits l ON l.id=c.limits_id AND l.limit_name='max_traffic' AND l.value>-1 WHERE (ct.date between '2005-08-01' and '2005-08-12') GROUP BY c.id HAVING sum(ct.http_in) + sum(ct.ftp_in) + sum(ct.smtp_in) + sum(ct.pop3_imap_in) + sum(ct.http_out) + sum(ct.ftp_out) + sum(ct.smtp_out) + sum(ct.pop3_imap_out) > l.value")
    2: /usr/local/psa/admin/plib/class.ClientsList.php3:218 trafficdata::getclientsexctraffic()
    3: /usr/local/psa/admin/plib/class.cList.php3:78 clientslist->fetchclientslist()
    4: /usr/local/psa/admin/plib/class.cList.php3:97 clientslist->fetchlist()
    5: /usr/local/psa/admin/htdocs/clients/clients.php3:73 clientslist->init()

    Why this?
  2. hardweb

    hardweb Guest

    The ClientsTraffic table in psa database is corrupted, you have to try to repair it and if it's not possible, restore it from a dump located in /var/lib/psa/dumps/