I am using Dnn 6.2.?? (I know...I should upgrade to 7.??, it will be eventually). I am trying to upgrade the blog module from 4.1 to 5.0 and received this error while upgrading:
Info Starting Installation - DotNetNuke.Blog
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - 05.00.00.SqlDataProvider
Info Created - 05.00.00.SqlDataProvider
Info Executing 05.00.00.SqlDataProvider
Info Start Sql execution: 05.00.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Website'. Invalid column name 'Email'. at System.Data.SqlClient.SqlConnection. (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 SPROCs */ SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.Blog_AddComment') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.Blog_AddComment @EntryID int, @UserID int, @Title nvarchar(255), @Comment ntext, @Author nvarchar(50), @Approved bit, @Website nvarchar(255), @Email nvarchar(255), @AddedDate datetime AS INSERT INTO dbo.Blog_Comments ( [EntryID], [UserID], [Title], [Comment], [Author], [Approved], [AddedDate], [Website], [Email] ) VALUES ( @EntryID, @UserID, @Title, @Comment, @Author, @Approved, COALESCE(@AddedDate, GetUTCDate()), @Website, @Email ) select SCOPE_IDENTITY()' END System.Data.SqlClient.SqlException: Invalid column name 'Website'. Invalid column name 'Email'. at System.Data.SqlClient.SqlConnection. (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) SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.Blog_GetComment') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.Blog_GetComment @CommentID int AS SELECT C.[CommentID], C.[EntryID], C.[UserID], C.[Title], C.[Comment], C.[AddedDate], U.[UserName], U.[DisplayName] AS UserFullName, C.[Author], C.[Approved], C.[Website], C.[Email] FROM dbo.Blog_Comments C LEFT JOIN dbo.Users U ON C.[UserID] = U.[UserID] WHERE C.[CommentID] = @CommentID' END System.Data.SqlClient.SqlException: Invalid column name 'Website'. Invalid column name 'Email'. at System.Data.SqlClient.SqlConnection. (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) SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.Blog_GetCommentsByEntry') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N' CREATE PROCEDURE dbo.Blog_GetCommentsByEntry @EntryID INT, @ShowNonApproved BIT AS SELECT C.[CommentID], C.[EntryID], C.[UserID], C.[Title], C.[Comment], C.[AddedDate], U.[UserName], U.[DisplayName] AS UserFullName, C.[Author], C.[Approved], C.[Website], C.[Email] FROM dbo.Blog_Comments C LEFT JOIN dbo.Users U ON C.[UserID] = U.[UserID] WHERE [EntryID] = @EntryID AND (C.[Approved]=1 OR C.[Approved] <> @ShowNonApproved) ORDER By C.[CommentID] ' END System.Data.SqlClient.SqlException: Invalid column name 'Website'. Invalid column name 'Email'. at System.Data.SqlClient.SqlConnection. (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) SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.Blog_GetCommentsByBlog') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.Blog_GetCommentsByBlog @BlogId INT, @ShowNonApproved BIT = 0, @MaxComments int = 10 AS SET rowcount @MaxComments SELECT C.[CommentID], C.[EntryID], C.[UserID], C.[Title], C.[Comment], C.[AddedDate], U.[UserName], U.[DisplayName] AS UserFullName, C.[Author], C.[Approved], C.[Website], C.[Email] FROM dbo.Blog_Comments C LEFT OUTER JOIN dbo.Users U ON C.[UserID] = U.[UserID] INNER JOIN dbo.Blog_Entries E ON C.EntryID = E.EntryID WHERE (C.[Approved] = 1 OR C.[Approved] <> @ShowNonApproved) AND E.BlogID = @BlogId ORDER BY C.AddedDate desc' END System.Data.SqlClient.SqlException: Invalid column name 'Website'. Invalid column name 'Email'. at System.Data.SqlClient.SqlConnection. (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) SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.Blog_GetCommentsByPortal') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.Blog_GetCommentsByPortal @PortalId INT, @ShowNonApproved BIT = 0, @MaxComments int = 10 AS SET rowcount @MaxComments SELECT C.[CommentID], C.[EntryID], C.[UserID], C.[Title], C.[Comment], C.[AddedDate], U.[UserName], U.[DisplayName] AS UserFullName, C.[Author], C.[Approved], C.[Website], C.[Email] FROM dbo.Blog_Comments C LEFT OUTER JOIN dbo.Users U ON C.[UserID] = U.[UserID] INNER JOIN dbo.Blog_Entries E ON C.EntryID = E.EntryID INNER JOIN dbo.Blog_Blogs B ON E.BlogID = B.BlogID WHERE (C.[Approved] = 1 OR C.[Approved] <> @ShowNonApproved) AND B.PortalID = @PortalId ORDER BY C.AddedDate desc' END System.Data.SqlClient.SqlException: Invalid column name 'Website'. Invalid column name 'Email'. at System.Data.SqlClient.SqlConnection. (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) SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'dbo.Blog_UpdateComment') AND type in (N'P', N'PC')) BEGIN EXEC dbo.sp_executesql @statement = N'CREATE PROCEDURE dbo.Blog_UpdateComment @CommentID int, @EntryID int, @UserID int, @Title nvarchar(255), @Comment ntext, @Author nvarchar(50), @Approved bit, @Website nvarchar(255), @Email nvarchar(255), @AddedDate datetime AS UPDATE dbo.Blog_Comments SET [EntryID] = @EntryID, [UserID] = @UserID, [Title] = @Title, [Comment] = @Comment, [Author] = @Author, [Approved] = @Approved, [AddedDate] = COALESCE(@AddedDate, GetUTCDate()), [Website] = @Website, [Email] = @Email WHERE [CommentID] = @CommentID' END
Info End Sql execution: 05.00.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DotNetNuke.Blog
Info Deleted temporary install folder
Any ideas to get Blog 5.0 to install correctly?
Thanks!