I'm trying to upgrade an Umbraco 7.1 installation to 7.6.1 (direct upgrade), however - the installer fails due to missing columns in various tables. I made a fresh 7.6.1 install and compared the two databases and found that the upgrade fails to add the following:
Table UmbracoPropertyTypeGroup:
column uniqueID, type: uniqueIdentifier, not null
Table UmbracoRelationType:
column typeUniqueId, type: uniqueIdentifier, not null
Fixed the steps manually, now I'm getting this error:
The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column.
How do I fix this? Anyone else having this kind of problem?
Yes, I always consult the docs before upgrading, and doing it manually.
(erase /bin, /config, /umbraco, /umbraco_client, copy new files, merge web.config)
Having the same problem. Trying to upgrade a 7.1.9 install to 7.6.2 because I was getting the horrific GetMedia returning blank data preventing me from from using that version. Now I'm getting this annoying error and I need the website up and running by tomorrow morning. The "joys" of upgrading Umbraco. Sigh.
Upgrading Umbraco fails [7.1 -> 7.6.1]
* Reported in the issue tracker * http://issues.umbraco.org/issue/U4-9927
I'm trying to upgrade an Umbraco 7.1 installation to 7.6.1 (direct upgrade), however - the installer fails due to missing columns in various tables. I made a fresh 7.6.1 install and compared the two databases and found that the upgrade fails to add the following:
Table UmbracoPropertyTypeGroup: column uniqueID, type: uniqueIdentifier, not null
Table UmbracoRelationType: column typeUniqueId, type: uniqueIdentifier, not null
Fixed the steps manually, now I'm getting this error: The database failed to upgrade. ERROR: The database configuration failed with the following message: The index 'IX_umbracoNodeUniqueID' is dependent on column 'uniqueID'. ALTER TABLE ALTER COLUMN uniqueID failed because one or more objects access this column.
How do I fix this? Anyone else having this kind of problem?
Hi Simon,
Have you followed the upgrade path process? See the following articles which may assist you:
https://our.umbraco.org/documentation/getting-started/setup/upgrading/version-specific
https://our.umbraco.org/documentation/getting-started/setup/upgrading/general
https://umbraco.com/blog/how-to-diagnose-umbraco-upgrade-problems/
I would also suggest updating Manually rather than using NuGet (which is a pain in the backside sometimes).
Regards
Craig
Yes, I always consult the docs before upgrading, and doing it manually. (erase /bin, /config, /umbraco, /umbraco_client, copy new files, merge web.config)
Umbraco HQ is looking into the issue.
I'm having the same issue after following the upgrade path. Did you get it resolved?
EDIT: Sorry, just found it on the Issue tracker right after posting - http://issues.umbraco.org/issue/U4-9927
All good :)No, I'm considering making another attempt at upgrading later this week or in the beginning of the next
Having the same problem. Trying to upgrade a 7.1.9 install to 7.6.2 because I was getting the horrific GetMedia returning blank data preventing me from from using that version. Now I'm getting this annoying error and I need the website up and running by tomorrow morning. The "joys" of upgrading Umbraco. Sigh.
is working on a reply...