1. Please take a little time for this simple survey! Thank you for participating!
    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/