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.
- 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
Assessment
This issue has not been assessed yet.