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
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:
Last updated: