Page 1 of 1

Error in main screen

Posted: Fri Apr 14, 2006 7:35 pm
by calixto
It was working fine, after few days I got back to zm and find following errors in .../zm/zm.php screen

Warning: mysql_query() [function.mysql-query]: Unable to save result set in /usr/local/apache2/htdocs/zm/zm_html_view_console.php on line 82
Table 'E' is marked as crashed and should be repaired
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/zm/zm_html_view_console.php on line 85

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /usr/local/apache2/htdocs/zm/zm_html_view_console.php on line 86

Warning: array_merge() [function.array-merge]: Argument #3 is not an array in /usr/local/apache2/htdocs/zm/zm_html_view_console.php on line 95

thanks

Calixto

Posted: Fri Apr 14, 2006 7:36 pm
by calixto
another error while trying to delete events

Incorrect key file for table './zm/Events.MYI'; try to repair it

Posted: Sat Apr 15, 2006 10:12 pm
by acrid
try to repair the databases with:
mysqlcheck -u root -p -r --all-databases

Posted: Sun Apr 16, 2006 4:52 am
by calixto
I deleted most events in one of the cameras and got rid of the messages

But there was one single event entry that had kind of overflown number of frames.

Hours later errors were back again and the mysqlcheck worked. Thanks!!

The cause is still unknown for me :-(