Hi, I have not been able to upgrade to version 5. I'm using 04.09.04.
Attempt to upgrade to any version 5 fails but for version 5.1.2, I only receive 1 error.
It points to 05.00.00.log. I've copy and paste it here. Any idea what is wrong?
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'dbo.DesktopModules'.
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)
/* Update Site Log Module */
/**************************/
DECLARE @ModuleDefID int
SET @ModuleDefID = (SELECT ModuleDefID FROM dbo.ModuleDefinitions WHERE FriendlyName = 'Site Log')
UPDATE dbo.DesktopModules
SET ModuleName = 'SiteLog',
FolderName = 'Admin/SiteLog'
WHERE ModuleName = 'Site Log'
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/SiteLog/SiteLog.ascx',
IconFile = '~/images/icon_sitelog_32px.gif'
WHERE ControlSrc = 'Admin/Log/SiteLog.ascx'
AND ModuleDefID = @ModuleDefID
System.Data.SqlClient.SqlException: Violation of UNIQUE KEY constraint 'IX_DesktopModules_ModuleName'. Cannot insert duplicate key in object 'dbo.DesktopModules'.
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)
/* Update Log Viewer Module */
/*****************************/
DECLARE @ModuleDefID int
SET @ModuleDefID = (SELECT ModuleDefID FROM dbo.ModuleDefinitions WHERE FriendlyName = 'Log Viewer')
UPDATE dbo.DesktopModules
SET ModuleName = 'LogViewer',
FolderName = 'Admin/LogViewer'
WHERE ModuleName = 'Log Viewer'
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/LogViewer/LogViewer.ascx',
ControlType = 0,
IconFile = '~/images/icon_viewstats_32px.gif'
WHERE ControlSrc = 'Admin/Logging/LogViewer.ascx'
AND ModuleDefID = @ModuleDefID
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/LogViewer/EditLogTypes.ascx',
IconFile = '~/images/icon_viewstats_32px.gif'
WHERE ControlSrc = 'Admin/Logging/EditLogTypes.ascx'
AND ModuleDefID = @ModuleDefID