DNNCommunity / DNN.Forum

DNN.Forum
9 stars 7 forks source link

SQL script error while installing any release version #20

Closed rashidbilgrami closed 5 years ago

rashidbilgrami commented 5 years ago

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 5 years ago

Which forum version you uninstalled?

juvander commented 5 years ago

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

rashidbilgrami commented 5 years ago

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 5 years ago

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 5 years ago

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.