Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • AvihayBit 149 posts 303 karma points
    Jul 17, 2016 @ 08:20

    Hi, Im getting this error trying to manually upgrade from 7.2.4 to 7.4.3 :

    enter image description here

    "The database failed to upgrade. ERROR: The database configuration failed with the following message: Cannot insert duplicate key row in object 'dbo.cmsPropertyTypeGroup' with unique index 'IXcmsPropertyTypeGroupUniqueID'. The duplicate key value is (5ef49d6c-a7c9-da9d-9bee-234dce220b1a). The statement has been terminated. Please check log file for additional information (can be found in '/AppData/Logs/UmbracoTraceLog.txt')"

    Really lost here, Any idea? Someone from the Core Team maybe can take a look and find a hack to solve this?

    I know that I'm not the only one having this...

  • Yakov Lebski 572 posts 2199 karma points
    Aug 08, 2016 @ 21:00
    Yakov Lebski

    I solve it by run this query before update

      ALTER TABLE [cmsPropertyTypeGroup] ADD [uniqueID] UniqueIdentifier NOT NULL CONSTRAINT [DF_cmsPropertyTypeGroup_uniqueID] DEFAULT (NEWID())
  • AvihayBit 149 posts 303 karma points
    Aug 10, 2016 @ 10:06

    WOW exactly what I needed!! Thanks a lot! worked like a charm...

  • Peter Gregory 408 posts 1614 karma points MVP 3x admin c-trib
    Aug 24, 2016 @ 05:11
    Peter Gregory

    Yep I hit the exact some error today when upgrading to 7.5.2 This got it sorted.

Please Sign in or register to post replies

Write your reply to: