We have moved to GitHub Issues
Created by DOOR3 14 Oct 2015, 18:20:39 Updated by Sebastiaan Janssen 14 Oct 2015, 21:38:39
Attempting to upgrade from 7.2.5 to 7.3. Get the error message:
The database failed to upgrade. ERROR: The database configuration failed with the following message: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.umbracoNode' and the index name 'IX_umbracoNode_uniqueID'. The duplicate key value is (ddf63cd9-aa97-4e8f-a1e9-376de7b09d3d). The statement has been terminated.
In umbracoNode table I found 4 images (rows) that have 2 duplicate instances (duplicate rows). The unique keys were the same but the IDs were not.
When attempting to delete the duplicates from the table I receive an error message saying that rows in cmsPropertyData were referring to them.
MSSQL2014 DB backup can be downloaded at https://drive.google.com/a/door3.com/file/d/0B3W-jMEW3g_FRnFObWZySDdpcWc/view?usp=sharing
Backwards Compatible: True
Due in version: