SQL error when adding a new Monitor Ubuntu 16.04 32 bit

[churusaa]

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:

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'

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.

[churusaa]

Update

I have removed the PPA from my list, and I'm completely purging an reinstalling MySQL and ZoneMinder 1.29 to see if my results improve.

[churusaa]

Update 2

Yes. This is apparently just weirdness related to 1.30. It works great in 1.29, and the web interface lines up a lot better, too.

[SteveGilvarry]

You used an un-released storage areas PPA.

[iconnor]

1.30 has NOT been released. Do not go installing bleeding edge experimental repos that you find on the net and expect wonderful things to happen.

The issue here is about working around the problems with mysql5.7 strict mode. There is much work yet to be done. Stick with 1.29 and the easy way instructions.