Forums Community

These forums are dedicated to the discussion of our DotNetNuke products, such as Ultimate DNN Blog Module - SunBlogNuke & GalleryPlus.

For the benefit of the community and to keep information here helpful to everyone who visits, please observe the following posting guidelines:

  • If you are reporting a bug and strange issue please tell us which version of DNN and SunBlogNuke and share some event logs from "Admin/Event Viewer".
  • Site Moderators have the final word on approving/removing a thread or post or comment.
  • English language posting only, please.
Home/Ultimate DNN Blog Module :: SunBlogNuke/Support Issues/upgrade error to 6.02
PreviousNext
New Post
6/21/2014 12:36 AM
 

Good day. I tried upgrading my site to sunblog 6.02 and got the error below. Could you instruct me how to fix this problem? Thanks

 

StartJob Starting Installation
Info Starting Installation - SunBlog
Info Starting Installation - Script
Info Begin Sql execution
Info Created - Installation\Scripts\06.02.00.SqlDataProvider
Info Executing 06.02.00.SqlDataProvider
Info Start Sql execution: 06.02.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'PublishedOnDate'. 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.SunBlog_Categories_ListByBlog @BlogID int AS SELECT C.*, (SELECT COUNT(*) FROM dbo.SunBlog_CategoryEntry CE INNER JOIN dbo.SunBlog_Entries E ON E.EntryID = CE.EntryID WHERE CE.[CategoryID] = C.[CategoryID] AND E.[Published] = 1 AND E.[Approved] = 1 AND E.[PublishedOnDate] <= GETUTCDATE() ) As PostCount FROM dbo.[SunBlog_Categories] C LEFT JOIN dbo.SunBlog_Blogs B ON B.[BlogID] = C.[BlogID] WHERE B.[BlogID] = @BlogID ORDER BY C.[ViewOrder], C.Title ASC System.Data.SqlClient.SqlException: Invalid column name 'CreatedByUserID'. Invalid column name 'CreatedOnDate'. Invalid column name 'LastModifiedByUserID'. Invalid column name 'LastModifiedOnDate'. Invalid column name 'PublishedOnDate'. 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.SunBlog_Post_Add @BlogID int, @UserID int, @Title nvarchar(255), @Thumbnail nvarchar(1024), @Description ntext, @Content ntext, @PublishedOnDate datetime, @Published bit, @AllowComments bit, @PermaLink nvarchar(1024), @IsPinned bit, @DisplayHomePage bit, @FullShowTextInEntryList bit, @DisplaySyndication bit, @FullTextInRss bit, @CategoryIDs varchar(500), @Tags nvarchar(500), @Slug nvarchar(255), @MetaKeywords nvarchar(500), @MetaDescription nvarchar(500), @Featured bit, @Approved bit AS DECLARE @EntryID int INSERT INTO dbo.SunBlog_Entries ( [BlogID], [Title], [Thumbnail], [Description], [Entry], [Published], [AllowComments], [PermaLink], [IsPinned], [DisplayHomePage], [FullShowTextInEntryList], [DisplaySyndication], [FullTextInRss], [Slug], [MetaKeywords], [MetaDescription], [Featured], [Approved], [CreatedByUserID], [CreatedOnDate], [LastModifiedByUserID], [LastModifiedOnDate], [PublishedOnDate] ) VALUES ( @BlogID, @Title, @Thumbnail, @Description, @Content, @Published, @AllowComments, null, @IsPinned, @DisplayHomePage, @FullShowTextInEntryList, @DisplaySyndication, @FullTextInRss, @Slug, @MetaKeywords, @MetaDescription, @Featured, @Approved, @UserID, GetUTCDate(), @UserID, GetUTCDate(), @PublishedOnDate ) SET @EntryID = SCOPE_IDENTITY() /* Update Category and Tags table related to */ EXECUTE dbo.[SunBlog_Post_AddCategories] @EntryID, @CategoryIDs, '|' EXECUTE dbo.[SunBlog_Post_AddTags] @EntryID, @Tags, ',' IF NOT EXISTS(SELECT TOP 1 * FROM dbo.SunBlog_BlogUsers WHERE [UserID]=@UserID AND [BlogID]=@BlogID) BEGIN DECLARE @RoleID int SELECT @RoleID = U.[RoleID] FROM SunBlog_BlogRoles U LEFT JOIN UserRoles UR ON U.DNNRoleID = UR.RoleID WHERE UR.[UserID] = @UserID AND U.[BlogID]=@BlogID IF NOT @RoleID IS NULL EXECUTE dbo.[SunBlog_AddBlogUser] @BlogID,@UserID,@RoleID END SELECT @EntryID System.Data.SqlClient.SqlException: Invalid column name 'CreatedByUserID'. Invalid column name 'LastModifiedOnDate'. Invalid column name 'LastModifiedByUserID'. Invalid column name 'PublishedOnDate'. 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.SunBlog_Post_Update @EntryID int, @BlogID int, @UserID int, @LastModifiedBy int, @Title nvarchar(255), @Thumbnail nvarchar(1024), @Description ntext, @Content ntext, @PublishedOnDate datetime, @Published bit, @AllowComments bit, @PermaLink nvarchar(1024), @IsPinned bit, @DisplayHomePage bit, @FullShowTextInEntryList bit, @DisplaySyndication bit, @FullTextInRss bit, @Slug nvarchar(255), @MetaKeywords nvarchar(500), @MetaDescription nvarchar(500), @Featured bit, @Approved bit, @Raters int, @Rating real, @ViewCount int, @Tags nvarchar(500), @CategoryIDs varchar(500) AS UPDATE dbo.SunBlog_Entries SET [BlogID] = @BlogID, [Title] = @Title, [Thumbnail] = @Thumbnail, [Description] = @Description, [Entry] = @Content, [Published] = @Published, [AllowComments] = @AllowComments, [PermaLink] = @PermaLink, [IsPinned] = @IsPinned, [DisplayHomePage] = @DisplayHomePage, [FullShowTextInEntryList] = @FullShowTextInEntryList, [DisplaySyndication] = @DisplaySyndication, [FullTextInRss] = @FullTextInRss, [Slug] = @Slug, [MetaKeywords] = @MetaKeywords, [MetaDescription] = @MetaDescription, [Featured] = @Featured, [Approved] = @Approved, [Raters] = @Raters, [Rating] = @Rating, [ViewCount] = @ViewCount, [CreatedByUserID] = @UserID, [LastModifiedOnDate] = GetUTCDate(), [LastModifiedByUserID] = @LastModifiedBy, [PublishedOnDate] = @PublishedOnDate WHERE [EntryID] = @EntryID IF @Tags <> '' BEGIN /* Update the [Tags] table related to */ EXECUTE dbo.[SunBlog_Post_AddTags] @EntryID, @Tags, ',' END IF @CategoryIDs <> '' BEGIN /* Update the [Category] table related to */ EXECUTE dbo.[SunBlog_Post_AddCategories] @EntryID, @CategoryIDs, '|' END --DECLARE @BlogID int --SELECT @BlogID = [BlogID] FROM SunBlog_Entries WHERE [EntryID] = @EntryID IF NOT EXISTS(SELECT TOP 1 * FROM dbo.SunBlog_BlogUsers WHERE [UserID]=@UserID AND [BlogID]=@BlogID) BEGIN DECLARE @RoleID int SELECT @RoleID = U.[RoleID] FROM SunBlog_BlogRoles U LEFT JOIN UserRoles UR ON U.DNNRoleID = UR.RoleID WHERE UR.[UserID] = @UserID AND U.[BlogID]=@BlogID IF NOT @RoleID IS NULL EXECUTE dbo.[SunBlog_AddBlogUser] @BlogID,@UserID,@RoleID END
Info End Sql execution: 06.02.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - SunBlog
Info Starting Installation - SunBlog - Widget Wrapper
Info Starting Installation - Module
Info Module registered successfully - SunBlog - Widget Wrapper
Info Component installed successfully - Module
Failure Package Installation aborted
Info Installation Failed - SunBlog - Widget Wrapper
Info Deleted temporary install folder
EndJob Installation Failed
 
