zoneminder 1.30.4 SQL error

[felixita]

Hy, i've yet installed zoneminder 1.30.4 on my Arch linux (10.1.24-MariaDB). When i try to save a new monitor setup i got an database error as show below:

Code: Select all

 SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'Protocol' 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', 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've forgot some setting? A bug?

Thant's for help me.

[felixita]

if i substitute zoneminder web site folder with the old 1.29.0 all work well without errors.
Anyone have got same error with 1.30?

[bbunge]

Make the following changes to my.cnf:

character-set-server = latin1
collation-server = latin1_swedish_ci

[felixita]

same error...