I have installed latest extention of Dnn.Blog, But it is giving error "invalid column ModuleId" . is there any way to resolve it.

[Abhicis1]

Please summarize your question in one sentence

The error message is:

Failure SQL-utføring resulterte i følgende unntak: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ModuleId'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:4de9dcf4-5a3c-4a6e-80e3-f3e69e1a92f4 Error Number:207,State:1,Class:16 CREATE PROCEDURE dbo.Blog_UpdatePost @AllowComments BIT, @blogid INT, @content NVARCHAR(MAX), @ContentItemId INT, @copyright NVARCHAR (255), @DisplayCopyright BIT, @image NVARCHAR (255), @Locale VARCHAR (10), @published BIT, @PublishedOnDate DATETIME, @summary NVARCHAR (MAX), @termids NVARCHAR(1000), @title NVARCHAR (255), @viewcount INT, @UpdatedByUser INT AS DECLARE @ContentTypeID INT SET @ContentTypeID = (SELECT TOP 1 ContentTypeID FROM dbo.ContentTypes WHERE ContentType='DNN_Blog_Post') DECLARE @ModuleId INT SET @ModuleId = (SELECT TOP 1 ModuleId FROM dbo.Blog_Blogs WHERE BlogID=@blogid) EXEC dbo.UpdateContentItem @ContentItemId, @content, @ContentTypeID, -1, @ModuleId, NULL, 0, @UpdatedByUser UPDATE dbo.Blog_Posts SET [AllowComments] = @AllowComments, [BlogID] = @blogid, [Copyright] = @copyright, [DisplayCopyright] = @DisplayCopyright, [Image] = @image, [Locale] = @Locale, [Published] = @published, [PublishedOnDate] = @PublishedOnDate, [Summary] = @summary, [Title] = @title, [ViewCount]=@viewcount WHERE [ContentItemId] = @ContentItemId; DELETE FROM dbo.dnn_ContentItems_Tags WHERE ContentItemID=@ContentItemId; IF @termids<>'' BEGIN DECLARE @ids TABLE (s NVARCHAR(512)) INSERT INTO @ids (s) SELECT s FROM dbo.Blog_Split(@termids,';'); DELETE FROM dbo.ContentItems_Tags WHERE ContentItemID=@ContentItemId; INSERT INTO dbo.ContentItems_Tags ([ContentItemID], [TermID]) SELECT @ContentItemID, CAST(i.s AS INT) FROM @ids i; END

Give a more extended description

The comlete result

StartJob Start installasjonen

Info Start installasjonen - DotNetNuke.Blog

Info Start installasjonen - Module

Info Modul registrert vellykket - Blog

Info Komponenten installert - Module

Info Start installasjonen - Config

Info Å lage sikkerhetskopi av tidligere versjon - web.config

Info Config-filen som er oppdatert - web.config

Info Komponenten installert - Config

Info Start installasjonen - Script

Info Starte Sql-utføring

Info Å lage sikkerhetskopi av tidligere versjon - 06.00.07.SqlDataProvider

Info Opprettet - 06.00.07.SqlDataProvider

Info Utfører06.00.07.SqlDataProvider

Info Starte Sql-utføring: 06.00.07.SqlDataProvider fil

Failure SQL-utføring resulterte i følgende unntak: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'ModuleId'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDatabaseConnectionProvider.ExecuteNonQuery(String connectionString, CommandType commandType, Int32 commandTimeout, String query) at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec) ClientConnectionId:4de9dcf4-5a3c-4a6e-80e3-f3e69e1a92f4 Error Number:207,State:1,Class:16 CREATE PROCEDURE dbo.Blog_UpdatePost @AllowComments BIT, @blogid INT, @content NVARCHAR(MAX), @ContentItemId INT, @copyright NVARCHAR (255), @DisplayCopyright BIT, @image NVARCHAR (255), @Locale VARCHAR (10), @published BIT, @PublishedOnDate DATETIME, @summary NVARCHAR (MAX), @termids NVARCHAR(1000), @title NVARCHAR (255), @viewcount INT, @UpdatedByUser INT AS DECLARE @ContentTypeID INT SET @ContentTypeID = (SELECT TOP 1 ContentTypeID FROM dbo.ContentTypes WHERE ContentType='DNN_Blog_Post') DECLARE @ModuleId INT SET @ModuleId = (SELECT TOP 1 ModuleId FROM dbo.Blog_Blogs WHERE BlogID=@blogid) EXEC dbo.UpdateContentItem @ContentItemId, @content, @ContentTypeID, -1, @ModuleId, NULL, 0, @UpdatedByUser UPDATE dbo.Blog_Posts SET [AllowComments] = @AllowComments, [BlogID] = @blogid, [Copyright] = @copyright, [DisplayCopyright] = @DisplayCopyright, [Image] = @image, [Locale] = @Locale, [Published] = @published, [PublishedOnDate] = @PublishedOnDate, [Summary] = @summary, [Title] = @title, [ViewCount]=@viewcount WHERE [ContentItemId] = @ContentItemId; DELETE FROM dbo.dnn_ContentItems_Tags WHERE ContentItemID=@ContentItemId; IF @termids<>'' BEGIN DECLARE @ids TABLE (s NVARCHAR(512)) INSERT INTO @ids (s) SELECT s FROM dbo.Blog_Split(@termids,';'); DELETE FROM dbo.ContentItems_Tags WHERE ContentItemID=@ContentItemId; INSERT INTO dbo.ContentItems_Tags ([ContentItemID], [TermID]) SELECT @ContentItemID, CAST(i.s AS INT) FROM @ids i; END

Info Avslutte Sql-utføring: 06.00.07.SqlDataProvider fil

Info Ferdig Sql-utføring

Failure Installasjonen mislyktes - Script

Info Rulle tilbake komponent installere - Module

Info Komponenten rullet tilbake med hell - Module

Info Rulle tilbake komponent installere - Config

Info Config filendringer rullet tilbake - web.config

Info Komponenten rullet tilbake med hell - Config

Info Installasjonen mislyktes - DotNetNuke.Blog

Info Slettede midlertidig installasjonskatalogen

Steps to reproduce (if needed)

Other comments or remarks