Incorrect datetime value

[aespinal2]

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

[ArtcoInc]

@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

[Jack_mcs]

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'