Help! Major problem! Cannot see clients due to MySQL problem

[ponggr]

Hi

When I click on clients I get the following:

ERROR: PleskMainDBException
MySQL query failed: Got error 134 from storage engine

0: /usr/local/psa/admin/plib/common_func.php3:216
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 '2007-09-01' and '2007-09-24') 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')
1: /usr/local/psa/admin/plib/class.TrafficData.php:133
TrafficData->getClientsExcTraffic()
2: /usr/local/psa/admin/plib/class.ClientsList.php3:246
ClientsList->fetchClientsList()
3: /usr/local/psa/admin/plib/class.cList.php3:103
cList->fetchList()
4: /usr/local/psa/admin/plib/class.cList.php3:123
cList->init()
5: /usr/local/psa/admin/htdocs/clients/clients.php3:89


When I click on domains it works fine and websites that use MySQL seem to work fine. I dont know if related but I cant also change the password for the admin panel. I click change but it doesnt change the passoword nor it returns an error.

 

[SWsoft support]

This might seem as a corrupt table record.

Try to execute following command in the root shell:

# mysqlcheck -r -uadmin -p`cat /etc/psa/.psa.shadow` psa

 

[ponggr]

Thanks. Seems to have worked.

psa.BackupsObjects OK
psa.BackupsRunning OK
psa.BackupsScheduled OK
psa.BackupsSettings OK
psa.Cards OK
psa.ClientsTraffic
warning : Number of rows changed from 959 to 950
status : OK
psa.Components OK
psa.DashboardPreset OK
psa.DashboardPresetConfig OK
psa.DatabaseServers OK
psa.DomainServices OK
psa.DomainsTraffic OK
psa.IP_Addresses OK
psa.Limits OK
psa.ListsParams OK
psa.Logos OK
psa.MailLists OK
psa.Modules OK
psa.NewsArticles OK
psa.Notes OK
psa.Notifications OK
psa.PMM OK
psa.PMMDefault OK
psa.Parameters OK
psa.Permissions OK
psa.Repository OK
psa.SiteAppFiles OK
psa.SiteAppPackages OK
psa.SiteAppResources OK
psa.SiteApps OK
psa.Skins OK
psa.Templates OK
psa.TmplData OK
psa.WebApps OK
psa.accounts OK
psa.actions OK
psa.ai_vendor_sources OK
psa.anon_ftp OK
psa.badmailfrom OK
psa.certificates OK
psa.cl_param OK
psa.clients OK
psa.cp_access OK
psa.custom_buttons OK
psa.data_bases OK
psa.db_users OK
psa.disk_usage OK
psa.dns_recs OK
psa.dns_recs_t OK
psa.dns_zone OK
psa.dom_level_usrs OK
psa.dom_param OK
psa.domainaliases OK
psa.domains OK
psa.event_handlers OK
psa.exp_event OK
psa.forwarding OK
psa.hosting OK
psa.itmpl OK
psa.itmpl_data OK
psa.key_history OK
psa.key_history_params OK
psa.locales OK
psa.lockout OK
psa.log_actions OK
psa.log_components OK
psa.log_rotation OK
psa.mail OK
psa.mail_aliases OK
psa.mail_redir OK
psa.mail_resp OK
psa.mass_mail OK
psa.mass_mail_clients OK
psa.mass_mail_domains OK
psa.misc OK
psa.mn_param OK
psa.module_atis_mod_backup_schedule OK
psa.module_cs_gs_configs OK
psa.module_cs_gs_parameters OK
psa.module_cs_gs_servers OK
psa.module_fileserver_hosts OK
psa.module_fileserver_params OK
psa.module_fileserver_shares OK
psa.module_fileserver_users OK
psa.module_fileserver_valid_users OK
psa.module_firewall_objects OK
psa.module_firewall_rules OK
psa.module_kav_groups
note : The storage engine for the table doesn't support repair
psa.module_kav_mailnames
note : The storage engine for the table doesn't support repair
psa.module_kav_parameters
note : The storage engine for the table doesn't support repair
psa.module_vpn_objects
note : The storage engine for the table doesn't support repair
psa.module_watchdog_disk
note : The storage engine for the table doesn't support repair
psa.module_watchdog_disk_event
note : The storage engine for the table doesn't support repair
psa.module_watchdog_param
note : The storage engine for the table doesn't support repair
psa.module_watchdog_report
note : The storage engine for the table doesn't support repair
psa.module_watchdog_service
note : The storage engine for the table doesn't support repair
psa.module_watchdog_service_event
note : The storage engine for the table doesn't support repair
psa.module_watchdog_sys_stat
note : The storage engine for the table doesn't support repair
psa.password_secrets OK
psa.pd_users OK
psa.protected_dirs OK
psa.report OK
psa.report_auto OK
psa.report_section OK
psa.resp_attach OK
psa.resp_forward OK
psa.resp_freq OK
psa.secret_keys OK
psa.sessions OK
psa.slave_params OK
psa.slaves OK
psa.smtp_poplocks OK
psa.spamfilter OK
psa.spamfilter_preferences OK
psa.subdomains OK
psa.sys_users OK
psa.tts_cats OK
psa.tts_conf OK
psa.tts_priorities OK
psa.tts_queues OK
psa.tts_reporters OK
psa.tts_slave_info OK
psa.tts_ticket_events OK
psa.tts_tickets OK
psa.upgrade_history OK
psa.web_users OK
psa.webalizer_group_referrer OK
psa.webalizer_hidden_referrer OK