U4-11581 - In rare cases the umbracoLanguage table has a constraint instead of an index, making the migration fail

Created by Sebastiaan Janssen 16 Aug 2018, 10:03:26 Updated by Sebastiaan Janssen 17 Aug 2018, 06:18:24

See: https://our.umbraco.com/forum/using-umbraco-and-getting-started/93282-upgrade-from-711-to-712-fails

To reproduce, in SQL server drop the IX_umbracoLanguage_languageISOCode index from a 7.12.0 site and create the constraint:

ALTER TABLE [dbo].[umbracoLanguage] ADD CONSTRAINT [IX_umbracoLanguage_languageISOCode] UNIQUE NONCLUSTERED ( [languageISOCode] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

Comments

Sebastiaan Janssen 17 Aug 2018, 06:18:21

Fixed with PR: https://github.com/umbraco/Umbraco-CMS/pull/2857


Priority: Normal

Type: Bug

State: Fixed

Assignee:

Difficulty: Normal

Category:

Backwards Compatible: True

Fix Submitted:

Affected versions: 7.12.0

Due in version: 7.12.1

Sprint:

Story Points:

Cycle: