We upgraded from 4.9.5 to 5.1.2 The following is a summary of the failures from LOG 5.0.0
/* Add EditorControlSrc Column to PackageTypes */
Column name 'EditorControlSrc' in table 'dbo.PackageTypes' is specified more than once.
/* Add PackageID Column to DesktopModules */
Column name 'PackageID' in table 'dbo.DesktopModules' is specified more than once.
/* Add New DesktopModule Permission */
Violation of UNIQUE KEY constraint 'IX_Permission'. Cannot insert duplicate key in object 'dbo.Permission'.
/* Move User Accounts Module Definition to the Security DesktopModule */
Violation of UNIQUE KEY constraint 'IX_Permission'. Cannot insert duplicate key in object 'dbo.Permission'.
/* Update Packages */
There is already an object named 'DF_Packages_IsSystemPackage' in the database.
/* Move Default Host Skins to HostSettings */
Invalid column name 'PortalID'.
Invalid column name 'SkinRoot'.
Invalid column name 'SkinType'.
/* Move Default Portal Skins to PortalSettings */
Invalid column name 'PortalID'.
Invalid column name 'SkinRoot'.
Invalid column name 'SkinType'.
Invalid column name 'PortalID'.
/* Add WebSlice Properties to TabModules */
Column names in each table must be unique. Column name 'IsWebSlice' in table 'dbo.TabModules' is specified more than once.
/* Fix OobjectQualifier for PK_EventLogMaster */
'PK_EventLogMaster' is not a constraint. Could not drop constraint.
/* Fix OobjectQualifier for PK_EventLogTypes */
FK_EventLog_EventLogTypes' is not a constraint
What a mess!! Looks like the upgrade fails a "Move Default Portal Skins to PortalSettings "