Re: Cpanel (Linux) to Windows Server

[Steve Copelin]

Ok, Let me answer my own question, sorry for the post, but it might help someone if they come across the same issue.

It ended up being STRICT_TRANS_TABLES that restricted zero values being entered into the database on INSERT and UPDATE.

On my windows machine I opened up the my.ini file and added this line as it doesn't exist.

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

But, you need to remove the STRICT_TRANS_TABLES part of the line. Reboot MySQL via the services and happy days!
Also, I did run into the same issue on a Ubuntu 22.04 install with the same insert/update, so I'm gathering it is the same problem there. I haven't tested it.