required field

marcick

Member
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

1649490726105.png

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
 

eugenio

Administrator
Staff member
Hello,
I think you want to insert NULL in the date field, if this is the case, you must
1) check the NULL checkbox close to the filed (the config $null_checkbox must be 1) OR
2) leave the field blank ($treat_blank_as_null must be 1)

Best,
 

marcick

Member
Sorry: what about another timestamp field, where I don't want to enter the current date in Dadabik (so passing null as field to MySQL) and let MySQL to write the curernt TimeStamp when it receive the INSERT statement ?
 
Top