Copied to clipboard

Flag this post as spam?

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


  • Joao Bernardo Costa 1 post 71 karma points
    Feb 08, 2024 @ 16:35
    Joao Bernardo Costa
    0

    Umbraco 12 Upgrade - An explicit DROP INDEX is not allowed on index

    Hi all,

    I'm trying to upgrade my umbraco 12.0.1 version to Umbraco 12.1.0 and I'm getting this errors when the upgrade wizard is running: enter image description here

    The database failed to upgrade. ERROR: The database configuration failed with the following message: An explicit DROP INDEX is not allowed on index 'umbracoContentVersionCultureVariation.IXumbracoContentVersionCultureVariationVersionId'. It is being used for UNIQUE KEY constraint enforcement. Please check log file for additional information (can be found in 'LoggingSettings.Directory')

    Thank you in advance

  • tayciller 1 post 71 karma points
    Feb 09, 2024 @ 10:30
    tayciller
    0

    My issue is the same. What can I clarify to get help here?

  • Marc Love (uSkinned.net) 447 posts 1789 karma points
    Feb 19, 2024 @ 14:51
    Marc Love (uSkinned.net)
    0

    Hi,

    I also came across this issue. You can drop these constraints in order for the update to run. The constraints will be added back automatically during the upgrade. Run the following commands against your database:

    ALTER TABLE umbracoContentVersionCultureVariation
    DROP CONSTRAINT IX_umbracoContentVersionCultureVariation_VersionId
    
    ALTER TABLE umbracoPropertyData
    DROP CONSTRAINT IX_umbracoPropertyData_VersionId
    

    Cheers,

    Marc

  • Julius Goddard 41 posts 152 karma points
    Mar 21, 2024 @ 09:13
    Julius Goddard
    0

    I had the exact same error, however, running this query in the SSMS database did nothing to solve it - is there a specific way in which you have to run this query?

  • Marc Love (uSkinned.net) 447 posts 1789 karma points
    Mar 21, 2024 @ 09:51
    Marc Love (uSkinned.net)
    0

    Hi Julius,

    Are you still getting the same error? Make sure the Constraints are no longer present in the database.

    Cheers,

    Marc

  • Julius Goddard 41 posts 152 karma points
    Mar 21, 2024 @ 10:02
    Julius Goddard
    0

    Hi Marc,

    I am still getting the same error message.

    Do you know how to ensure the constraints aren't present in SQL Server Management Studio? - I can't see any in this folder

    enter image description here

  • Marc Love (uSkinned.net) 447 posts 1789 karma points
    Mar 21, 2024 @ 10:04
    Marc Love (uSkinned.net)
    0

    Hi Julius,

    Look in the "Indexes" folder.

    Cheers,

    Marc

  • Julius Goddard 41 posts 152 karma points
    Mar 21, 2024 @ 10:23
    Julius Goddard
    0

    Hi Marc,

    They are still present in there - even when I right click on in it - select Script Index as - DROP to and then run this script:

    USE [Docs10]
    GO
    
    /****** Object:  Index [IX_umbracoPropertyData_VersionId]    Script Date: 21/03/2024 10:21:24 ******/
    ALTER TABLE [dbo].[umbracoPropertyData] DROP CONSTRAINT [IX_umbracoPropertyData_VersionId]
    GO
    

    I restart the application and still get the same error - do you have any other suggestions?

  • Julius Goddard 41 posts 152 karma points
    Mar 21, 2024 @ 11:26
    Julius Goddard
    0

    Right click on the index and click delete - literally all you have to do.... took ages to work that out.

    Not sure why none of the SQL code does anything though...

Please Sign in or register to post replies

Write your reply to:

Draft