All recorded events have no duration

[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?

[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"

[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