Datetime error on server, but OK on local dev machine?

I know that there have been a number of posts about datetime issues but I can’t find the answer to this issue.

I am simply trying to insert a value of NULL.

I am using the Wappler Date Picker.

The insert query has this

image

Devtools shows this in both instances under XHR/Headers

data_to: 0000-00-00 00:00:00

But I get this error on the Server only

message: "SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '-0001-11-30 00:00:00' for column `dg_db`.`tbl_menu_list`.`data_to` at row 1"

Everything did work OK until recently. The only thing I do know is that the hosting company did upgrade some programs on the server.

Current set-up : SPA Pages, Windows 10, MySQL, PHP
Wappler Version : 3.9.7
Operating System : Windows 10 Pro 64bit
Server Model: PHP
Database Type: MySQL

Community Page
Last updated: