ZM 1.30.2 with 5.7.17-0

[MrRose]

Hello,

I install a new MySQL server with ZM 1.30.2.

If I try to add a new camera via Add new Monitor and save it at the end i get the follow SQL Error. Whats the reason for it? Any ideas?

Code: Select all

SQL-ERR 'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'V4LMultiBuffer' at row 1', statement was 'insert into Monitors set LinkedMonitors = '', Device = '/dev/video0', Channel = '0', Format = '255', Palette = '0', V4LMultiBuffer = '', V4LCapturesPerFrame = '1', Protocol = '', Host = '', Port = '80', Method = '', Options = '', Path = '', User = '', Pass = '', Colours = '3', Width = '320', Height = '240', Orientation = '0', Deinterlacing = '0', RTSPDescribe = '0', LabelFormat = '%N - %d/%m/%y %H:%M:%S', LabelX = '0', LabelY = '0', LabelSize = '1', ImageBufferCount = '50', WarmupCount = '25', PreEventCount = '25', PostEventCount = '25', StreamReplayBuffer = '1000', AlarmFrameCount = '1', EventPrefix = 'Event-', SectionLength = '600', FrameSkip = '0', MotionFrameSkip = '0', AnalysisUpdateDelay = '0', FPSReportInterval = '1000', DefaultView = 'Events', DefaultRate = '100', DefaultScale = '100', WebColour = 'red', Exif = '0', SignalCheckColour = '#0000c0', Name = 'Monitor-1', ServerId = '', Type = 'Local', Function = 'Monitor', Enabled = '1', AnalysisFPS = '', MaxFPS = '', AlarmMaxFPS = '', RefBlendPerc = '6', AlarmRefBlendPerc = '6', Sequence = 1'

[bbunge]

In the [mysqld] section add the following

sql_mode = NO_ENGINE_SUBSTITUTION

See the WIKI for full install instructions.

[MrRose]

Thanks I try that before. But looks like the wrong mysql config file. Sometimes it´s strange

Now its worked perfekt.