Upgrade from 1.34.9 to 1.34.10 and got SQL ERR

Forum for questions and support relating to the 1.34.x releases only.
Post Reply
jbug
Posts: 5
Joined: Thu Apr 09, 2020 4:29 pm

Upgrade from 1.34.9 to 1.34.10 and got SQL ERR

Post by jbug »

After the upgrade, the time stamp font size option show 1 and 2 instead of Default and Large. When I attempted to change the time stamp position, I got a SQL error for incorrect integer value 'Large' for the LabelSize field. Apparently, the value/name got switched. What would be a proper way to fix it? Thanks

SQL-ERR 'SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: 'Large' for column `zm`.`Monitors`.`LabelSize` at row 1', statement was 'UPDATE Monitors SET `Id`=?, `Name`=?, `Notes`=?, `ServerId`=?, `StorageId`=?, `Type`=?, `Function`=?, `Enabled`=?, `LinkedMonitors`=?, `Triggers`=?, `Device`=?, `Channel`=?, `Format`=?, `V4LMultiBuffer`=?, `V4LCapturesPerFrame`=?, `Protocol`=?, `Method`=?, `Host`=?, `Port`=?, `SubPath`=?, `Path`=?, `Options`=?, `User`=?, `Pass`=?, `Width`=?, `Height`=?, `Colours`=?, `Palette`=?, `Orientation`=?, `Deinterlacing`=?, `DecoderHWAccelName`=?, `DecoderHWAccelDevice`=?, `SaveJPEGs`=?, `VideoWriter`=?, `OutputCodec`=?, `OutputContainer`=?, `EncoderParameters`=?, `RecordAudio`=?, `RTSPDescribe`=?, `Brightness`=?, `Contrast`=?, `Hue`=?, `Colour`=?, `EventPrefix`=?, `LabelFormat`=?, `LabelX`=?, `LabelY`=?, `LabelSize`=?, `ImageBufferCount`=?, `WarmupCount`=?, `PreEventCount`=?, `PostEventCount`=?, `StreamReplayBuffer`=?, `AlarmFrameCount`=?, `SectionLength`=?, `MinSectionLength`=?, `FrameSkip`=?, `MotionFrameSkip`=?, `AnalysisFPSLimit`=?, `AnalysisUpdateDelay`=?, `MaxFPS`=?, `AlarmMaxFPS`=?, `FPSReportInterval`=?, `RefBlendPerc`=?, `AlarmRefBlendPerc`=?, `Controllable`=?, `ControlId`=?, `ControlDevice`=?, `ControlAddress`=?, `AutoStopTimeout`=?, `TrackMotion`=?, `TrackDelay`=?, `ReturnLocation`=?, `ReturnDelay`=?, `DefaultRate`=?, `DefaultScale`=?, `SignalCheckPoints`=?, `SignalCheckColour`=?, `WebColour`=?, `Exif`=?, `Sequence`=?, `ZoneCount`=?, `Refresh`=?, `DefaultCodec`=? WHERE Id=?' params:7,Front Left,,1,6,Ffmpeg,Modect,1,,,,0,0,,1,rtsp,rtpRtsp,user:xxxx@192.168.1.39,554,,rtsp://user:xxxx2@192.168.1.39:554/cam/realmonitor?channel=1&subtype=0,,,,2304,1296,4,0,ROTATE_0,0,,,3,0,,,# Lines beginning with # are a comment # For changing quality, use the crf option# 1 is best, 51 is worst quality#crf=23,0,0,-1,-1,-1,-1,Event-,%N - %d/%m/%y %H:%M:%S,1920,1260,Large,50,20,24,48,0,3,600,10,0,0,6.00,0,,,100,12,6,0,,000,,,0,,-1,,100,50,0,#0000be,#82e4e0,0,,4,,MP4,7
User avatar
iconnor
Posts: 3362
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Upgrade from 1.34.9 to 1.34.10 and got SQL ERR

Post by iconnor »

Found that myself during putting together 1.34.11. I have tagged 1.34.11 and will formalise the release today.
jbug
Posts: 5
Joined: Thu Apr 09, 2020 4:29 pm

Re: Upgrade from 1.34.9 to 1.34.10 and got SQL ERR

Post by jbug »

Fixed in 1.34.11. Thank you.
Post Reply