SQL error when creating Preclusive zone without specifying ExtendAlarmFrames

Forum for questions and support relating to the 1.32.x releases only.
Post Reply
User avatar
kitkat
Posts: 193
Joined: Sun Jan 27, 2019 5:17 pm

SQL error when creating Preclusive zone without specifying ExtendAlarmFrames

Post by kitkat »

I get a SQL error if I leave the 'Extend Alarm Frame Count' box empty when creating a Preclusive zone.

Not sure where to report bugs so I thought I'd drop it here.

Code: Select all

web_php - 15231 ERR - SQL-ERR 'SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'ExtendAlarmFrames' cannot be null', statement was 'INSERT INTO Zones SET MonitorId=?, `NumCoords` = '4', `Coords` = '382,77 701,10 644,59 273,131', `Area` = '11999', `AlarmRGB` = '16711680', `Name` = 'New', `Type` = 'Preclusive', `Units` = 'Percent', `CheckMethod` = 'FilteredPixels', `MinPixelThreshold` = '20', `MaxPixelThreshold` = NULL, `FilterX` = '3', `FilterY` = '3', `MinAlarmPixels` = '5999', `MaxAlarmPixels` = NULL, `MinFilterPixels` = '4799', `MaxFilterPixels` = NULL, `OverloadFrames` = '2', `ExtendAlarmFrames` = NULL' params:1 - /usr/share/zoneminder/www/includes/database.php 147
It's easy to workaround (just fill in the box), but it's a bit annoying.


e2a: running zoneminder.x86_64 0:1.32.2-1.el7 on CentOS 7.6.1810 (Core)
Post Reply