aespinal2 Posted October 15, 2021 Share Posted October 15, 2021 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 More sharing options...
ArtcoInc Posted October 15, 2021 Share Posted October 15, 2021 @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 More sharing options...
Jack_mcs Posted October 16, 2021 Share Posted October 16, 2021 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. All of My Addons Get the latest versions of my addons Recommended SEO Addons Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.