ZM 1.30.2 with 5.7.17-0
Posted: Fri Apr 14, 2017 5:49 pm
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?
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'