Search found 1 match
- Thu May 12, 2016 11:43 am
- Forum: ZoneMinder 1.29.x
- Topic: Ubuntu 16.04 and MySQL 5.7 - can't access events
- Replies: 6
- Views: 10966
Re: Ubuntu 16.04 and MySQL 5.7 - can't access events
I ran into this same problem. Removing the mysql sql-option ONLY_FULL_GROUP_BY allowed for backwards compatibility and seems to work for me. 1) login and determine what sql-modes you are using, remove only mode ONLY_FULL_GROUP_BY mysql> SELECT concat('sql-mode=', REPLACE(@@sql_mode,'ONLY_FULL_GROUP ...