v1.37.11, zmrepo/master, debian

[jyrkipes]

First, humble thank You!

I know I'm on thin ice with /master but been riding the bleeding edge happily as long as I remember so minor breakage hasn't bothered.

Code: Select all

user@avalon:~$ sudo apt policy zoneminder
[sudo] user-user password:
zoneminder:
  Installed: 1.37.11~20220202.73-bullseye

Code: Select all

user@avalon:~$ lsb_release -a
No LSB modules are available.
Distributor ID: Debian
Description:    Debian GNU/Linux 11 (bullseye)
Release:        11
Codename:       bullseye

Yesterday something bigger came in and assume it's related to this:
Replace function concept #3420

Looks like all my cameras are now down and I cannot reconfigure or save new selections on
- Capturing: None/Always/Ondemand
- Recording: None/Onmotion/Always
- Analyzing: None/Always

Actually, just not changing anything and hitting Save gives always the one below.

If I hit save, will get sql-related mess:

Code: Select all

SQL-ERR '00000 ', statement was 'UPDATE `Monitors` SET `Id`=?, `Name`=?, `Notes`=?, `ServerId`=?, `StorageId`=?, `ManufacturerId`=?, `ModelId`=?, `Type`=?, `Capturing`=?, `Analysing`=?, `Recording`=?, `Enabled`=?, `DecodingEnabled`=?, `JanusEnabled`=?, `JanusAudioEnabled`=?, `LinkedMonitors`=?, `Triggers`=?, `EventStartCommand`=?, `EventEndCommand`=?, `ONVIF_URL`=?, `ONVIF_Username`=?, `ONVIF_Password`=?, `ONVIF_Options`=?, `ONVIF_Event_Listener`=?, `use_Amcrest_API`=?, `Device`=?, `Channel`=?, `Format`=?, `V4LMultiBuffer`=?, `V4LCapturesPerFrame`=?, `Protocol`=?, `Method`=?, `Host`=?, `Port`=?, `SubPath`=?, `Path`=?, `SecondPath`=?, `Options`=?, `User`=?, `Pass`=?, `Width`=?, `Height`=?, `Colours`=?, `Palette`=?, `Orientation`=?, `Deinterlacing`=?, `DecoderHWAccelName`=?, `DecoderHWAccelDevice`=?, `SaveJPEGs`=?, `VideoWriter`=?, `OutputCodec`=?, `Encoder`=?, `OutputContainer`=?, `EncoderParameters`=?, `RecordAudio`=?, `OutputSourceStream`=?, `RTSPDescribe`=?, `Brightness`=?, `Contrast`=?, `Hue`=?, `Colour`=?, `EventPrefix`=?, `LabelFormat`=?, `LabelX`=?, `LabelY`=?, `LabelSize`=?, `ImageBufferCount`=?, `MaxImageBufferCount`=?, `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`=?, `ModectDuringPTZ`=?, `DefaultRate`=?, `DefaultScale`=?, `SignalCheckPoints`=?, `SignalCheckColour`=?, `WebColour`=?, `Exif`=?, `Sequence`=?, `ZoneCount`=?, `Refresh`=?, `DefaultCodec`=?, `Latitude`=?, `Longitude`=?, `RTSPServer`=?, `RTSPStreamName`=?, `Importance`=? WHERE Id=?'

Earlier yesterday (GMT-2/Helsinki) lost streaming/viewing thru web -interface, lot of old classic "If you cannot see pics see this FAQ" and recently after .73 kicked in, this:

Code: Select all

Memory map file '/dev/shm/zm.mmap.20' does not exist in zmMemAttach. zmc might not be running

to all cameras.

So I think, something-something broke streaming and then this new way of handling camera source broke something more.

Anyway, keep up good, my 0.02cents.

(Will send actual cents from my next paycheck.)

[iconnor]

Yeah that's a big problem, and I think I already have it fixed, new proper master packages should have built this morning.

[jyrkipes]

Excellent!

Did update {apt update & upgrade] to .83,
- web streaming of old events started working
- image icons good again
- cannot save, gives previous sql error
- cannot record/mocord/analyse

went to
/usr/share/zoneminder/db
and found this that had the missing Capturing -column update (and maybe others), and what I assume did not run (as should?) when sudo zmupdate.pl

Gave a command:
sudo mysql -usqluser -psqluserpassword zm < zm_update-1.37.multistream.sql

Did restart from webui

And it works!