zmupdate.pl fails

Forum for questions and support relating to the 1.30.x releases only.
Post Reply
iitywygms
Posts: 114
Joined: Thu Nov 08, 2012 5:19 am

zmupdate.pl fails

Post by iitywygms » Tue Oct 25, 2016 6:25 am

Hi All:

Upgraded ubuntu 14.04 to 16.04.

Went from zm 1.29 to 1.30

Had some error along the way so I uninstalled 1.29 and re install 1.30

When starting zm I get the version mismatch error. It tells me to run zmupdate.pl
However, zmupdate.pl fails with

DBD::mysql::st execute failed: Data too long for column 'DefaultValue' at row 1 at /usr/share/perl5/ZoneMinder/Config.pm line 227, <STDIN> line 2.
Can't execute: Data too long for column 'DefaultValue' at row 1 at /usr/bin/zmupdate.pl line 503.

Any ideas on how to get the 1.29 database to work on my new 1.30 version?

Thanks

PacoLM
Posts: 967
Joined: Wed Dec 02, 2009 9:55 pm
Location: Spain

Re: zmupdate.pl fails

Post by PacoLM » Tue Oct 25, 2016 7:03 am

Try zmupdate.pl -f

mini-ITX system (6 IPCams - Ubuntu14.04 - ZM1.31.1)

iitywygms
Posts: 114
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms » Tue Oct 25, 2016 2:34 pm

Hi and thank you.

I tried as you suggested but still the same error.

Here is what I get.

Freshening configuration in database
Loading config from DB
No option 'ZM_EYEZM_DEBUG' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_EYEZM_EVENT_VCODEC' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_EYEZM_FEED_VCODEC' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_EYEZM_H264_DEFAULT_BR' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_EYEZM_H264_DEFAULT_EVBR' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_EYEZM_H264_TIMEOUT' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_EYEZM_LOG_FILE' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_EYEZM_LOG_TO_FILE' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_EYEZM_SEG_DURATION' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_WEB_P_AJAX_TIMEOUT' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_WEB_P_CAN_STREAM' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_WEB_P_DEFAULT_RATE' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_WEB_P_DEFAULT_SCALE' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_WEB_P_SCALE_THUMBS' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_WEB_P_STREAM_METHOD' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_WEB_P_VIDEO_BITRATE' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
No option 'ZM_WEB_P_VIDEO_MAXFPS' found, removing at /usr/share/perl5/ZoneMinder/Config.pm line 139.
Saving config to DB
DBD::mysql::st execute failed: Data too long for column 'DefaultValue' at row 1 at /usr/share/perl5/ZoneMinder/Config.pm line 227.
Can't execute: Data too long for column 'DefaultValue' at row 1 at /usr/bin/zmupdate.pl line 343.




From zm error log

Version mismatch, system is version 1.30.0, database is 1.29.0, please run zmupdate.pl to update.

iitywygms
Posts: 114
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms » Tue Oct 25, 2016 3:06 pm

Solved it.

Read read read. I need to learn to read better.

Anyway. from here http://zoneminder.readthedocs.io/en/lat ... untu-16-04

Step 3.

bbunge
Posts: 2405
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: zmupdate.pl fails

Post by bbunge » Tue Oct 25, 2016 6:12 pm

For future reference Ubuntu upgrades have been documented: https://wiki.zoneminder.com/Common_Issu ... PA_version

iitywygms
Posts: 114
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms » Wed Oct 26, 2016 2:58 am

Just a fyi.

Once I did Step 3, zoneminder database upgraded normally.
BUT, my mythtv frontends would no longer connect to the backend. I ended up having to restore my original my.cnf.

So for me, I had to do the needful to get the database fore zoneminder to upgrade, but then had to restore my.cnf to defaults for mythtv to properly connect.

Everything seems to be running great now. Will update if anything else pops up.

iitywygms
Posts: 114
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms » Wed Oct 26, 2016 4:18 am

okay.

zmaudit.pl is failing.

if I run it manually I get

DBD::mysql::st execute failed: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'zm.E.StartTime' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by at /usr/bin/zmaudit.pl line 471.


Is it possible to correct this error without modding my.cnf?

Should I start a new thread?

iitywygms
Posts: 114
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms » Wed Oct 26, 2016 5:21 am

So I seem to have fixed everything now.

I disabled the Strict SQL Mode.... Whatever that means.

But it seems to have fixed everything.

Link to what I followed.
https://serverpilot.io/community/articl ... l-5-7.html

bbunge
Posts: 2405
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: zmupdate.pl fails

Post by bbunge » Wed Oct 26, 2016 12:21 pm

In the [mysqld] section add the following

sql_mode = NO_ENGINE_SUBSTITUTION


This is all you needed to add to your my.cnf

Keep in mind that our install instructions are for an install on a clean system. If you have something else installed you will need to be aware of what changes are needed. Replacing the my.cnf symbolic link is a recommendation in my instructions.

bb

Post Reply

Who is online

Users browsing this forum: No registered users and 4 guests