DNN Version 4.6.2>4.8>4.85>4.9.1>5.0.1. During the upgrade from 4.9.1 to 5.0.1 the following errors were noted:
Upgrade Log for version 04.09.01:
System.Data.SqlClient.SqlException: Invalid column name 'LastActivityDate'.
Invalid column name 'LastActivityDate'.
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.UpdateServer
@ServerName nvarchar(50),
@CreatedDate datetime,
@LastActivityDate datetime
AS
DECLARE @ServerID int
SET @ServerID = (SELECT ServerID FROM dbo.Servers WHERE ServerName = @ServerName)
IF @ServerID IS NULL
BEGIN
-- Insert
INSERT INTO dbo.Servers (
ServerName,
CreatedDate,
LastActivityDate
)
VALUES (
@ServerName,
@CreatedDate,
@LastActivityDate
)
END
ELSE
BEGIN
-- Update
UPDATE dbo.Servers
SET LastActivityDate = @LastActivityDate
WHERE ServerName = @ServerName
END
Upgrade Log for version 05.00.00:
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 File Manager Module */
/******************************/
DECLARE @ModuleDefID int
SET @ModuleDefID = (SELECT ModuleDefID FROM dbo.ModuleDefinitions WHERE FriendlyName = 'File Manager')
UPDATE dbo.DesktopModules
SET ModuleName = 'FileManager',
FolderName = 'Admin/FileManager'
WHERE ModuleName = 'File Manager'
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/FileManager/FileManager.ascx',
IconFile = '~/images/icon_filemanager_32px.gif'
WHERE ControlSrc = 'Admin/Files/FileManager.ascx'
AND ModuleDefID = @ModuleDefID
UPDATE dbo.ModuleControls
SET ControlSrc = 'DesktopModules/Admin/FileManager/WebUpload.ascx',
IconFile = '~/images/icon_filemanager_32px.gif'
WHERE ControlSrc = 'Admin/Files/WebUpload.ascx'
Post upgrade the home page comes up, however, several other pages have the following error:
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 162: End If
Line 163:
Line 164: If Not ModuleControl.ModuleContext.Configuration Is Nothing Then Line 165: ' check if Personalization is allowed
Line 166: If ModuleControl.ModuleContext.Configuration.Visibility = Entities.Modules.VisibilityState.None Then
|
Source File: E:\CC\Admin\Containers\Visibility.ascx.vb Line: 164
Stack Trace:
[NullReferenceException: Object reference not set to an instance of an object.]
DotNetNuke.UI.Containers.Visibility.Page_Load(Object sender, EventArgs e) in E:\CC\Admin\Containers\Visibility.ascx.vb:164
[ModuleLoadException: An error has occurred.]
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(String FriendlyMessage, Control ctrl, Exception exc, Boolean DisplayErrorMessage) +378
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(Control ctrl, Exception exc, Boolean DisplayErrorMessage) +185
DotNetNuke.Services.Exceptions.Exceptions.ProcessModuleLoadException(Control ctrl, Exception exc) +34
DotNetNuke.UI.Containers.Visibility.Page_Load(Object sender, EventArgs e) in E:\CC\Admin\Containers\Visibility.ascx.vb:202
System.Web.UI.Control.OnLoad(EventArgs e) +99
System.Web.UI.Control.LoadRecursive() +50
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Control.LoadRecursive() +141
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +627
[PageLoadException: An error has occurred.]
DotNetNuke.Services.Exceptions.Exceptions.ProcessPageLoadException(Exception exc, String URL) +277
DotNetNuke.Framework.PageBase.OnError(EventArgs e) +330
System.Web.UI.Page.HandleError(Exception e) +84
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6776
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +242
System.Web.UI.Page.ProcessRequest() +80
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.default_aspx.ProcessRequest(HttpContext context) +37
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
|
If anyone has some clue as to how I should proceed with this, I would be grateful.
-Jeff