/zm/Logs is marked as crashed and last repair failed
Posted: Sun Jan 26, 2014 9:34 am
Can anyone provide any pointers on how I could fix this error.
Web interface now shows this error and nothing else:-
V1.25.0
Options / Can't write log entry 'insert into Logs ( TimeKey, Component, Pid, Level, Code, Message, File, Line ) values ( 1390727348.044826, 'web_php', 2256, -3, 'FAT', 'SQL-ERR \'Table \'./zm/Logs\' is marked as crashed and last (automatic?) repair failed\',
statement was \'select Level, count(Level) as LevelCount from Logs where Level < 0 and from_unixtime(TimeKey) + interval 900 second > now() group by Level order by Level asc\'', '/usr/share/zoneminder/includes/database.php', 78 )': Table './zm/Logs' is marked as crashed and last (automatic?) repair failed
A google search suggested I type into mysql " USE zm; REPAIR TABLE Events; card=23 for bt787" but this did not work.
Web interface now shows this error and nothing else:-
V1.25.0
Options / Can't write log entry 'insert into Logs ( TimeKey, Component, Pid, Level, Code, Message, File, Line ) values ( 1390727348.044826, 'web_php', 2256, -3, 'FAT', 'SQL-ERR \'Table \'./zm/Logs\' is marked as crashed and last (automatic?) repair failed\',
statement was \'select Level, count(Level) as LevelCount from Logs where Level < 0 and from_unixtime(TimeKey) + interval 900 second > now() group by Level order by Level asc\'', '/usr/share/zoneminder/includes/database.php', 78 )': Table './zm/Logs' is marked as crashed and last (automatic?) repair failed
A google search suggested I type into mysql " USE zm; REPAIR TABLE Events; card=23 for bt787" but this did not work.