Hi Umbraco. I'm trying to do a upgrade from 10.0.0 to 10.6.1 (
https://our.umbraco.com/download/releases/compare?from=10.0.0&to=10.6.1)
When I experienced this error:
The database configuration failed with the following message:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoContentVersionCleanupPolicy_cmsContentType_nodeId".
The conflict occurred in database "Prod", table "dbo.cmsContentType", column 'nodeId'.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_umbracoContentVersionCleanupPolicy_cmsContentType_nodeId".
I rolled back to version 10.0.0 and then copied the database to local for doing the upgrade there.
It seem to be related to the table umbracoContentVersionCleanupPolicy
I got the same error on my localhost, so I just tried to remove the content in umbracoContentVersionCleanupPolicy with the SQL statement: "truncate table umbracoContentVersionCleanupPolicy"
After that, the upgrade went through, and everything seems fine (on localhost). However I just wanted to check if you folks. Do you think that is a valid option or do you see any problems with deleting the data in umbracoContentVersionCleanupPolicy?