Jump to content
  • 0

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

DeboraT.

Asked by DeboraT.,

 Share

Question

DeboraT. Junior Member

DeboraT.

Posted
Posted

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?

sca.JPG

0
Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to question listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated

  I accept