Katamaze: PDOException: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '0000-00-00'

[DeboraT.]

I have the Katamaze add-on for electronic invoicing. Previously I used a dedicated server on serverplan, now I have moved everything to Siteground. Since then I have a problem "PDOException: SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '0000-00-00'" I contacted my server and they said: "The error you are getting is due to SQL Server operating in strict mode, which does not allow '0000-00-00' to be used as a valid date. Instead of disabling strict mode, which is generally not recommended to maintain database integrity, you can resolve this issue by addressing the root cause in your code or database schema." I should therefore insert instead of '0000-00-00', the value NULL or a valid default date. I wrote to support but they do not respond. What can I do?

[PaulGress]

Hello,

Essentially, strict mode needs to be disabled to ensure WHMCS functions properly. Here's the documentation on this topic:

https://docs.whmcs.com/system/database-and-storage/database-and-storage-tutorials/disable-mysql-strict-mode/

Have you switched providers and moved to a dedicated solution (VPS/dedicated server)? What version of MySQL are you using? Also, which WHMCS version and Billing Extension version do you have?

It would be great to see a comeback from Kian, a brilliant developer with excellent modules of his own.

 

 

[DeboraT.]

I switched from a Serverplan dedicated server to a Siteground Hosting plan.

The server provider Sitgroung replied to me: "We provide Managed Hosting services and I am afraid that it will not be possible to change the MySQL configuration on request.

Here at SiteGround, we strive to provide the best possible security and services. All our servers are protected by an elaborate multi-layered security system.

We have a Security team that is constantly looking for changes that need to be made to our security system and they have deemed that MySQL on our servers should use Strict Mode ."

the MySQL version is 8.0
While for the Billing Extension module it is at version 2.2.200
WHMCS version is 8.11.2