I am unable to load forum module. I have not had difficulty with any other module. The error message is extensive and begins with

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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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...

Any insights?

To start, which version of DotNetNuke are you using, and which version of the Forum module? The error message seems to indicate that you already have the Forum module installed (reference to DROP). So, this might be a version-dependent issue.

I am using V6.0 and I only have attempted to load the forum to this installation.

Do you have Forum 5.0.3 installed or Forum 4.5.3? If 4.5.3 you can find Forum 5.0.3 in Host > Extensions, Available Extensions tab.

My problem is I attempted to load the forums module and it did not load properly. Now the module does not appear in either the installed or the available modules tabs. I prbably need to unistall the corrupted files but I do not know where to locate them.

Get a copy of the DotNetNuke 6.0 Install package.

Open the ZIP file and look in the Install/Module directory for Forum_05.00.03_Install.resources. Copy the file somewhere on your drive and rename it as Forum_05.00.03_Install.zip.

Now, go to the Extensions page and install the Forum_05.00.03_Install.zip file as you would install any other module. If you get a message that the module already has been installed, check the box to repair or reinstall the module. If there are any errors reported during the install, please copy and paste in a reply to this message.

Hi, we are running a v5.6.3 installation of DotNetNuke, we have never installed the forums module in this environment. I went to load it today through Install Available Extensions and got an error message, then I tried to load it manually though Install Extensions after I downloaded it from the DotNetNuke.com website. I received the following error - part of which is attached here:

Package Installation Report

