Hi!

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

ERROR

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?

 

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/