• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Controlpanel issue

K

|kent|

Guest
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/
 
Back
Top