SQL error in production datetime missing

Scriptcase 9 General
#1

In development this works but on my production server I get this error
Error while accessing the database
Incorrect datetime value: ‘’ for column ‘ticketDetailDate’ at row 1
[TABLE]
[TR]
[TD]INSERT INTO ticketDetail(idticket ,ticketDetailDate ,ticketContent ,ticketAssignStatus ,ticketStatus) VALUES( ‘173’, ‘’, ‘i wish this was somple’, ‘5’, ‘1’)[/TD]
[/TR]
[/TABLE]

As you can see it is not pulling anything for the ticketDetailDate field. In scrip case I set this field to be the datetime of insert so I am not sure what I am missing

#2

in this case,
INSERT INTO ticketDetail (idticket, ticketDetailDate, ticketContent, ticketAssignStatus, ticketStatus) VALUES (‘173’, ‘’, ‘i wish this was somple’, ‘5’, ‘1’),
either you give a value to ticketDetailDate according to the field, here you give a null ‘’,
if you do not want to fill it via your INSERT,
then do not design it in your list of fields (idticket, ticketContent, …) so in values (‘173’, 'I wish this …)

#3

Good morning,
what I needed up doing was removing the setting in the field section in script case to have it insert the date time and setup the system to grab this information during the onAfterInsert event
{ticketStartDate} = date(“Y-m-d H:i:s”);

the crazy thing is this form is an exact copy of another form that I did not have to make this change on in the production environment. The only difference after it was copied was that some of the fields were set to disabled.

#4

Don’t disabled field. Try only with option “hidden field”

#5

you can maybe look there to:
https://sql.sh/cours/insert-into/on-duplicate-key

#6

I needed the fields disabled because I need them visible by the end user but I do not want them to make changes