Page 1 of 1

All recorded events have no duration

Posted: Wed Jul 21, 2010 5:33 pm
by kongobongo
Hi all,

My zoneminder install was working great up until a few weeks ago, i've just noticed that all recorded events have a duration of 0.0

It triggers fine but doesn't seem to actually record anything, anyone any ideas why this is happening?

fixed problem

Posted: Thu Aug 26, 2010 11:46 am
by toranga
I ran into the same problem, here is how i fixed it i opened a log that said a table in the database was crashed so i ran these commands on the computer thats hosting the zomeminder and the mysql database

mysqlcheck --all-databases --auto-repair -ppassword -u user

and that fixed my problem

just remember that mysqlcheck --all-databases --auto-repair -p"yourpassword" -u "yourusername"

Posted: Mon Sep 13, 2010 4:33 pm
by mastertheknife
Look at your system log, you will probably see mysql errors.
Anyways, your MySQL probably crashed and now has corrupt tables.
You need to repair those tables, if you have phpmyadmin, just go to the corrupt tables and do a repair operation.
You can read here how to prevent this from happening again:
http://www.zoneminder.com/forums/viewtopic.php?t=15473