Failed to install on DNN 9.8.0 ( FOREIGN KEY constraint)

Open

#178 opened on Nov 25, 2020 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty: 4/5
Estimated time: 3-5 days
Newbie friendliness: 30/100

Issue type: Bug
Clarity: Needs clarification
Activity status: Stale
Tech stack: sql
Domain: databases

Research direction

The log identifies 04.00.00.SqlDataProvider as the failing installation script; start there and inspect the upgrade path from module 03.05.01 to 06.05.01 on DNN 09.08.00. Reproduce the installation against SQL Server and verify it completes without foreign-key, existing-object, or duplicate-constraint errors.

Written by the indexing model from the issue text.

Description

Describe the bug

While trying to upgrade the module from 3.5.1 to 6.5.1 on DNN 9.8.0, i get an sql error

Software Versions

DNN: 09.08.00
Module: 03.05.01

Error log

`StartJob Starting Installation

Info Starting Installation - DotNetNuke.Blog

Info Starting Installation - Module

Info Module registered successfully - Blog

Info Component installed successfully - Module

Info Starting Installation - Config

Info Creating backup of previous version - web.config

Info Config file updated - web.config

Info Component installed successfully - Config

Info Starting Installation - Script

Info Begin Sql execution

Info Creating backup of previous version - 04.00.00.SqlDataProvider

Info Created - 04.00.00.SqlDataProvider

Info Executing 04.00.00.SqlDataProvider

Info Start Sql execution: 04.00.00.SqlDataProvider file

Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Could not drop object 'dbo.Blog_Categories' because it is referenced by a FOREIGN KEY constraint. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:3726,State:1,Class:16 /*************** TABLES ************************/ if exists (select * from dbo.sysobjects where id = object_id(N'dbo.Blog_Categories') and OBJECTPROPERTY(id, N'IsTable') = 1) DROP TABLE dbo.Blog_Categories System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Blog_Categories' in the database. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:2714,State:6,Class:16 CREATE TABLE dbo.[Blog_Categories] ( [CatID] [int] IDENTITY(1,1) NOT NULL, [Category] nvarchar NOT NULL, [Slug] nvarchar NOT NULL, [ParentID] [int] NULL, [PortalID] [int] NOT NULL, ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Table 'Blog_Categories' already has a primary key defined on it. Could not create constraint or index. See previous errors. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:1779,State:0,Class:16 ALTER TABLE dbo.[Blog_Categories] WITH NOCHECK ADD CONSTRAINT PK_Blog_Categories PRIMARY KEY CLUSTERED ( [CatID] ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_Blog_Categories_Portals' in the database. Could not create constraint or index. See previous errors. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:2714,State:5,Class:16 ALTER TABLE dbo.[Blog_Categories] ADD CONSTRAINT FK_Blog_Categories_Portals FOREIGN KEY ( [PortalId] ) REFERENCES dbo.Portals ( [PortalID] ) ON DELETE CASCADE ON UPDATE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Blog_Tags' in the database. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:2714,State:6,Class:16 CREATE TABLE dbo.[Blog_Tags] ( [TagID] [int] IDENTITY(1,1) NOT NULL, [Tag] [nvarchar](255) NOT NULL, [Slug] [nvarchar](255) NOT NULL, [Active] [bit] NOT NULL, [PortalID] [int] NOT NULL, ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Table 'Blog_Tags' already has a primary key defined on it. Could not create constraint or index. See previous errors. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:1779,State:0,Class:16 ALTER TABLE dbo.[Blog_Tags] WITH NOCHECK ADD CONSTRAINT PK_Blog_Tags PRIMARY KEY CLUSTERED ( [TagID] ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_Blog_Tags_Portals' in the database. Could not create constraint or index. See previous errors. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:2714,State:5,Class:16 ALTER TABLE dbo.[Blog_Tags] ADD CONSTRAINT FK_Blog_Tags_Portals FOREIGN KEY ( [PortalId] ) REFERENCES dbo.Portals ( [PortalID] ) ON DELETE CASCADE ON UPDATE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Blog_Entry_Categories' in the database. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:2714,State:6,Class:16 CREATE TABLE dbo.[Blog_Entry_Categories] ( [EntryCatID] [int] IDENTITY(1,1) NOT NULL, [EntryID] [int] NULL, [CatID] [int] NULL, ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Table 'Blog_Entry_Categories' already has a primary key defined on it. Could not create constraint or index. See previous errors. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:1779,State:0,Class:16 ALTER TABLE dbo.[Blog_Entry_Categories] WITH NOCHECK ADD CONSTRAINT PK_Blog_Entry_Categories PRIMARY KEY CLUSTERED ( [EntryCatID] ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_Blog_Entry_Categories_Entries' in the database. Could not create constraint or index. See previous errors. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:2714,State:5,Class:16 ALTER TABLE dbo.[Blog_Entry_Categories] ADD CONSTRAINT FK_Blog_Entry_Categories_Entries FOREIGN KEY ( [EntryID] ) REFERENCES dbo.Blog_Entries ( [EntryID] ) ON DELETE CASCADE ON UPDATE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_Blog_Entry_Categories_Categories' in the database. Could not create constraint or index. See previous errors. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:2714,State:5,Class:16 ALTER TABLE dbo.[Blog_Entry_Categories] ADD CONSTRAINT FK_Blog_Entry_Categories_Categories FOREIGN KEY ( [CatID] ) REFERENCES dbo.Blog_Categories ( [CatID] ) ON DELETE CASCADE ON UPDATE CASCADE System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Blog_Entry_Tags' in the database. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:2714,State:6,Class:16 CREATE TABLE dbo.[Blog_Entry_Tags] ( [EntryTagID] [int] IDENTITY(1,1) NOT NULL, [EntryID] [int] NOT NULL, [TagID] [int] NOT NULL, ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): Table 'Blog_Entry_Tags' already has a primary key defined on it. Could not create constraint or index. See previous errors. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:1779,State:0,Class:16 ALTER TABLE dbo.[Blog_Entry_Tags] WITH NOCHECK ADD CONSTRAINT PK_Blog_Entry_Tags PRIMARY KEY CLUSTERED ( [EntryTagID] ) ON [PRIMARY] System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'FK_Blog_Entry_Tags_Entries' in the database. Could not create constraint or index. See previous errors. 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(TaskCompletionSource1 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:2714,State:5,Class:16 ALTER TABLE dbo.[Blog_Entry_Tags] ADD CONSTRAINT FK_Blog_Entry_Tags_Entries FOREIGN KEY ( [EntryID] ) REFERENCES dbo.Blog_Entries ( [EntryID] ) ON DELETE CASCADE ON UPDATE CASCADE System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '('. 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:09d04139-38ca-44ab-b74f-6c3ee947a04c Error Number:102,State:1,Class:15 ALTER TABLE dbo.[Blog_Entry_Tags] ADD CONSTRAINT FK_Blog_Entry_Tags_Tags FOREIGN KEY ( [TagID] ) REFERENCES dbo.Blog_Tags ( [TagID] ) ON DELETE CASCADEWITH (ALLOW_PAGE_LOCKS=OFF) ON UPDATE CASCADE

Info End Sql execution: 04.00.00.SqlDataProvider file

Info Finished Sql execution

Failure Installation Failed - Script`

