Hi there,
Running DNN 4.5.5 & installing blog 3.3.1 gives me the following error
Info Executing 03.01.20.SqlDataProvider
StartJob Start Sql execution: 03.01.20.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'GroupType'. Invalid column name 'Server'. Invalid column name 'Port'. Invalid column name 'LogonRequired'. Invalid column name 'UserName'. Invalid column name 'Password'. 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.Blog_Upgrade_ForumGroupsList @PortalID int AS SELECT [GroupID], [Name], dbo.Forum_Groups.PortalID, dbo.Forum_Groups.ModuleID, [SortOrder], [CreatedDate], [CreatedByUser], [UpdatedByUser], [UpdatedDate], [GroupType], [Server], [Port], [LogonRequired], [UserName], [Password] FROM dbo.Forum_Groups join dbo.Modules on dbo.Forum_Groups.ModuleID = dbo.Modules.ModuleID right outer join dbo.ModuleDefinitions on dbo.Modules.ModuleDefID = dbo.Moduledefinitions.ModuleDefID left outer join dbo.DesktopModules on dbo.Desktopmodules.DesktopModuleID = dbo.ModuleDefinitions.DesktopModuleID WHERE dbo.Forum_Groups.PortalID = @PortalID AND dbo.DesktopModules.ModuleName = 'DNN_Blog' System.Data.SqlClient.SqlException: Invalid column name 'GroupType'. Invalid column name 'Server'. Invalid column name 'Port'. Invalid column name 'LogonRequired'. Invalid column name 'UserName'. Invalid column name 'Password'. 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.Blog_Upgrade_ForumGroupsByGroup @GroupID int AS SELECT [GroupID], [Name], [PortalID], [ModuleID], [SortOrder], [CreatedDate], [CreatedByUser], [UpdatedByUser], [UpdatedDate], [GroupType], [Server], [Port], [LogonRequired], [UserName], [Password] FROM Forum_Groups WHERE GroupID = @GroupID System.Data.SqlClient.SqlException: Invalid column name 'DaysToView'. Invalid column name 'EnableAutoDelete'. Invalid column name 'AutoDeleteThreshold'. Invalid column name 'IntegratedObjects'. Invalid column name 'IsPrivate'. 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.Blog_Upgrade_ForumForumsList @GroupID int AS SELECT [ForumID], [GroupID], [IsActive], [ParentID], [Name], [Description], [CreatedDate], [CreatedByUser], [UpdatedByUser], [UpdatedDate], [IsModerated], [DaysToView], [SortOrder], [TotalPosts], [TotalThreads], [EnablePostStatistics], [EnableAutoDelete], [AutoDeleteThreshold], [MostRecentPostID], [MostRecentThreadID], [MostRecentPostAuthorID], [MostRecentPostDate], [PostsToModerate], [ForumType], [IsIntegrated], [IntegratedModuleID], [IntegratedObjects], [IsPrivate], [AuthorizedRoles], [AuthorizedEditRoles] FROM Forum_Forums WHERE GroupID = @GroupID System.Data.SqlClient.SqlException: Invalid column name 'Image'. Invalid column name 'ObjectTypeCode'. 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.Blog_Upgrade_ForumThreadsList @ForumID int AS SELECT [ThreadID], [ForumID], [Views], [LastPostedPostID], [Replies], [IsPinned], [PinnedDate], [Image], [ObjectTypeCode], [ObjectID] FROM Forum_Threads WHERE ForumID = @ForumID System.Data.SqlClient.SqlException: Invalid column name 'CreatedByUser'. Invalid column name 'MediaURL'. Invalid column name 'MediaNAV'. 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.Blog_Upgrade_ForumPostsList @ThreadID int AS SELECT [PostID], [ParentPostID], [UserID], [RemoteAddr], [Notify], [Subject], [Body], [CreatedByUser], [CreatedDate], [ThreadID], [PostLevel], [TreeSortOrder], [FlatSortOrder], [UpdatedDate], [UpdatedByUser], [IsApproved], [IsLocked], [IsClosed], [MediaURL], [MediaNAV], [Attachments] FROM Forum_Posts WHERE ThreadID = @ThreadID
EndJob End Sql execution: 03.01.20.SqlDataProvider file
Info Executing 03.01.21.SqlDataProvider
StartJob Start Sql execution: 03.01.21.SqlDataProvider file
EndJob End Sql execution: 03.01.21.SqlDataProvider file
Any ideas re what I should do with this /
Thanks,
Andy