Oct 06, 2015
Jun 27, 2018
CMS Core
Closed, Fixed and tested
It is possible to get duplicate rows in tblContentType: "There is already a content type registered for type <Model>".
This errors seems to be happening more often in Azure.
Workaround To avoid duplicates GUIDs appearing run the follwing TSQL using SQL Server Management Studio, it will create a unique index on the GUID column in the content type table. The upgrade scripts will detect if this specific index is already added so it will not interfer when upgrading to a version that already have this specific fix.
CREATE UNIQUE NONCLUSTERED INDEX [IDX_tblContentType_ContentTypeGUID] ON [dbo].[tblContentType]([ContentTypeGUID] ASC);