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
    AvihayBit
    0

    Umbraco Upgrading Error

    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 594 posts 2350 karma points
    Aug 08, 2016 @ 21:00
    Yakov Lebski
    101

    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
    AvihayBit
    0

    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
    0

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

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies