Hi all,
I have a table in MySql with a datetime field "SendDate". When I create the record in Dadabik, I don't want to insert that field, because it is managed by another app and it is filled when an operation is completed.
So, in MySQL, that field is declared like this
In Dadabik. I have set the form configurator so that it is not a required field.
But when I try to insert a record, I got the error "Invalid datetime format: 1292 Incorrect datetime value: '' for column 'SendDate' at row 1"
Infact, I see the query statement contain also that field and I don't understand why, as it is not required.
Any help ?
You are using DaDaBIK version 9.2.1-Monterosso pro, installed on 11-10-2021 (installation code: 17311616419ec13f19), the latest version of DaDaBIK is 11.4-Elba released on 28-02-2022
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 7.3.12
mysql version: 5.7.28
Web server: Apache/2.4.41 (Win64) PHP/7.3.12
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36 Edg/100.0.1185.36
I have a table in MySql with a datetime field "SendDate". When I create the record in Dadabik, I don't want to insert that field, because it is managed by another app and it is filled when an operation is completed.
So, in MySQL, that field is declared like this
In Dadabik. I have set the form configurator so that it is not a required field.
But when I try to insert a record, I got the error "Invalid datetime format: 1292 Incorrect datetime value: '' for column 'SendDate' at row 1"
Infact, I see the query statement contain also that field and I don't understand why, as it is not required.
Any help ?
You are using DaDaBIK version 9.2.1-Monterosso pro, installed on 11-10-2021 (installation code: 17311616419ec13f19), the latest version of DaDaBIK is 11.4-Elba released on 28-02-2022
You are not running the last release of DaDaBIK, the release you are running might have bugs and security holes, see the official change log for further information. You can upgrade DaDaBIK here.
PHP Version: 7.3.12
mysql version: 5.7.28
Web server: Apache/2.4.41 (Win64) PHP/7.3.12
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/100.0.4896.75 Safari/537.36 Edg/100.0.1185.36