Error in main screen

calixto · Post by **calixto** » Fri Apr 14, 2006 7:35 pm

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

calixto · Post by **calixto** » Fri Apr 14, 2006 7:36 pm

another error while trying to delete events

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

acrid · Post by **acrid** » Sat Apr 15, 2006 10:12 pm

try to repair the databases with:

mysqlcheck -u root -p -r --all-databases

calixto · Post by **calixto** » Sun Apr 16, 2006 4:52 am

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