SQL error when adding a new Monitor Ubuntu 16.04 32 bit
Posted: Tue May 10, 2016 9:32 am
Please let me start by apologizing. I know I am posting this in the 1.29 section, but there does not yet appear to be a 1.30 board yet, and I didn't know where else to ask this question.
After installing 1.30 (the default version on offer) for Xenial from the ppa at https://launchpad.net/~iconnor/+ppa-packages, and using the easy-way guide at https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way I am able to view the console and start the process of adding a new monitor, but when I try to save the monitor, I am greeted by this lovely SQL error:
I believe I followed the guide to the letter, but I have been known to make mistakes in the past. I even made sure to disable engine substitution in mysql, but I seem to have overlooked something major. Is it as simple as the fact that apparently 1.30 isn't ready to go yet and I'm just a fool for assuming I needed to use a PPA?
Thank you for any assistance you can provide.
After installing 1.30 (the default version on offer) for Xenial from the ppa at https://launchpad.net/~iconnor/+ppa-packages, and using the easy-way guide at https://wiki.zoneminder.com/Ubuntu_Serv ... e_easy_way I am able to view the console and start the process of adding a new monitor, but when I try to save the monitor, I am greeted by this lovely SQL error:
Code: Select all
SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'LinkedMonitors' cannot be null', statement was 'insert into Monitors set LinkedMonitors = NULL, Device = '/dev/video0', Channel = '0', Format = '255', Palette = '0', V4LMultiBuffer = NULL, V4LCapturesPerFrame = '1', Protocol = NULL, Host = NULL, Port = '80', Method = NULL, Options = NULL, Path = NULL, User = NULL, Pass = NULL, Colours = '3', Width = '320', Height = '240', Orientation = '0', Deinterlacing = '0', SaveJPEGs = '3', VideoWriter = '0', EncoderParameters = '# Lines beginning with # are a comment \r\n# For changing quality, use the crf option\r\n# 1 is best, 51 is worst quality\r\n#crf=23', RecordAudio = '0', RTSPDescribe = '0', StorageId = NULL, 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 = NULL, Type = 'Local', Function = 'Monitor', Enabled = '1', AnalysisFPS = NULL, MaxFPS = NULL, AlarmMaxFPS = NULL, RefBlendPerc = '6', AlarmRefBlendPerc = '6', Sequence = 1'Thank you for any assistance you can provide.