Error in main screen

Support and queries relating to all previous versions of ZoneMinder
Post Reply
calixto
Posts: 27
Joined: Tue Feb 07, 2006 9:25 pm
Location: Weston, FL
Contact:

Error in main screen

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
Posts: 27
Joined: Tue Feb 07, 2006 9:25 pm
Location: Weston, FL
Contact:

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

User avatar
acrid
Posts: 68
Joined: Sun Aug 24, 2003 10:26 pm
Location: Germany

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

try to repair the databases with:
mysqlcheck -u root -p -r --all-databases

Code: Select all

$> man woman
$> Segmentation fault (core dumped)

calixto
Posts: 27
Joined: Tue Feb 07, 2006 9:25 pm
Location: Weston, FL
Contact:

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 :-(

Post Reply

Who is online

Users browsing this forum: No registered users and 31 guests