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
    15 days ago
    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
    14 days ago
    tayciller
    0

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

  • Marc Love (uSkinned.net) 427 posts 1664 karma points
    4 days ago
    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

Please Sign in or register to post replies

Write your reply to:

Draft