Page 1 of 1
Upgrade to 1.30.2 h264 videostorage branch database problems
Posted: Sat Mar 18, 2017 4:09 pm
by Khurram
I decided to upgrade my existing installtion 1.30.0 to 1.30.2 h264 videostorage branch available from iconnor repo. I used the method outlined in the "Ubuntu 16.04 - ZM 1.30.x Upgrade" section at
https://wiki.zoneminder.com/Common_Issu ... _on_Ubuntu. The upgrade didn't give any errors butdid give a warning:
Code: Select all
Setting up zoneminder (1.30.2~20170221163027-xenial) ...
Installing new version of config file /etc/apache2/conf-available/zoneminder.conf ...
Initiating database upgrade to version 1.30.2 from version 1.30.0
Upgrading database to version 1.30.2
Loading config from DB
Saving config to DB
Upgrading DB to 1.30.1 from 1.30.0
mysql: [Warning] Using a password on the command line interface can be insecure.
Database successfully upgraded to version 1.30.1.
Upgrading DB to 1.30.2 from 1.30.0
mysql: [Warning] Using a password on the command line interface can be insecure.
Database successfully upgraded to version 1.30.2.
Database upgrade to version 1.30.2 successful.
Freshening configuration in database
Loading config from DB
Saving config to DB
Done Updating, starting ZoneMinder
But all my monitors are in red because I think the database did not get upgraded. In the log I get errors such as
Code: Select all
zmc_dvideo13 13761 ERR Can't load local monitors: Unknown column 'SaveJPEGs' in 'field list'
Do I have to upgrade the database manually? If so, how?
Thanks.
Re: Upgrade to 1.30.2 h264 videostorage branch database problems
Posted: Sat Mar 18, 2017 4:10 pm
by PacoLM
Try this-> sudo /usr/bin/zmupdate.pl
Re: Upgrade to 1.30.2 h264 videostorage branch database problems
Posted: Sat Mar 18, 2017 4:23 pm
by Khurram
PacoLM wrote:Try this-> sudo /usr/bin/zmupdate.pl
Should I do this after apt upgrade finishes?
Edit:
I tried it after apt upgrade and got the following message
Code: Select all
Database already at version 1.30.2, update aborted.
Re: Upgrade to 1.30.2 h264 videostorage branch database problems
Posted: Sat Mar 18, 2017 10:41 pm
by SteveGilvarry
Let me check this, there are some db changes that h264 needs but they never get a version number as they are not released. The readme of that branch does mention them, and I believe a new db from scratch has the fields in monitor table. When it goes to master zmupdate will work.
Re: Upgrade to 1.30.2 h264 videostorage branch database problems
Posted: Tue Mar 21, 2017 5:29 pm
by Khurram
SteveGilvarry wrote:Let me check this, there are some db changes that h264 needs but they never get a version number as they are not released. The readme of that branch does mention them, and I believe a new db from scratch has the fields in monitor table. When it goes to master zmupdate will work.
Any update on this? Thanks.
Edit:
Also found this
https://gist.github.com/mastertheknife/8042406. Will running this sql script on the database after the upgrade has finished do the job?
Re: Upgrade to 1.30.2 h264 videostorage branch database problems
Posted: Wed Mar 22, 2017 10:55 am
by SteveGilvarry
https://github.com/ZoneMinder/ZoneMinde ... 1.29.2.sql
So this is the one, problem being this only exists in that branch and you are coming from 1.30 so it is not applying. I believe you can do zmupdate.pl --version=1.29.1, which will reapply the db changes and pick this one up. When we go into mainline this script will get the next version number and upgrades will be less seamed.
Re: Upgrade to 1.30.2 h264 videostorage branch database problems
Posted: Thu Mar 23, 2017 12:32 pm
by Khurram
SteveGilvarry wrote:https://github.com/ZoneMinder/ZoneMinde ... 1.29.2.sql
So this is the one, problem being this only exists in that branch and you are coming from 1.30 so it is not applying. I believe you can do zmupdate.pl --version=1.29.1, which will reapply the db changes and pick this one up. When we go into mainline this script will get the next version number and upgrades will be less seamed.
That solved the problem, thanks
