DNNCommunity/DNN.Forum

SQL script error while installing any release version

Closed this issue · 5 comments

rashidbilgrami commented

Hi I have tried to install the script in my DNN 9 but it's throwing below error. The previous version installed successfully at my pervious portal

StartJob Starting Installation

Info Starting Installation - DNN_Forum

Info Starting Installation - Script

Info Begin Sql execution

Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\03.00.00.SqlDataProvider

Info Created - Providers\DataProviders\SqlDataProvider\03.00.00.SqlDataProvider

Info Executing 03.00.00.SqlDataProvider

Info Start Sql execution: 03.00.00.SqlDataProvider file

Failure SQL Execution resulted in following Exceptions:
System.Data.SqlClient.SqlException (0x80131904): Could not drop object 'dbo.Forum_Forums' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:3726,State:1,Class:16

if exists (select * from dbo.sysobjects where id = object_id(N'Forum_Forums') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table dbo.Forum_Forums

System.Data.SqlClient.SqlException (0x80131904): Could not drop object 'dbo.Forum_Posts' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:3726,State:1,Class:16

if exists (select * from dbo.sysobjects where id = object_id(N'Forum_Posts') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table dbo.Forum_Posts

System.Data.SqlClient.SqlException (0x80131904): Could not drop object 'dbo.Forum_Threads' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:3726,State:1,Class:16

if exists (select * from dbo.sysobjects where id = object_id(N'Forum_Threads') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table dbo.Forum_Threads

System.Data.SqlClient.SqlException (0x80131904): Could not drop object 'dbo.Forum_Users' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:3726,State:1,Class:16

if exists (select * from dbo.sysobjects where id = object_id(N'Forum_Users') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table dbo.Forum_Users

System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Forum_Forums' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:2714,State:6,Class:16

CREATE TABLE dbo.Forum_Forums (
[ForumID] [int] IDENTITY (1, 1) NOT NULL ,
[GroupID] [int] NOT NULL ,
[IsActive] [bit] NOT NULL ,
[ParentID] [int] NOT NULL ,
[Name] [nvarchar] (255) NOT NULL ,
[Description] [nvarchar] (2048) NULL ,
[CreatedDate] [datetime] NULL ,
[CreatedByUser] [int] NULL ,
[UpdatedByUser] [int] NULL ,
[UpdatedDate] [datetime] NULL ,
[IsModerated] [bit] NULL ,
[DaysToView] [int] NULL ,
[SortOrder] [int] NULL ,
[TotalPosts] [int] NULL ,
[TotalThreads] [int] NULL ,
[EnablePostStatistics] [bit] NULL ,
[EnableAutoDelete] [bit] NULL ,
[AutoDeleteThreshold] [int] NULL ,
[MostRecentPostID] [int] NULL ,
[MostRecentThreadID] [int] NULL ,
[MostRecentPostAuthorID] [int] NULL ,
[MostRecentPostDate] [datetime] NULL ,
[PostsToModerate] [int] NULL ,
[ForumType] [int] NULL ,
[IsIntegrated] [bit] NULL ,
[IntegratedModuleID] [int] NULL ,
[IntegratedObjects] [nvarchar] (255) NULL ,
[IsPrivate] [bit] NULL ,
[AuthorizedRoles] [nvarchar] (255) NULL ,
[AuthorizedEditRoles] [nvarchar] (255) NULL
)

System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Forum_Posts' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:2714,State:6,Class:16

CREATE TABLE dbo.Forum_Posts (
[PostID] [int] IDENTITY (1, 1) NOT NULL ,
[ParentPostID] [int] NOT NULL ,
[UserID] [int] NOT NULL ,
[RemoteAddr] [nvarchar] (100) NULL ,
[Notify] [bit] NULL ,
[Subject] [nvarchar] (255) NOT NULL ,
[Body] [ntext] NULL ,
[CreatedByUser] [int] NULL ,
[CreatedDate] [datetime] NULL ,
[ThreadID] [int] NULL ,
[PostLevel] [int] NULL ,
[UpdatedDate] [datetime] NULL ,
[UpdatedByUser] [int] NULL ,
[IsApproved] [bit] NULL ,
[IsLocked] [bit] NULL ,
[IsClosed] [bit] NULL ,
[MediaURL] [nvarchar] (255) NULL ,
[MediaNAV] [nvarchar] (255) NULL ,
[Attachments] [nvarchar] (255) NULL
)

System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Forum_Threads' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:2714,State:6,Class:16

CREATE TABLE dbo.Forum_Threads (
[ThreadID] [int] NOT NULL ,
[ForumID] [int] NOT NULL ,
[Views] [int] NULL ,
[LastPostedPostID] [int] NULL ,
[Replies] [int] NULL ,
[IsPinned] [bit] NULL ,
[PinnedDate] [datetime] NULL ,
[Image] [nvarchar] (255) NULL ,
[ObjectTypeCode] [int] NULL ,
[ObjectID] [char] (10) NULL
)

System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Forum_Users' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:2714,State:6,Class:16

CREATE TABLE dbo.Forum_Users (
[UserID] [int] NOT NULL ,
[UseRichText] [bit] NULL ,
[URL] [nvarchar] (128) NULL ,
[Signature] [nvarchar] (1024) NULL ,
[TimeZone] [int] NULL ,
[Occupation] [nvarchar] (255) NULL ,
[Interests] [nvarchar] (255) NULL ,
[MSN] [nvarchar] (128) NULL ,
[Yahoo] [nvarchar] (128) NULL ,
[AIM] [nvarchar] (128) NULL ,
[ICQ] [nvarchar] (128) NULL ,
[Skin] [nvarchar] (255) NULL ,
[UserAvatar] [bit] NULL ,
[Avatar] [nvarchar] (255) NULL ,
[AdditionalAvatars] [nvarchar] (255) NULL ,
[PostCount] [int] NULL ,
[LastActivity] [datetime] NULL ,
[LastForumsView] [datetime] NULL ,
[LastThreadView] [datetime] NULL ,
[FlatView] [bit] NULL ,
[IsTrusted] [bit] NULL ,
[EnableThreadTracking] [bit] NULL ,
[EnableDisplayUnreadThreadsOnly] [bit] NULL ,
[EnableDisplayInMemberList] [bit] NULL ,
[EnablePrivateMessages] [bit] NULL ,
[EnableOnlineStatus] [bit] NULL ,
[ThreadsPerPage] [int] NULL ,
[PostsPerPage] [int] NULL ,
[WhatsNewScrollDirection] [int] NULL ,
[WhatsNewNumberOfThread] [int] NULL ,
[WhatsNewScrollDelay] [int] NULL ,
[WhatsNewScrollAmount] [int] NULL ,
[WhatsNewTrackingType] [int] NULL ,
[WhatsNewTrackingDuration] [int] NULL ,
[WhatsNewTemplate] [nvarchar] (255) NULL ,
[DefaultForumID] [int] NULL ,
[CollapseGroups] [nvarchar] (255) NULL
)

System.Data.SqlClient.SqlException (0x80131904): Table 'Forum_Forums' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:1779,State:0,Class:16

ALTER TABLE dbo.Forum_Forums WITH NOCHECK ADD
CONSTRAINT PK_Forum_Forums PRIMARY KEY CLUSTERED
(
[ForumID]
)

System.Data.SqlClient.SqlException (0x80131904): Table 'Forum_Posts' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:1779,State:0,Class:16

ALTER TABLE dbo.Forum_Posts WITH NOCHECK ADD
CONSTRAINT PK_Forum_Posts PRIMARY KEY CLUSTERED
(
[PostID]
)

System.Data.SqlClient.SqlException (0x80131904): Table 'Forum_Threads' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:1779,State:0,Class:16

ALTER TABLE dbo.Forum_Threads WITH NOCHECK ADD
CONSTRAINT PK_Forum_Threads PRIMARY KEY CLUSTERED
(
[ThreadID]
)

System.Data.SqlClient.SqlException (0x80131904): Table 'Forum_Users' 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:1779,State:0,Class:16

ALTER TABLE dbo.Forum_Users WITH NOCHECK ADD
CONSTRAINT PK_Forum_Users PRIMARY KEY CLUSTERED
(
[UserID]
)

System.Data.SqlClient.SqlException (0x80131904): Column already has a DEFAULT bound to 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:1781,State:1,Class:16

ALTER TABLE dbo.Forum_Forums WITH NOCHECK ADD
CONSTRAINT DF_Forum_Forums_ParentID DEFAULT (0) FOR [GroupID],
CONSTRAINT DF_Forum_Forums_IsActive DEFAULT (1) FOR [IsActive],
CONSTRAINT DF_Forum_Forums_ParentID_1 DEFAULT (0) FOR [ParentID],
CONSTRAINT DF_Forum_Forums_DateCreated DEFAULT (getdate()) FOR [CreatedDate],
CONSTRAINT DF_Forum_Forums_IsModerated DEFAULT (0) FOR [IsModerated],
CONSTRAINT DF_Forum_Forums_DaysToView DEFAULT (0) FOR [DaysToView],
CONSTRAINT DF_Forum_Forums_SortOrder DEFAULT (0) FOR [SortOrder],
CONSTRAINT DF_Forum_Forums_TotalPosts DEFAULT (0) FOR [TotalPosts],
CONSTRAINT DF_Forum_Forums_TotalThreads DEFAULT (0) FOR [TotalThreads],
CONSTRAINT DF_Forum_Forums_EnablePostStatistics DEFAULT (0) FOR [EnablePostStatistics],
CONSTRAINT DF_Forum_Forums_EnableAutoDelete DEFAULT (0) FOR [EnableAutoDelete],
CONSTRAINT DF_Forum_Forums_AutoDeleteThreshold DEFAULT (90) FOR [AutoDeleteThreshold],
CONSTRAINT DF_Forum_Forums_MostRecentPostID DEFAULT (0) FOR [MostRecentPostID],
CONSTRAINT DF_Forum_Forums_MostRecentThreadID DEFAULT (0) FOR [MostRecentThreadID],
CONSTRAINT DF_Forum_Forums_MostRecentPostAuthorID DEFAULT (0) FOR [MostRecentPostAuthorID],
CONSTRAINT DF_Forum_Forums_MostRecentPostDate DEFAULT (getdate()) FOR [MostRecentPostDate],
CONSTRAINT DF_Forum_Forums_PostsToModerate DEFAULT (0) FOR [PostsToModerate],
CONSTRAINT DF_Forum_Forums_ForumType DEFAULT (0) FOR [ForumType],
CONSTRAINT DF_Forum_Forums_IsIntergrated DEFAULT (0) FOR [IsIntegrated],
CONSTRAINT DF_Forum_Forums_IntergratedGallery DEFAULT (0) FOR [IntegratedModuleID],
CONSTRAINT DF_Forum_Forums_IsPrivate DEFAULT (0) FOR [IsPrivate],
CONSTRAINT IX_Forum_Forums UNIQUE NONCLUSTERED
(
[ForumID]
)

System.Data.SqlClient.SqlException (0x80131904): Column 'PostLevel' in table 'Forum_Posts' is invalid for creating a default constraint.
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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:1752,State:0,Class:16

ALTER TABLE dbo.Forum_Posts WITH NOCHECK ADD
CONSTRAINT DF_Posts_PostLevel DEFAULT (0) FOR [PostLevel],
CONSTRAINT DF_Forum_Posts_IsApproved DEFAULT (1) FOR [IsApproved],
CONSTRAINT DF_Forum_Posts_IsLocked DEFAULT (0) FOR [IsLocked],
CONSTRAINT DF_Forum_Posts_IsClosed DEFAULT (0) FOR [IsClosed],
CONSTRAINT IX_Forum_Posts UNIQUE NONCLUSTERED
(
[PostID]
)

System.Data.SqlClient.SqlException (0x80131904): Column already has a DEFAULT bound to 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:1781,State:1,Class:16

ALTER TABLE dbo.Forum_Threads WITH NOCHECK ADD
CONSTRAINT DF_Forum_Threads_Replies DEFAULT (0) FOR [ForumID],
CONSTRAINT DF_Forum_Threads_Views DEFAULT (0) FOR [Views],
CONSTRAINT DF_Threads_LastPostedPostID DEFAULT (0) FOR [LastPostedPostID],
CONSTRAINT DF_Threads_ForumID DEFAULT (0) FOR [Replies],
CONSTRAINT DF_Forum_Threads_IsPinned DEFAULT (0) FOR [IsPinned],
CONSTRAINT DF_Forum_Threads_PinnedDate DEFAULT (getdate()) FOR [PinnedDate],
CONSTRAINT IX_Forum_Threads UNIQUE NONCLUSTERED
(
[ThreadID]
)

System.Data.SqlClient.SqlException (0x80131904): Column already has a DEFAULT bound to 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(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DotNetNuke.Data.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:1781,State:1,Class:16

ALTER TABLE dbo.Forum_Users WITH NOCHECK ADD
CONSTRAINT DF_Forum_Users_UseRichText DEFAULT (1) FOR [UseRichText],
CONSTRAINT DF_Forum_Users_TimeZone DEFAULT (0) FOR [TimeZone],
CONSTRAINT DF_Forum_Users_UseAvatar DEFAULT (0) FOR [UserAvatar],
CONSTRAINT DF_Forum_Users_PostCount DEFAULT (0) FOR [PostCount],
CONSTRAINT DF_Forum_Users_LastActivity DEFAULT (1 / 1 / 2001) FOR [LastActivity],
CONSTRAINT DF_Forum_Users_LastForumsView DEFAULT (1 / 1 / 2001) FOR [LastForumsView],
CONSTRAINT DF_Forum_Users_LastThreadView DEFAULT (1 / 1 / 2001) FOR [LastThreadView],
CONSTRAINT DF_Forum_Users_FlatView DEFAULT (1) FOR [FlatView],
CONSTRAINT DF_Forum_Users_IsTrusted DEFAULT (0) FOR [IsTrusted],
CONSTRAINT DF_Forum_Users_EnableThreadTracking DEFAULT (1) FOR [EnableThreadTracking],
CONSTRAINT DF_Forum_Users_EnableDisplayUnreadThreadsOnly DEFAULT (1) FOR [EnableDisplayUnreadThreadsOnly],
CONSTRAINT DF_Forum_Users_EnableDisplayInMemberList DEFAULT (1) FOR [EnableDisplayInMemberList],
CONSTRAINT DF_Forum_Users_EnablePrivateMessages DEFAULT (1) FOR [EnablePrivateMessages],
CONSTRAINT DF_Forum_Users_EnableOnlineStatus DEFAULT (1) FOR [EnableOnlineStatus]

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'Image'.
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.SqlDataProvider.ExecuteScriptInternal(String connectionString, String script, Int32 timeoutSec)
ClientConnectionId:5977f102-4597-44e4-ab27-4004f4571d3a
Error Number:207,State:1,Class:16

CREATE PROCEDURE dbo.Forum_AA_ThreadUpdate
(
@threadid int,
@postid int,
@IsPinned bit,
@PinnedDate datetime,
@image nvarchar(255),
@action nvarchar(10)
)
AS
IF @action = 'postadd'
BEGIN
UPDATE
Forum_Threads
SET
[LastPostedPostID] = @postid,
[Image] = @image,
[IsPinned] = @IsPinned,
[PinnedDate] = @PinnedDate,
[Replies] = ((SELECT [Replies] FROM Forum_Threads WHERE [ThreadID] = @threadid) + 1)
WHERE
[ThreadID] = @threadid
END
IF @action = 'postedit'
BEGIN -- edit the first post of this thread
UPDATE
Forum_Threads
SET
[Image] = @image,
[IsPinned] = @IsPinned,
[PinnedDate] = @PinnedDate
WHERE
[ThreadID] = @threadid
END
IF @action = 'postdelete'
BEGIN
DECLARE @LastPostID int
-- Get another lastpost to update thread info
SET @LastPostID = (SELECT MAX([PostID]) FROM Forum_Posts WHERE [ThreadID] = @threadid)
Print 'Last post id' + CONVERT(varchar, @LastPostID)
UPDATE
Forum_Threads
SET
[LastPostedPostID] = @LastPostID,
[Image] = @image,
[IsPinned] = @IsPinned,
[PinnedDate] = @PinnedDate,
[Replies] = ((SELECT [Replies] FROM Forum_Threads WHERE [ThreadID] = @threadid) - 1)
WHERE
[ThreadID] = @threadid
END

Info End Sql execution: 03.00.00.SqlDataProvider file

Info Finished Sql execution

Failure Installation Failed - Script

Info Installation Failed - DNN_Forum

Info Deleted temporary install folder

EndJob Installation Failed

juvander commented

Which forum version you uninstalled?

juvander commented

Also, check from Forum_Posts -table, which foreign key(s) it still has?

rashidbilgrami commented

I have resolved after posted the thread i am using dnn 9x you need to put the same uninstall table sequence in the data provided folder sql .

Still uninstall have one small issue forum table must be delete in last

juvander commented

Sql scripts go back many versions, that's why I was asking which Forum version you uninstalled before trying to install it again?

juvander commented

Did just a quick trial with latest version and it did install nicely and then uninstall all sql stuff just fine.

After these reinstall and all good.