I was able to install all the modules that were in the "Install Available Extensions" section except Feedback and Forum by deleting the ..\Portals\_default\EventQueue\EventQueue.config file. I still do not have Account Login under modules nor do I have anything on the "Create New Module Page" other than he menus.
Here is the error from trying to Install Feedback 05.00.02:
Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - DNN_Feedback
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - Providers\DataProviders\SqlDataProvider\03.02.01.SqlDataProvider
Info Created - Providers\DataProviders\SqlDataProvider\03.02.01.SqlDataProvider
Info Executing 03.02.01.SqlDataProvider
Info Start Sql execution: 03.02.01.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) /** Create Stored Procedures **/ create procedure dbo.CreateFeedback @Category int, @CreatedByEmail nvarchar(200), @FeedBackGUID nvarchar(50), @ModuleID int, @Status int, @Message nvarchar(1000), @Subject nvarchar(200) as insert into Feedback ( Category, CreatedByEmail, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) values ( @Category, @CreatedByEmail, getdate(), @FeedBackGUID, @ModuleID, @Status, @Message, @Subject ) System.Data.SqlClient.SqlException: Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'FeedBackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetCategoryFeedback @Category int, @Status int, @CurrentPage int, @PageSize int AS --Create a temp table to hold the current page of data --Add and ID column to count the records CREATE TABLE #TempTable ( ID int IDENTITY PRIMARY KEY, FeedbackID int, Category int, CreatedByEmail nvarchar(200), ApprovedBy int, DateCreated datetime, FeedBackGUID nvarchar(50), ModuleID int, Status int, Message nvarchar(1000), Subject nvarchar(200) ) --Fill the temp table with the Customers data IF @Category = 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Status = @Status ORDER BY DateCreated Desc END IF @Category > 0 BEGIN INSERT INTO #TempTable ( FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject ) SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject FROM Feedback WHERE Category = @Category and Status = @Status ORDER BY DateCreated Desc END --Return the total number of records available DECLARE @TotalRecords int SELECT @TotalRecords = COUNT(FeedbackID) FROM #TempTable --Create variable to identify the first and last record that should be selected DECLARE @FirstRec int, @LastRec int SELECT @FirstRec = (@CurrentPage - 1) * @PageSize SELECT @LastRec = (@CurrentPage * @PageSize + 1) --Select one page of data based on the record numbers above SELECT FeedbackID, Category, CreatedByEmail, ApprovedBy, DateCreated, FeedBackGUID, ModuleID, Status, Message, Subject, TotalRecords = @TotalRecords FROM #TempTable WHERE ID > @FirstRec AND ID < @LastRec System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.GetFeedbackByGUID @FeedbackGUID nvarchar(50) as select * from Feedback where FeedbackGUID = @FeedbackGUID System.Data.SqlClient.SqlException: Invalid column name 'FeedbackGUID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) create procedure dbo.UpdateFeedbackStatus @FeedBackGUID nvarchar(50), @Status int as update Feedback set Status = @Status where FeedbackGUID = @FeedbackGUID
Info End Sql execution: 03.02.01.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_Feedback
Info Deleted temporary install folder
EndJob Installation Failed
Here is what I get when trying to install Forum 05.00.00:
Error loading files from temporary folder - see below
StartJob Starting Installation
Info Starting Installation - DNN_Forum
Info Starting Installation - Script
Info Begin Sql execution
Info Creating backup of previous version - 03.00.00.SqlDataProvider
Info Created - 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: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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: 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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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: There is already an object named 'Forum_Forums' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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 ) ON [PRIMARY] System.Data.SqlClient.SqlException: There is already an object named 'Forum_Posts' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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 ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] System.Data.SqlClient.SqlException: There is already an object named 'Forum_Threads' in the database. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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 ) ON [PRIMARY] System.Data.SqlClient.SqlException: Table 'Forum_Forums' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Forum_Forums WITH NOCHECK ADD CONSTRAINT PK_Forum_Forums PRIMARY KEY CLUSTERED ( [ForumID] ) ON [PRIMARY] System.Data.SqlClient.SqlException: Table 'Forum_Posts' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Forum_Posts WITH NOCHECK ADD CONSTRAINT PK_Forum_Posts PRIMARY KEY CLUSTERED ( [PostID] ) ON [PRIMARY] System.Data.SqlClient.SqlException: Table 'Forum_Threads' already has a primary key defined on it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Forum_Threads WITH NOCHECK ADD CONSTRAINT PK_Forum_Threads PRIMARY KEY CLUSTERED ( [ThreadID] ) ON [PRIMARY] System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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] ) ON [PRIMARY] System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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] ) ON [PRIMARY] System.Data.SqlClient.SqlException: Column already has a DEFAULT bound to it. Could not create constraint. See previous errors. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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] ) ON [PRIMARY] System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Forum_Forums_Forum_Groups". The conflict occurred in database "DNN_RR1", table "dbo.Forum_Groups", column 'GroupID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Forum_Forums ADD CONSTRAINT FK_Forum_Forums_Forum_Groups FOREIGN KEY ( [GroupID] ) REFERENCES dbo.Forum_Groups ( [GroupID] ) ON DELETE CASCADE NOT FOR REPLICATION System.Data.SqlClient.SqlException: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_Forum_Posts_Forum_Users". The conflict occurred in database "DNN_RR1", table "dbo.Forum_Users", column 'UserID'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) ALTER TABLE dbo.Forum_Posts ADD CONSTRAINT FK_Forum_Posts_Forum_Threads FOREIGN KEY ( [ThreadID] ) REFERENCES dbo.Forum_Threads ( [ThreadID] ) ON DELETE CASCADE NOT FOR REPLICATION , CONSTRAINT FK_Forum_Posts_Forum_Users FOREIGN KEY ( [UserID] ) REFERENCES dbo.Forum_Users ( [UserID] ) ON DELETE CASCADE NOT FOR REPLICATION System.Data.SqlClient.SqlException: Invalid column name 'Image'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at DotNetNuke.Data.SqlDataProvider.ExecuteADOScript(String SQL) at DotNetNuke.Data.SqlDataProvider.ExecuteScript(String Script, Boolean UseTransactions) 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 (nolock) 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 (nolock) 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 (nolock) 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
|