crazyracer98
Cadet
- Joined
- Nov 26, 2018
- Messages
- 1
Recently I tried to install the Zoneminder plugin on my FreeNAS 11.2 RC2 machine, but I ran into the following error:
After a bit of research I found the following post in the Zoneminder forums:
https://forums.zoneminder.com/viewtopic.php?t=24609#p94162
So I changed the following line in "/usr/local/my.cnf" from
to
and now I can add cameras!
SQL-ERR 'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'V4LMultiBuffer' at row 1', statement was 'insert into Monitors set LinkedMonitors = '', [...]
After a bit of research I found the following post in the Zoneminder forums:
https://forums.zoneminder.com/viewtopic.php?t=24609#p94162
So I changed the following line in "/usr/local/my.cnf" from
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
to
sql_mode=NO_ENGINE_SUBSTITUTION
and now I can add cameras!