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
zmupdate.pl fails
Re: zmupdate.pl fails
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...
Re: zmupdate.pl fails
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.
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.
Re: zmupdate.pl fails
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.
Read read read. I need to learn to read better.
Anyway. from here http://zoneminder.readthedocs.io/en/lat ... untu-16-04
Step 3.
Re: zmupdate.pl fails
For future reference Ubuntu upgrades have been documented: https://wiki.zoneminder.com/Common_Issu ... PA_version
Re: zmupdate.pl fails
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.
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.
Re: zmupdate.pl fails
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?
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?
Re: zmupdate.pl fails
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
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
Re: zmupdate.pl fails
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
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