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

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

Discussion in 'Plesk for Linux - 8.x and Older' started by ponggr, Sep 23, 2007.

  1. ponggr

    ponggr Guest

    0
     
    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.
     
  2. SWsoft support

    SWsoft support New Pleskian

    22
    20%
    Joined:
    Dec 26, 2006
    Messages:
    6
    Likes Received:
    0
    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
     
  3. ponggr

    ponggr Guest

    0
     
    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
     
Loading...