The INSERT statement conflicted with the FOREIGN K...
# help-with-umbraco
d
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?