So, we are upgrading from 3.2.0. We did the usual. We installed v6 and patch 1 first. We exported the database from v3 with the Drop Add table commands. Imported the v3 into the v6 database replacing the new tables with the old. Ran upgrade starting at 3.1.0. After fixing SQL errors along the way. I saved a few of them in the attached text file. We get to the end and could not log in with any of the known accounts.
tracy_migration_errors.txt (2.9 KB)
I did a new install then exported the username and password from the second v6 install to import into the first v6 install. That did not work because it gave me a column mismatch.
I am looking for suggestions on what can be done to log in.
In the past when upgrading from version 3x to 4x the passwords were moved to the users_secure table and the users table was marked as ‘nolongerused’. Well that does not happen in v6. The login fails and I check the table and the password is still in the users table password column.
I was thinking of going back and do the upgrade to 4.2.2 first. Any comments on this topic are welcomed.