Quote Originally Posted by dbltoe View Post
Back at the problems with the 1.3.9h to 1.5.5 upgrade...
When doing:
  1. complete new install of 1.5.5 zip using download from last night.
  2. new database populated by 1.5.5 install
  3. delete tables on new install
  4. import tables from old site
  5. run database upgrade using zc_install
  6. upgrade stops saying we are not at 1.5.3 and cannot upgrade to 1.5.4
  7. backing up to the zc_install directory and selecting database upgrade once again.
  8. Get Click image for larger version.  Name: install.jpg  Views: 134  Size: 18.5 KB  ID: 15947
  9. Go to admin and get Click image for larger version.  Name: admin.jpg  Views: 118  Size: 20.1 KB  ID: 15948
  10. Look at database with Navicat and get Click image for larger version.  Name: database.jpg  Views: 131  Size: 14.0 KB  ID: 15949

Nothing we do can get us past this point.
Thanks for the test database. I found a way to log some more detailed errors, and it flagged up an error related to your customers table.
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 can't find where customers_dob was ever set to zeros by default, so I'm reluctant to start adding SQL to the upgrade to deal with userland data problems.