Just Updated to 1.37.22 - nothing working -

Current Development version likely to have breaking changes
Post Reply
homebrewdude
Posts: 54
Joined: Mon Aug 26, 2019 12:42 pm

Just Updated to 1.37.22 - nothing working -

Post 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
User avatar
iconnor
Posts: 2879
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Just Updated to 1.37.22 - nothing working -

Post 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
nrbell
Posts: 30
Joined: Mon Jun 04, 2018 1:14 pm

Re: Just Updated to 1.37.22 - nothing working -

Post by nrbell »

I think that the missing update is actually in /usr/share/zoneminder/db/zm_update-1.37.23.sql.
homebrewdude
Posts: 54
Joined: Mon Aug 26, 2019 12:42 pm

Re: Just Updated to 1.37.22 - nothing working -

Post 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
Post Reply