Today's build does not update database schema
Posted: Fri Oct 14, 2022 1:52 am
Just updated with today's build. The db schema update v.1.37.25 does not trigger on installation.
No capture from any monitors. Errors like this in the logs :
The following command fixes the problem :
No capture from any monitors. Errors like this in the logs :
Code: Select all
10/13/22 21:46:10.650597 zmc_m1[1105].ERR-zm_db.cpp/181 [Can't run query UPDATE LOW_PRIORITY Monitor_Status SET CaptureFPS = 24.81, CaptureBandwidth=22364, AnalysisFPS = 25.06, UpdatedOn=NOW() WHERE MonitorId=1: Unknown column 'UpdatedOn' in 'field list']
Code: Select all
mysql -u zmuser -p *** < /usr/share/zoneminder/db/zm_update-1.37.25.sql