Update Database from V8.17.2 to V9.30 --> Error = Invalid column name 'userOrMemberKey'
I get this error message during installation of Umbraco from V8.17.2 to V9.30
Error during installation
The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'userOrMemberKey'. Please check log file for additional information (can be found in '~/umbraco/Logs')
If you migrate to 9.2 first and then upgrade to 9.3 then it should work.
It looks like a new database table migration was added in 9.3, but something isn't quite right with it, eg it only works if the database has already been upgraded to 9.2!
I suspect it will be fixed in a later version of 9.3.x
Exactly what Marc said, i've experienced this aswell, and I can confirm first upgrading to 9.2 works.
I've made a pullrequest to the documenation to add this to the upgrade notes for as long as it isn't fixed yet so hopefully less people will be struggling with this.
Hi,
thanks for answer. Yes, i read it here but dont have time to answer my self. It works well. For developing and staging i must first migrate to v9.2 update all addons publish and then migrate to v9.3.
But after migrating to 9.2 we have new problems. Double Group-Keys Exception in a dictionary on start of application. But for this i do create issue on github.
Update Database from V8.17.2 to V9.30 --> Error = Invalid column name 'userOrMemberKey'
I get this error message during installation of Umbraco from V8.17.2 to V9.30
Error during installation
The database failed to upgrade. ERROR: The database configuration failed with the following message: Invalid column name 'userOrMemberKey'. Please check log file for additional information (can be found in '~/umbraco/Logs')
Hi Alexander
If you migrate to 9.2 first and then upgrade to 9.3 then it should work.
It looks like a new database table migration was added in 9.3, but something isn't quite right with it, eg it only works if the database has already been upgraded to 9.2!
I suspect it will be fixed in a later version of 9.3.x
But for time being you need to hop to 9.2 first!
regards
marc
Exactly what Marc said, i've experienced this aswell, and I can confirm first upgrading to 9.2 works.
I've made a pullrequest to the documenation to add this to the upgrade notes for as long as it isn't fixed yet so hopefully less people will be struggling with this.
Hi, thanks for answer. Yes, i read it here but dont have time to answer my self. It works well. For developing and staging i must first migrate to v9.2 update all addons publish and then migrate to v9.3.
But after migrating to 9.2 we have new problems. Double Group-Keys Exception in a dictionary on start of application. But for this i do create issue on github.
is working on a reply...