search

dnnwerk / dnnScript

Improve Stability & Performance of DNN (AKA DotNetNuke) CMS Platform
Other
20 stars 0 forks source link

Error applying TurboDNN 0.9.9 Rev z4 #5

Closed roman-yagodin closed 6 years ago

roman-yagodin commented 6 years ago 
Message 1505, level 16, state 1, line 2
The CREATE UNIQUE INDEX statement was aborted because a duplicate key was found
for the object named "dbo.Roles" and an index named "IX_Roles_RoleGroup"
Duplicate key value: (<NULL>, Administrators).
The execution of this instruction has been interrupted.
sleupold commented 6 years ago

Yes, you are correct, it should be CREATE UNIQUE NONCLUSTERED INDEX [IX_{objectQualifier}Roles_RoleGroup] ON {databaseOwner}[{objectQualifier}Roles] (RoleGroupID, PortalID, RoleName) INCLUDE (RoleId) GO I'll fix it in the next version.

sleupold commented 6 years ago

fixed in Rev z5

roman-yagodin commented 6 years ago

0.9.9 Rev z5 applied without any issues, thanks!

sleupold commented 6 years ago

thanks for your feedback!