I get oodles of this or similar errors in e-mail: Code: 11.03.2015-16:40 - WARNING - DB::query(DELETE FROM monitor_data WHERE type ='sys_log' AND created < UNIX_TIMESTAMP() - 240 AND server_id = 1) -> mysqli_query Table './dbispconfig/monitor_data' is marked as crashed and last (automatic?) repair failed Disk was full, I suppose this made database broken. Is the above condition repairable? I did find advice to run the update db script from ISPConfig installer, would it work in this case?
ISPConfig shows this in top of browser window: Code: 0 db->query(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 2) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:211] #1 db->queryAllRecords(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 2) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:194] #2 _getServerState(2, aweb4.domainname.country, ) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:115] #3 _getSysState() called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:63] #0 db->query(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php:211] #1 db->queryAllRecords(SELECT DISTINCT type, data FROM monitor_data WHERE server_id = 1) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:194] #2 _getServerState(1, ispc3.domainname.country, ) called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:115] #3 _getSysState() called at [/usr/local/ispconfig/interface/web/monitor/show_sys_state.php:63]
I managed to repair database table monitor_data.MYI following this manual: Code: http://dev.mysql.com/doc/refman/5.0/en/myisam-repair.html Now I get oodles of different errors. I'll try to undestand what they are about.
Login to phpmyamin as root user, go to the dbispconfig database, select all tables and choose repair as action.