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/Error installing on 7.2.2
PreviousNext
New Post
4/23/2014 10:14 PM
 

Baldwin,

I'm creating a new site (on 7.2.2) for a client demo, I downloaded the 6.2 package.  When I attempt to install, this is what I get:

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UserID'. Invalid column name 'EntryName'. Invalid column name 'DisplayCopyright'. Invalid column name 'Copyright'. Invalid column name 'AddedDate'. Invalid column name 'LastModifiedDate'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:62f7602f-f8bf-41b7-b82d-2dd4d02855da CREATE VIEW dbo.[vw_SunBlog_Entries] AS SELECT [BlogID], [EntryID], [UserID], [Title], [EntryName], [Description], [Entry], [Published], [DisplayCopyright], [Copyright], [PermaLink], [IsPinned], [DisplayHomePage], [FullShowTextInEntryList], [DisplaySyndication], [FullTextInRss], [ViewCount], [AllowComments], [AddedDate], [LastModifiedDate], dbo.[GetTags]( [EntryID] ) as TagsList FROM dbo.SunBlog_Entries System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UserID'. Invalid column name 'AddedDate'. Invalid column name 'DisplayCopyright'. Invalid column name 'Copyright'. Invalid column name 'LastModifiedDate'. Invalid column name 'EntryName'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:59805809-0bc4-4ed3-91c4-f2f45b299566 CREATE PROCEDURE dbo.SunBlog_AddEntry @BlogID int, @UserID int, @Title nvarchar(255), @Description ntext, @Entry ntext, @Published bit, @AllowComments bit, @DisplayCopyright bit, @Copyright nvarchar(256), @PermaLink nvarchar(1024), @IsPinned bit, @DisplayHomePage bit, @FullShowTextInEntryList bit, @DisplaySyndication bit, @FullTextInRss bit, @CategoryIDList varchar(50), @TagsList nvarchar(500), @EntryName nvarchar(255) AS DECLARE @EntryID int INSERT INTO dbo.SunBlog_Entries ( [BlogID], [UserID], [Title], [Description], [Entry], [AddedDate], [Published], [AllowComments], [DisplayCopyright], [Copyright], [PermaLink], [IsPinned], [DisplayHomePage], [FullShowTextInEntryList], [DisplaySyndication], [FullTextInRss], [LastModifiedDate], [EntryName] ) VALUES ( @BlogID, @UserID, @Title, @Description, @Entry, GetUTCDate(), @Published, @AllowComments, @DisplayCopyright, @Copyright, null, @IsPinned, @DisplayHomePage, @FullShowTextInEntryList, @DisplaySyndication, @FullTextInRss, GetUTCDate(), @EntryName ) SET @EntryID = SCOPE_IDENTITY() /* Update the Category and Tags Table related to */ EXECUTE dbo.SunBlog_AddCategoriesByEntryID @CategoryIDList,@EntryID,'|',@Published EXECUTE dbo.[SunBlog_AddTagsByEntryID] @TagsList,@EntryID,'|' /* Update the PermaLink Filed */ If NOT @PermaLink IS NULL UPDATE dbo.SunBlog_Entries SET PermaLink=@PermaLink + convert(nvarchar(10),EntryID) WHERE EntryID=@EntryID AND PermaLink IS NULL SELECT @EntryID System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UserID'. Invalid column name 'DisplayCopyright'. Invalid column name 'Copyright'. Invalid column name 'LastModifiedDate'. Invalid column name 'EntryName'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:524b4044-0abe-4db1-bd4f-62667c73e3bd CREATE PROCEDURE dbo.SunBlog_UpdateEntry @UserID int, @EntryID int, @Title nvarchar(255), @Description ntext, @Entry ntext, @Published bit, @AllowComments bit, @DisplayCopyright bit, @Copyright nvarchar(256), @PermaLink nvarchar(1024), @IsPinned bit, @DisplayHomePage bit, @FullShowTextInEntryList bit, @DisplaySyndication bit, @FullTextInRss bit, @CategoryIDList varchar(50), @TagsList nvarchar(500), @EntryName nvarchar(255) AS UPDATE dbo.SunBlog_Entries SET [UserID] = @UserID, [Title] = @Title, [Description] = @Description, [Entry] = @Entry, [Published] = @Published, [AllowComments] = @AllowComments, [DisplayCopyright] = @DisplayCopyright, [Copyright] = @Copyright, [PermaLink] = @PermaLink, [IsPinned] = @IsPinned, [DisplayHomePage] = @DisplayHomePage, [FullShowTextInEntryList] = @FullShowTextInEntryList, [DisplaySyndication] = @DisplaySyndication, [FullTextInRss] = @FullTextInRss, [LastModifiedDate] = GetUTCDate(), [EntryName] = @EntryName WHERE [EntryID] = @EntryID /* Update the Category and Tags Table related to */ EXECUTE dbo.SunBlog_AddCategoriesByEntryID @CategoryIDList,@EntryID,'|',@Published EXECUTE dbo.[SunBlog_AddTagsByEntryID] @TagsList,@EntryID,'|' System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UserID'. Invalid column name 'AddedDate'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:7ba8e379-c698-497e-8cd8-30d3dbf00e47 CREATE VIEW dbo.[vw_SunBlog_Comments] AS SELECT [CommentID], [EntryID], [UserID], [Author], [Title], [Email], [Website], [Comment], [AddedDate], [Approved] FROM dbo.SunBlog_Comments System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'UserID'. Invalid column name 'AddedDate'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script) ClientConnectionId:8379e1e0-2d28-40c5-8135-418ce867a216 CREATE PROCEDURE dbo.SunBlog_AddComment @EntryID int, @UserID int, @Author nvarchar(50), @Title nvarchar(255), @Email nvarchar(100), @Website [nvarchar] (255), @Comment ntext, @Approved bit AS INSERT INTO dbo.SunBlog_Comments ( [EntryID], [UserID], [Author], [Title], [Email], [Website], [Comment], [Approved], [AddedDate] ) VALUES ( @EntryID, @UserID, @Author, @Title, @Email, @Website, @Comment, @Approved, GetUTCDate() ) SELECT SCOPE_IDENTITY()
Info End Sql execution: 02.01.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
4/23/2014 10:49 PM
 

It looks weird but just install it again successfully. Thanks.


Ultimate DNN Blog Module - SunBlogNuke
New Post
4/23/2014 11:19 PM
 

Thanks for the quick assist!

PreviousNext
Home/Ultimate DNN Blog Module :: SunBlogNuke/Support Issues/Error installing on 7.2.2
Copyright © 2009-2018 Ultimate DNN Blog Module - SunBlogNuke Powered by SunBlogNuke Corp