ZoneMinder Forums

Same here too.

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

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_...

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...

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.

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...

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 ...

Older version of zm but this fix worked for me.

viewtopic.php?f=32&t=23101&p=87695&hili ... tur#p87695

hey all:

My searching skills are lacking.
Can I just upgrade ubuntu 14.04 to 16.04 without worrying about zoneminder?

Currently on version 1.29.0-trusty-2016021001

It has been setup like recommended. I dont know why mysqltuner is telling me to change things. Here is my.cnf # # The MySQL database server configuration file. # # You can copy this to one of: # - "/etc/mysql/my.cnf" to set global options, # - "~/.my.cnf" to set user-specific opt...

I dunno. Today I was poking around and decided to stop and start zoneminder from the webpage instead of using the command line. After that the log reporting is fine. I had restarted the entire computer several times, along with several restarts of both mysql and zoneminder from command lines. So I d...

Still same error. 2016-05-02 18:54:51.040420 zmwatch 2402 FAT Can't execute: MySQL server has gone away zmwatch.pl 2016-05-02 18:43:09.637390 zmaudit 3232 FAT Can't execute: MySQL server has gone away zmaudit.pl Notes. I ran this. mysqlcheck -uroot -p --optimize --databases zm Gor a bunch of this. A...

Can zoneminder run if it does not have a database? (database has gone away message)
Because zoneminder is running just fine. Everything.

Well I tried some of the suggestions linked above. Nothing helped. This has been a running system for a few years now. I can add monitors, change filters, and everything else. Its just I dont get any logs reported. Just the database has gone away message. I have several months of mysql backups. Gues...

Anyone? Bueller, Bueller.