Today's build does not update database schema

Current Development version likely to have breaking changes
Post Reply
gyzod
Posts: 5
Joined: Wed Jun 15, 2022 8:52 pm

Today's build does not update database schema

Post by gyzod »

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 :

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']
The following command fixes the problem :

Code: Select all

mysql -u zmuser -p *** < /usr/share/zoneminder/db/zm_update-1.37.25.sql
User avatar
iconnor
Posts: 2903
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Today's build does not update database schema

Post by iconnor »

Fixed. New packages building.
tledford
Posts: 4
Joined: Mon Dec 26, 2016 6:59 pm

Re: Today's build does not update database schema

Post by tledford »

iconnor wrote: Fri Oct 14, 2022 1:00 pm Fixed. New packages building.
Just successfully upgraded to 1.37.27, thank you!
Post Reply