Page 1 of 1

Just Updated to 1.37.22 - nothing working -

Posted: Mon Sep 19, 2022 1:42 pm
by homebrewdude
Here is a snip from my log.

9/19/22, 9:41:22 AM EDT zmdc 97860 ERR 'zmc -m 3' exited abnormally, exit status 255 zmdc.pl -
9/19/22, 9:41:22 AM EDT zmdc 97860 ERR 'zmc -m 5' exited abnormally, exit status 255 zmdc.pl -
9/19/22, 9:41:22 AM EDT zmdc 97860 ERR 'zmc -m 2' exited abnormally, exit status 255 zmdc.pl -
9/19/22, 9:41:22 AM EDT zmc_m6 103828 ERR No monitors found zmc.cpp 215
9/19/22, 9:41:22 AM EDT zmc_m1 103829 ERR No monitors found zmc.cpp 215
9/19/22, 9:41:22 AM EDT zmc_m1 103829 ERR Can't use query result: Unknown column 'Janus_RTSP_User' in 'field list' zm_monitor.cpp 793
9/19/22, 9:41:22 AM EDT zmc_m6 103828 ERR Can't use query result: Unknown column 'Janus_RTSP_User' in 'field list' zm_monitor.cpp 793
9/19/22, 9:41:22 AM EDT zmc_m1 103829 ERR Can't run query: Unknown column 'Janus_RTSP_User' in 'field list' zm_db.cpp 129
9/19/22, 9:41:22 AM EDT zmc_m6 103828 ERR Can't run query: Unknown column 'Janus_RTSP_User' in 'field list' zm_db.cpp 129
9/19/22, 9:41:22 AM EDT zmc_m5 103827 ERR No monitors found zmc.cpp 215

Re: Just Updated to 1.37.22 - nothing working -

Posted: Mon Sep 19, 2022 2:45 pm
by iconnor
looks like the db update script didn't happen.

sudo zmupdate.pl

if that doesn't fix it...

mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.37.22.sql

Re: Just Updated to 1.37.22 - nothing working -

Posted: Mon Sep 19, 2022 2:50 pm
by nrbell
I think that the missing update is actually in /usr/share/zoneminder/db/zm_update-1.37.23.sql.

Re: Just Updated to 1.37.22 - nothing working -

Posted: Mon Sep 19, 2022 3:36 pm
by homebrewdude
This did not work
mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.37.22.sql


This might have worked, the monitors turned on, no more errors
mysql -u zmuser -p zm < /usr/share/zoneminder/db/zm_update-1.37.23.sql