I'm trying to do a migration from 7.15.3 to 8.2.2. But unfortunately i get the following error:
The database failed to upgrade. ERROR: The database configuration failed with the following message: Migration failed: duplicate 'published' document versions.
Umbraco 8 contains a lot of breaking changes and a lot of code has been cleaned up compared to Umbraco 7. Due to this, it will not be possible to do a direct upgrade from Umbraco 7 to Umbraco 8. Instead, you will need to migrate your content from your Umbraco 7 site into your Umbraco 8 site and then recreate the rest in the new version.
I remember someone having the same issue recently and they were told to run the following query on the v7 database
SELECT cmsContentVersion.ContentId, COUNT(cmsContentVersion.id)
FROM cmsContentVersion
JOIN cmsDocument ON cmsContentVersion.versionid=cmsDocument.versionid
WHERE cmsDocument.published=1
GROUP BY cmsContentVersion.ContentId
HAVING COUNT(cmsContentVersion.id) > 1
They were then able to find the offending documents that had more than one version claiming to be published and take care of them as necessary.
Thanks Rob! That helped, i'll mark your hint as solution.
Nevertheless, i now get the next error:
The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot rename datatype alias "Umbraco.MultiNodeTreePicker2" to "Umbraco.MultiNodeTreePicker" because the target alias is already used...
I really don't see any obsolete property editors on my data types. Do you have a hint on this one as well? 😉
Hi Team,
We are upgrading the Db to 7.15 to 8.5.5, while doing the db upgrade we are getting the below error, can someone help. Thanks in advance.
The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot resolve collation conflict between "PolishCIAS" and "SQLLatin1GeneralCP1CI_AS" in CASE operator occurring in SELECT statement column 35. Please check log file for additional information
Migration Error
Hi There
I'm trying to do a migration from 7.15.3 to 8.2.2. But unfortunately i get the following error:
Any hints on this one?
I'm not sure if it's possible to directly upgrade from v7 => v8.
Migrating content to Umbraco 8
I'm exactly following the mentioned article. But then i get the error above.
Ahh I see.
I remember someone having the same issue recently and they were told to run the following query on the v7 database
They were then able to find the offending documents that had more than one version claiming to be published and take care of them as necessary.
Hope that helps!
Thanks Rob! That helped, i'll mark your hint as solution. Nevertheless, i now get the next error:
I really don't see any obsolete property editors on my data types. Do you have a hint on this one as well? 😉
Glad that helped,
As for the next issue you might want to check this thread for more info, I think the issue is similar.
Good luck!
Hi Team, We are upgrading the Db to 7.15 to 8.5.5, while doing the db upgrade we are getting the below error, can someone help. Thanks in advance.
The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot resolve collation conflict between "PolishCIAS" and "SQLLatin1GeneralCP1CI_AS" in CASE operator occurring in SELECT statement column 35. Please check log file for additional information
is working on a reply...