ZoneMinder Forums

Hi, My zm was running smoothly, until today. It is just started not recording. I have 4 cameras, none is recording. It means that I see all the camera live views, but in console view, all red and says "Not running" and in individual camera view, they have the remark:

Monitor is not capturing. We will be unable to provide an image

I suspect it is a date issue, but I might be wrong... Started to dig through the LOGS.

First thing I realized:

Version mismatch, system is version 1.36.35, database is 1.36.33, please run zmupdate.pl to update.

So I tried to run the upgrade:

Upgrading database to version 1.36.35
Upgrading DB to 1.36.34 from 1.36.33
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1292 (22007) at line 11: Incorrect datetime value: '0000-00-00 00:00:00' for column 'UpdatedOn' at row 1
Output:
Command 'mysql -u'zmuser' -p'ErosStrong' -hlocalhost zm < /usr/share/zoneminder/db/zm_update-1.36.34.sql' exited with status: 1

I have checked all the tables in the zm database, but none have 'UpdatedOn' column...

Any ideas, suggestions?

Unfortunately your mysql is old and stupid.

Edit /usr/share/zoneminder/db/zm_update-1.36.34.sql and remove the NOT NULL from line 4. Also remove default now() if it is there.

Or add the ppa:iconnor/zoneminder-proposed to get a fixed version

It worked, thank you. I succesfully run zmupdate.pl and now everything works.