New Post
6/21/2014 1:21 AM
 

Which version of your original module? And please try the following script in the Host/SQL page:

/* Rename PublishedOn as PublishedOnDate in Entries table */
IF (SELECT COLUMNPROPERTY(OBJECT_ID('{databaseOwner}{objectQualifier}SunBlog_Entries'),'PublishedOn','AllowsNull')) IS NOT NULL 
EXEC SP_RENAME  @objname = '{objectQualifier}SunBlog_Entries.PublishedOn', 
        @newname = 'PublishedOnDate', 
        @objtype = 'COLUMN'
GO

Ultimate DNN Blog Module - SunBlogNuke
New Post
6/21/2014 1:37 AM
 

I am using 6.01. I tried the script and got this error:

Error: View is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Invalid column name 'PublishedOn'. Could not use view or function 'dbo.vw_SunBlog_Entries' because of binding errors. ---> System.Data.SqlClient.SqlException: Invalid column name 'PublishedOn'. Could not use view or function 'dbo.vw_SunBlog_Entries' because of binding errors. 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.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Data.SqlDataProvider.ExecuteReader(String ProcedureName, Object[] commandParameters) at SunBlogNuke.Services.DataService.ListEntriesByBlog(Int32 blogID, Nullable1 blogDate, String viewType, Boolean showNonPublished, Int32 additionalID, Int32 pageIndex, Int32 pageSize) at SunBlogNuke.Business.EntryController.ListEntriesByBlog(Int32 blogID, Nullable1 blogDate, String viewType, Boolean showNonPublished, Int32 additionalID, Int32 pageIndex, Int32 pageSize, Int32& totalRecords) at SunBlogNuke.Views.ViewBlog.RequestPosts() at SunBlogNuke.Views.ViewBlog.BindPosts() at SunBlogNuke.Views.ViewBlog.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

New Post
6/21/2014 1:38 AM
 

The above error is what is displaying on my webpage www.covenantadvent.org

PreviousNext
Home/Ultimate DNN Blog Module :: SunBlogNuke/Support Issues/upgrade error to 6.02
Copyright © 2009-2018 Ultimate DNN Blog Module - SunBlogNuke Powered by SunBlogNuke Corp