Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumCanCan't install Forum Module
Previous
 
Next
New Post
11/8/2007 10:59 PM
 

Right. I'm new to DNN. Recently installed the lastest version just a couple of days ago.

I've stumbled into a error when I try to install the forum module. I would copy and past the error here, but it is so large it would take someone an hour and two cups of coffee to even attempt to read it.

It occurs when I go to upload the module in module definitions. I add the forum.zip file in the file upload box then hit 'upload new file'. The install then starts off alright but hits problems when it gets to = 

Startjob Start Sql execution: 03.00.00SqlDataProvider file

SQL Execution resulted in following Exceptions: System.Data.SqlClient.SqlException: Could not drop object 'dnusr_ce2a5378d.Forum_Forums' because it is referenced by a FOREIGN KEY constraint. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection. CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText) 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 dnusr_ce2a5378d.Forum_Forums System.Data.SqlClient.SqlException: Could not drop object 'dnusr_ce2a5378d.Forum_Posts' because it is referenced by a FOREIGN KEY constraint. at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteNonQuery(SqlConnection connection

It goes on and on. It will repeat itself for version 03.00.10 and then through all subsequent versions until it gets all the way to 04.04.03

If this isn't enough to go on let me know. I can post the whole error, but it could take up several pages.

Cheers in advance.

Kevin.

 
New Post
11/9/2007 5:52 AM
 

That looks like it is this part of the script

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

Is user  dnusr_ce2a5378d really db_owner in the database?


Web applications, DNN websites, modules, skins and support
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumCanCan't install Forum Module


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out