A lot of duplicate values reported during upgrade. However these duplicate values does not exist in dbase (MSSQL).
Here is the log:
System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'EditorControlSrc' in table 'dbo.PackageTypes' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Add EditorControlSrc Column to PackageTypes */
/***********************************************/
ALTER TABLE dbo.PackageTypes
ADD EditorControlSrc nvarchar(250) NULL
System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'PackageID' in table 'dbo.DesktopModules' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Add PackageID Column to DesktopModules */
/******************************************/
ALTER TABLE dbo.DesktopModules
ADD PackageID int NOT NULL CONSTRAINT [DF_DesktopModules_PackageID] DEFAULT ((-1))
System.Data.SqlClient.SqlException: There is already an object named 'GetDesktopModulePermissions' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[GetDesktopModulePermissions]
AS
SELECT *
FROM dbo.vw_DesktopModulePermissions
System.Data.SqlClient.SqlException: There is already an object named 'GetDesktopModulePermissionsByPortalDesktopModuleID' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[GetDesktopModulePermissionsByPortalDesktopModuleID]
@PortalDesktopModuleID int
AS
SELECT *
FROM dbo.vw_DesktopModulePermissions
WHERE PortalDesktopModuleID = @PortalDesktopModuleID
System.Data.SqlClient.SqlException: There is already an object named 'DeleteDesktopModulePermission' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[DeleteDesktopModulePermission]
@DesktopModulePermissionID int
AS
DELETE FROM dbo.DesktopModulePermission
WHERE DesktopModulePermissionID = @DesktopModulePermissionID
System.Data.SqlClient.SqlException: There is already an object named 'DeleteDesktopModulePermissionsByPortalDesktopModuleID' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[DeleteDesktopModulePermissionsByPortalDesktopModuleID]
@PortalDesktopModuleID int
AS
DELETE FROM dbo.DesktopModulePermission
WHERE PortalDesktopModuleID = @PortalDesktopModuleID
System.Data.SqlClient.SqlException: There is already an object named 'DeleteDesktopModulePermissionsByUserID' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[DeleteDesktopModulePermissionsByUserID]
@UserID int
AS
DELETE FROM dbo.DesktopModulePermission
WHERE UserID = @UserID
System.Data.SqlClient.SqlException: There is already an object named 'AddDesktopModulePermission' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[AddDesktopModulePermission]
@PortalDesktopModuleID int,
@PermissionID int,
@RoleID int,
@AllowAccess bit,
@UserID int
AS
INSERT INTO dbo.DesktopModulePermission (
[PortalDesktopModuleID],
[PermissionID],
[RoleID],
[AllowAccess],
[UserID]
) VALUES (
@PortalDesktopModuleID,
@PermissionID,
@RoleID,
@AllowAccess,
@UserID
)
select SCOPE_IDENTITY()
System.Data.SqlClient.SqlException: There is already an object named 'UpdateDesktopModulePermission' in the database.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
CREATE PROCEDURE dbo.[UpdateDesktopModulePermission]
@DesktopModulePermissionID int,
@PortalDesktopModuleID int,
@PermissionID int,
@RoleID int ,
@AllowAccess bit,
@UserID int
AS
UPDATE dbo.DesktopModulePermission
SET
[PortalDesktopModuleID] = @PortalDesktopModuleID,
[PermissionID] = @PermissionID,
[RoleID] = @RoleID,
[AllowAccess] = @AllowAccess,
[UserID] = @UserID
WHERE [DesktopModulePermissionID] = @DesktopModulePermissionID
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_Permission'. Cannot insert duplicate key in object 'dbo.Permission'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Add New DesktopModule Permission */
/************************************/
INSERT INTO dbo.Permission (
[PermissionCode],
[ModuleDefID],
[PermissionKey],
[PermissionName]
) VALUES (
'SYSTEM_DESKTOPMODULE',
-1,
'DEPLOY',
'Can Deploy'
)
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_ModuleControls'. Cannot insert duplicate key in object 'dbo.ModuleControls'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Move User Accounts Module Definition to the Security DesktopModule */
/*********************************************************************/
DECLARE @DesktopModuleID int
SET @DesktopModuleID = (SELECT DesktopModuleID FROM dbo.DesktopModules WHERE ModuleName = 'Security')
DECLARE @ModuleDefID int
SET @ModuleDefID = (SELECT ModuleDefID FROM dbo.ModuleDefinitions WHERE FriendlyName = 'User Accounts')
UPDATE dbo.ModuleDefinitions
SET DesktopModuleID = @DesktopModuleID
WHERE ModuleDefID = @ModuleDefID
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/Security/Users.ascx',
IconFile = '~/images/icon_users_32px.gif'
WHERE ControlSrc = 'Admin/Users/Users.ascx'
AND ModuleDefID = @ModuleDefID
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/Security/ManageUsers.ascx',
IconFile = '~/images/icon_users_32px.gif'
WHERE ControlSrc = 'Admin/Users/ManageUsers.ascx'
AND ModuleDefID = @ModuleDefID
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/Security/ProfileDefinitions.ascx',
IconFile = '~/images/icon_users_32px.gif'
WHERE ControlSrc = 'Admin/Users/ProfileDefinitions.ascx'
AND ModuleDefID = @ModuleDefID
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/Security/EditProfileDefinition.ascx',
IconFile = '~/images/icon_users_32px.gif'
WHERE ControlSrc = 'Admin/Users/EditProfileDefinition.ascx'
AND ModuleDefID = @ModuleDefID
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/Security/UserSettings.ascx'
WHERE ControlSrc = 'Admin/Users/UserSettings.ascx'
AND ModuleDefID = @ModuleDefID
INSERT INTO dbo.ModuleControls(
ModuleDefID,
ControlKey,
ControlTitle,
ControlSrc,
IconFile,
ControlType,
SupportsPartialRendering
)
VALUES (
@ModuleDefID,
'User Roles',
'User Roles',
'DesktopModules/Admin/Security/SecurityRoles.ascx',
'~/images/icon_securityroles_32px.gif',
1,
1
)
DELETE dbo.DesktopModules
WHERE ModuleName = 'User Accounts'
System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'PortalID' in table 'dbo.Packages' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/***********************************************************/
/* End Update Admin Modules to conform to Module Standards */
/***********************************************************/
/* Update Packages */
/*******************/
ALTER TABLE dbo.Packages
ADD PortalID int NULL
ALTER TABLE dbo.Packages
ALTER COLUMN Description nvarchar(2000) NULL
ALTER TABLE dbo.Packages
ALTER COLUMN License ntext NULL
ALTER TABLE dbo.Packages
ALTER COLUMN Manifest ntext NULL
ALTER TABLE dbo.Packages
ADD Owner nvarchar(100) NULL
ALTER TABLE dbo.Packages
ADD Organization nvarchar(100) NULL
ALTER TABLE dbo.Packages
ADD Url nvarchar(250) NULL
ALTER TABLE dbo.Packages
ADD Email nvarchar(100) NULL
ALTER TABLE dbo.Packages
ADD ReleaseNotes ntext NULL
ALTER TABLE dbo.Packages
ADD IsSystemPackage bit NOT NULL CONSTRAINT DF_Packages_IsSystemPackage DEFAULT 0
DROP INDEX IX_Packages ON dbo.Packages
CREATE UNIQUE NONCLUSTERED INDEX IX_Packages ON dbo.Packages ( Owner, Name, PortalID )
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'SkinRoot'.
Invalid column name 'SkinType'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Move Default Host Skins to HostSettings */
/*******************************************/
INSERT INTO dbo.HostSettings ( SettingName, SettingValue, SettingIsSecure )
SELECT 'DefaultAdminContainer', SkinSrc, 0 FROM dbo.Skins WHERE PortalID IS NULL AND SkinRoot='Containers' AND SkinType=1
INSERT INTO dbo.HostSettings ( SettingName, SettingValue, SettingIsSecure )
SELECT 'DefaultPortalContainer', SkinSrc, 0 FROM dbo.Skins WHERE PortalID IS NULL AND SkinRoot='Containers' AND SkinType=0
INSERT INTO dbo.HostSettings ( SettingName, SettingValue, SettingIsSecure )
SELECT 'DefaultAdminSkin', SkinSrc, 0 FROM dbo.Skins WHERE PortalID IS NULL AND SkinRoot='Skins' AND SkinType=1
INSERT INTO dbo.HostSettings ( SettingName, SettingValue, SettingIsSecure )
SELECT 'DefaultPortalSkin', SkinSrc, 0 FROM dbo.Skins WHERE PortalID IS NULL AND SkinRoot='Skins' AND SkinType=0
System.Data.SqlClient.SqlException: Invalid column name 'PortalID'.
Invalid column name 'SkinRoot'.
Invalid column name 'SkinType'.
Invalid column name 'PortalID'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Move Default Portal Skins to PortalSettings */
/***********************************************/
INSERT INTO dbo.PortalSettings (PortalID, SettingName, SettingValue)
SELECT
PortalID,
'DefaultAdminContainer' AS SettingName,
SkinSrc
FROM dbo.Skins
WHERE PortalID IS NOT NULL AND SkinRoot = N'Containers' AND SkinType = 1
INSERT INTO dbo.PortalSettings (PortalID, SettingName, SettingValue)
SELECT
PortalID,
'DefaultPortalContainer' AS SettingName,
SkinSrc
FROM dbo.Skins
WHERE PortalID IS NOT NULL AND SkinRoot = N'Containers' AND SkinType = 0
INSERT INTO dbo.PortalSettings (PortalID, SettingName, SettingValue)
SELECT
PortalID,
'DefaultAdminSkin' AS SettingName,
SkinSrc
FROM dbo.Skins
WHERE PortalID IS NOT NULL AND SkinRoot = N'Skins' AND SkinType = 1
INSERT INTO dbo.PortalSettings (PortalID, SettingName, SettingValue)
SELECT
PortalID,
'DefaultPortalSkin' AS SettingName,
SkinSrc
FROM dbo.Skins
WHERE PortalID IS NOT NULL AND SkinRoot = N'Skins' AND SkinType = 0
System.Data.SqlClient.SqlException: Column names in each table must be unique. Column name 'IsWebSlice' in table 'dbo.TabModules' is specified more than once.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Add WebSlice Properties to TabModules */
/*****************************************/
ALTER TABLE dbo.TabModules
ADD IsWebSlice bit NOT NULL CONSTRAINT DF_abModules_IsWebSlice DEFAULT 0
ALTER TABLE dbo.TabModules
ADD WebSliceTitle nvarchar(256) NULL
ALTER TABLE dbo.TabModules
ADD WebSliceExpiryDate datetime NULL
ALTER TABLE dbo.TabModules
ADD WebSliceTTL int NULL
System.Data.SqlClient.SqlException: 'PK_EventLogMaster' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Fix OobjectQualifier for PK_EventLogMaster */
/**********************************************/
ALTER TABLE dbo.EventLog
DROP CONSTRAINT PK_EventLogMaster
ALTER TABLE dbo.EventLog
ADD CONSTRAINT PK_EventLog PRIMARY KEY CLUSTERED ( LogGUID )
System.Data.SqlClient.SqlException: 'FK_EventLog_EventLogTypes' is not a constraint.
Could not drop constraint. See previous errors.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL)
at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions)
/* Fix OobjectQualifier for PK_EventLogTypes */
/**********************************************/
ALTER TABLE dbo.EventLog
DROP CONSTRAINT FK_EventLog_EventLogTypes
ALTER TABLE dbo.EventLogConfig
DROP CONSTRAINT FK_EventLogConfig_EventLogTypes
ALTER TABLE dbo.EventLogTypes
DROP CONSTRAINT PK_EventLogTypes
ALTER TABLE dbo.EventLogTypes
ADD CONSTRAINT PK_EventLogTypes PRIMARY KEY CLUSTERED ( LogTypeKey )
ALTER TABLE dbo.EventLogConfig
ADD CONSTRAINT FK_EventLogConfig_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.EventLogTypes ( LogTypeKey ) ON UPDATE NO ACTION ON DELETE NO ACTION
ALTER TABLE dbo.EventLog
ADD CONSTRAINT FK_EventLog_EventLogTypes1 FOREIGN KEY ( LogTypeKey ) REFERENCES dbo.EventLogTypes ( LogTypeKey ) ON UPDATE NO ACTION ON DELETE NO ACTION