Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogError while upgrading to Blog 5.0Error while upgrading to Blog 5.0
Previous
 
Next
New Post
12/4/2013 11:22 AM
 

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!

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsBlogBlogError while upgrading to Blog 5.0Error while upgrading to Blog 5.0


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out