ZoneMinder Forums

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

Try zmupdate.pl -f

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.

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.

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

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.

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?

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

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