DNNCommunity / DNNCommunity/DNN.Blog

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

Open
#193 0 comments 0 reactions 0 assignees View on GitHub
Dominant language
JavaScript
Stars
39
Forks
41
PR merge metrics
No merged PRs in 30d

Description

## 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, 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, 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, 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, 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

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.