See below for the results of the package installation
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 (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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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 (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) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() 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

The error message goes on for quite some time see the attached file for the entire message. I wanted to see if anyone had any ideas as to what to do. Upgrading to DotNetNuke v6 is not an option here, so I really need to fix this in the v5.6.3 environment.

Thanks in advance for any help.
James Nagy
Sprocket Websites, Inc.

Go to Host, Extensions and see if your system thinks that the Forum module is installed. If so, try deleting the module and then try the install again. The error message refers to dbo.Forum_Forums, so it looks like something got installed or partially installed on your first try.

If you can't uninstall the module, you may need to go in and manually remove some things.

Joe,

Thanks for the reply! No I see nothing installed under Host, so what would you suggest that I look at removing. It appears that lots of tables did get created. See attachment.

Thanks for your help.

JNagy

I was actually referring to the database.

The main error is: 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.

That indicates that there is a table named Forum_Forums in the database. There may be other tables named Forum_xxxx so you will need to get rid of them.

Do this with SQL Server Management Studio. You may need to delete some constraints before you can actually delete the tables.

Also, if there is a Desktop Modules/Forums folder you should delete it.

After that, try doing the module install again.

Joe,

So I was able to remove all the Forum tables (some did have dependencies, but as you removed other Forum tables, those dependencies went away. I did delete the Desktop Modules/Forums folder and when I went to load the module again, I received a different error, which is what I probably received the first time, but didn't notice as I had done the install through Load Available Extensions rather than the Install Extension Wizard. Here is the new error:

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 Folder Created - C:\DotNetNuke\DesktopModules\Forum\Providers\DataProviders\SqlDataProvider\
Info Created - 03.00.00.SqlDataProvider
Info Executing 03.00.00.SqlDataProvider
Info Start Sql execution: 03.00.00.SqlDataProvider file
Info End Sql execution: 03.00.00.SqlDataProvider file
Info Created - 03.10.05.SqlDataProvider
Info Executing 03.10.05.SqlDataProvider
Info Start Sql execution: 03.10.05.SqlDataProvider file
Info End Sql execution: 03.10.05.SqlDataProvider file
Info Created - 04.03.00.SqlDataProvider
Info Executing 04.03.00.SqlDataProvider
Info Start Sql execution: 04.03.00.SqlDataProvider file
Info End Sql execution: 04.03.00.SqlDataProvider file
Info Created - 04.03.04.SqlDataProvider
Info Executing 04.03.04.SqlDataProvider
Info Start Sql execution: 04.03.04.SqlDataProvider file
Info End Sql execution: 04.03.04.SqlDataProvider file
Info Created - 04.04.03.SqlDataProvider
Info Executing 04.04.03.SqlDataProvider
Info Start Sql execution: 04.04.03.SqlDataProvider file
Info End Sql execution: 04.04.03.SqlDataProvider file
Info Created - 04.04.04.SqlDataProvider
Info Executing 04.04.04.SqlDataProvider
Info Start Sql execution: 04.04.04.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Forum_Members_GetByEmail' 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() 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_Members_GetByEmail] @PortalId INT, @EmailToMatch NVARCHAR(256), @PageIndex INT, @PageSize INT AS BEGIN -- Set the page bounds DECLARE @PageLowerBound INT DECLARE @PageUpperBound INT SET @PageLowerBound = @PageSize * @PageIndex SET @PageUpperBound = @PageSize - 1 + @PageLowerBound -- Create a temp table TO store the select results CREATE TABLE #PageIndexForUsers ( IndexId INT IDENTITY(0, 1) NOT NULL, UserId INT ) -- Insert into our temp table IF ( @EmailToMatch IS NULL ) INSERT INTO #PageIndexForUsers ( UserId ) SELECT UserId FROM dbo.Forum_vw_ForumUsers WHERE Email IS NULL AND ( PortalId = @PortalId OR ( PortalId IS NULL AND @PortalId IS NULL ) ) ORDER BY Email ELSE INSERT INTO #PageIndexForUsers ( UserId ) SELECT UserId FROM dbo.Forum_vw_ForumUsers WHERE LOWER(Email) LIKE LOWER(@EmailToMatch) AND ( PortalId = @PortalId OR ( PortalId IS NULL AND @PortalId IS NULL ) ) ORDER BY Email SELECT U.[UserID], [PostCount], [EnableDisplayInMemberList], [EnableOnlineStatus], [EnablePM], [PortalID], [FirstName], [LastName], [Email], [Username], [PostCount], ( SELECT COUNT(UserID) FROM dbo.Forum_vw_ForumUsers ) AS TotalRecords FROM dbo.Forum_vw_ForumUsers U INNER JOIN #PageIndexForUsers P ON U.UserID = P.UserID WHERE ( PortalId = @PortalId OR ( PortalId IS NULL AND @PortalId IS NULL ) ) AND P.IndexId >= @PageLowerBound AND P.IndexId <= @PageUpperBound ORDER BY LOWER(U.Email) END System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'Forum_Members_GetOnline' 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() 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_Members_GetOnline] @PortalID INT AS SELECT U.[UserID], [PostCount], [EnableDisplayInMemberList], [EnableOnlineStatus], [EnablePM], U.[PortalID], [FirstName], [LastName], [Email], [Username], [PostCount], ( SELECT COUNT(UserID) FROM dbo.Forum_vw_ForumUsers ) AS TotalRecords FROM dbo.UsersOnline UO INNER JOIN dbo.Forum_vw_ForumUsers U ON UO.UserID = U.UserID WHERE U.PortalID = @PortalID
Info End Sql execution: 04.04.04.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_Forum
Info Deleted temporary install folder
EndJob Installation Failed

Any more thoughts? Thanks again for the help.

JNagy

Yes, I should have also mentioned stored procedures.

You'll have to go back into the database, find all of the stored procedures and remove them, too.

---------
With all of this manually editing the database, please make a backup of it before doing anything else!

Is there a way to remove the stored procedures all at once? Manually removing them one by one could take a while?

JNagy

Joe,

Ok so I got all the Stored Procedures removed, and I removed all of the Forum Tables again, and I deleted the Desktop Modules/Forums code and I got the following error: What fun:

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 Folder Created - C:\DotNetNuke\DesktopModules\Forum\Providers\DataProviders\SqlDataProvider\
Info Created - 03.00.00.SqlDataProvider
Info Executing 03.00.00.SqlDataProvider
Info Start Sql execution: 03.00.00.SqlDataProvider file
Info End Sql execution: 03.00.00.SqlDataProvider file
Info Created - 03.10.05.SqlDataProvider
Info Executing 03.10.05.SqlDataProvider
Info Start Sql execution: 03.10.05.SqlDataProvider file
Info End Sql execution: 03.10.05.SqlDataProvider file
Info Created - 04.03.00.SqlDataProvider
Info Executing 04.03.00.SqlDataProvider
Info Start Sql execution: 04.03.00.SqlDataProvider file
Info End Sql execution: 04.03.00.SqlDataProvider file
Info Created - 04.03.04.SqlDataProvider
Info Executing 04.03.04.SqlDataProvider
Info Start Sql execution: 04.03.04.SqlDataProvider file
Info End Sql execution: 04.03.04.SqlDataProvider file
Info Created - 04.04.03.SqlDataProvider
Info Executing 04.04.03.SqlDataProvider
Info Start Sql execution: 04.04.03.SqlDataProvider file
Info End Sql execution: 04.04.03.SqlDataProvider file
Info Created - 04.04.04.SqlDataProvider
Info Executing 04.04.04.SqlDataProvider
Info Start Sql execution: 04.04.04.SqlDataProvider file
Info End Sql execution: 04.04.04.SqlDataProvider file
Info Created - 04.05.00.SqlDataProvider
Info Executing 04.05.00.SqlDataProvider
Info Start Sql execution: 04.05.00.SqlDataProvider file
Failure SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException (0x80131904): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. 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() 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) DECLARE @default_constraint_name SYSNAME, @sql NVARCHAR(3750) IF EXISTS ( SELECT name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_EmailQueue_TaskEmails') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'DateAdded' ) ) BEGIN SELECT @default_constraint_name = name FROM dbo.sysobjects WHERE parent_obj = OBJECT_ID(N'dbo.Forum_EmailQueue_TaskEmails') AND type = 'D' AND id = ( SELECT cdefault FROM syscolumns WHERE name = N'DateAdded' ) SET @sql = N'ALTER TABLE dbo.Forum_EmailQueue_TaskEmails DROP Constraint ' + @default_constraint_name EXEC sp_executesql @sql END System.Data.SqlClient.SqlException (0x80131904): 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() 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_EmailQueue_TaskEmails ADD CONSTRAINT DF_Forum_EmailQueue_TaskEmails_DateAdded DEFAULT (GETDATE()) FOR DateAdded
Info End Sql execution: 04.05.00.SqlDataProvider file
Info Finished Sql execution
Failure Installation Failed - Script
Info Installation Failed - DNN_Forum
Info Deleted temporary install folder
EndJob Installation Failed

Getting Closer? Thanks,

JNagy