Changing anything in "Control capabilities" causes SOL-ERR

Forum for questions and support relating to 1.33.x development only.
Locked
simonpg
Posts: 14
Joined: Fri Nov 29, 2019 8:55 pm

Changing anything in "Control capabilities" causes SOL-ERR

Post by simonpg »

I hesitate to post this because I feel that I must be doing something funDUHmentally wrong. I am working on the Amcrest HTTP API and associated Amcrest_HTTP.pm script, because I have Amcrest cameras and it seems that they can do more than the current script supports. However, any change to Control Capabilities causes

Code: Select all

"SQL-ERR 'SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column `zm`.`Controls`.`CanMoveDiag` at row 1', statement was 'UPDATE Controls SET `Id`=?
and a dump of all the parameter names

Code: Select all

WHERE Id=?' params:40,1,0,1,0,0,1,1,1,0,,,0,0,0,0,,0,0,,0,1,0,0,0,0,,0,0,,0,1,,,1,0,0,0,0,,0,0,,,,,,0,0,0,0,,0,0,,,,,,0,0,0,0,,0,0,,,,,,0,0,0,0,,0,0,,,,,,0,0,0,0,,0,0,1,5,,,Amcrest HTTP API,Ffmpeg,Amcrest_HTTP,40
I'm guessing those undefined values are what are causing the "Incorrect integer value" error, but I am no DBA. I tried changing Control Capabilities on other cameras and come up with the same error.

I should add that I am on version 1.33.16 on Debian Buster.
User avatar
iconnor
Posts: 2879
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Changing anything in "Control capabilities" causes SOL-ERR

Post by iconnor »

Unfortunately when running master, telling us 1.33.16 isn't very helpful. We've been at 1.33.16 since before christmas.

We need to know exactly when you package is from, which you can get with dpkg -s zoneminder

I might suggest that you just need to update. I did some work in there over the holidays and likely fixed this problem.
simonpg
Posts: 14
Joined: Fri Nov 29, 2019 8:55 pm

Re: Changing anything in "Control capabilities" causes SOL-ERR

Post by simonpg »

# dpkg -s zoneminder
Package: zoneminder
Status: install ok installed
Priority: optional
Section: net
Installed-Size: 40401
Maintainer: Isaac Connor <isaac@zoneminder.com>
Architecture: amd64
Version: 1.33.16~20191225.23-buster

# apt update
Ign:1 https://zmrepo.zoneminder.com/debian/master buster/ InRelease
Hit:2 https://zmrepo.zoneminder.com/debian/master buster/ Release
Hit:4 http://mirrors.syringanetworks.net/debian buster InRelease
Get:5 http://mirrors.syringanetworks.net/debian buster-updates InRelease [49.3 kB]
Hit:6 http://security.debian.org/debian-security buster/updates InRelease
Fetched 49.3 kB in 5s (9,383 B/s)
Reading package lists... Done
Building dependency tree
Reading state information... Done
All packages are up to date.

Just to be clear, I updated to this point before I posted this error; and the error does still exist.
User avatar
iconnor
Posts: 2879
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Changing anything in "Control capabilities" causes SOL-ERR

Post by iconnor »

Dang it, zmrepo hasn't been updating. I'll fix that. Please update.

Please also note that I just released 1.34.0 so if you don't get up to that version, you are not up to date.
simonpg
Posts: 14
Joined: Fri Nov 29, 2019 8:55 pm

Re: Changing anything in "Control capabilities" causes SOL-ERR

Post by simonpg »

No updates from zmrepo :(
simonpg
Posts: 14
Joined: Fri Nov 29, 2019 8:55 pm

Re: Changing anything in "Control capabilities" causes SOL-ERR

Post by simonpg »

I upgraded to Version: 1.34.0-buster. This issue has been fixed. :)
User avatar
iconnor
Posts: 2879
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: Changing anything in "Control capabilities" causes SOL-ERR

Post by iconnor »

hurray!
Locked