Changing anything in "Control capabilities" causes SOL-ERR
Posted: Fri Jan 17, 2020 5:31 am
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 and a dump of all the parameter names 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.
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`=?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,40I should add that I am on version 1.33.16 on Debian Buster.
