zmupdate.pl fails

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

zmupdate.pl fails

Post by iitywygms »

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: 971
Joined: Wed Dec 02, 2009 9:55 pm
Location: Spain

Re: zmupdate.pl fails

Post by PacoLM »

Try zmupdate.pl -f

After more than 15 years, no longer using ZM as surveillance system.
Now in the dark side, using a commercial system...
iitywygms
Posts: 123
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms »

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: 123
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms »

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: 2930
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: zmupdate.pl fails

Post by bbunge »

For future reference Ubuntu upgrades have been documented: https://wiki.zoneminder.com/Common_Issu ... PA_version
iitywygms
Posts: 123
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms »

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: 123
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms »

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: 123
Joined: Thu Nov 08, 2012 5:19 am

Re: zmupdate.pl fails

Post by iitywygms »

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: 2930
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: zmupdate.pl fails

Post by bbunge »

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
Locked