Quote Originally Posted by DrByte View Post
Also using Navicat I discovered that you have a single customer record in your particular DB whose customers_dob is set to '0000-00-00 00:00:00' (which is invalid in modern MySQL versions) instead of '0001-01-01 00:00:00'. Changing that lets the installer properly update the schema in the customers table for the v153 changes, and lets the installer proceed.
I have no clue as to how the date was changed but, you are right, it should not have been what it was.
Could you share your Navicat method for finding this? I've had no luck in doing so myself. Of course, a sort in the customer table works but, I've found this in more than one database. It would be nice to have a shortcut for doing this since several of our current sites transferred in. it would be prudent for me to check a little closer before updating.
THANX