Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Incorrect datetime value


aespinal2

Recommended Posts

osCommerce V2.3.
The store of my friend does not take new costumers. When they try to create an account, the store shows:
1292 - Incorrect datetime value: '0000-00-00 00:00:00' for column 'customers_dob' at row 1

Link to comment
Share on other sites

@aespinal2 Is this a new problem? Has something changed on your friend's host/server?

I had a similar issue with the configuration on my in-house development server. I was able to fix the configuration as described here:

That said, I don't know how your friend's server is set up. You may have to talk to their host about this.

HTH

M

Link to comment
Share on other sites

5 hours ago, aespinal2 said:

Incorrect datetime value: '0000-00-00 00:00:00'

If this just started happening then the host has probably upgraded the mysql version. But regardless, the easiest way to fix it is to run this command

UPDATE customers SET customers_fob = '1970-01-02' WHERE customers_dob = '0000-00-00 00:00:00'

 

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...