Dominant language: JavaScript
Stars: 39
Forks: 41
PR merge metrics: No merged PRs in 30d

Getting set up

No Dockerfile or Docker Compose file
Has a pull request template
Read the contributing guide

First steps

Read the whole issue, then the project's contributing guide.
Comment on the issue to say you are picking it up — it saves two people doing the same work.
Fork the repository and make your change on a branch.
Open a pull request that references the issue number.

Similar issues

[Feature]:
Open
- Is something wrong?
enhancement

Difficulty 2/5 1-3 hours Newbie friendliness 65/100

bitfocus/companion-module-openweather-rest#51 · Opened Oct 6, 2026
Link Checker Report (lycheeverse/lychee-action)
Open
- Is something wrong?
automated issue report

Difficulty 2/5 1-3 hours Newbie friendliness 62/100

lirantal/discoprint#36 · Opened Oct 5, 2026

Maintainers usually reply within 1 day
Outdated text about select multiple size=1
Open
- Is something wrong?
accepting PR Content:HTML

Difficulty 1/5 Under an hour Newbie friendliness 88/100

mdn/content#45988 · 1 comment · Opened Oct 5, 2026

Maintainers usually reply within 1 day
`pnpm setup` PATH guard leaves `$PNPM_HOME/bin` behind system paths in login shells that inherit PATH, so the global `node` shim is bypassed
Open
- Is something wrong?
Difficulty 2/5 1-3 hours Newbie friendliness 72/100

pnpm/pnpm#16635 · 1 comment · Opened Oct 5, 2026

Maintainers usually reply within 1 day
preverify does not run swagger-check or frontend-lint
Open
- Is something wrong?
Difficulty 2/5 1-3 hours Newbie friendliness 82/100

txn2/mcp-data-platform#2030 · Opened Oct 5, 2026

Maintainers usually reply within 1 day

More JavaScript issues

Failed to install on DNN 9.8.0 ( FOREIGN KEY constraint)

Is something wrong?

Assessment

Research direction

Description

Describe the bug

Software Versions

Error log

Getting set up

First steps

More from DNNCommunity/DNN.Blog

Is something wrong?

Is something wrong?

Is something wrong?

Is something wrong?

Is something wrong?

Similar issues

Is something wrong?

Is something wrong?

Is something wrong?

Is something wrong?

Is something wrong?

Get new issues in your inbox