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

HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint Error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_FolderPermission_Permissio
Previous
 
Next
New Post
2/2/2006 11:59 AM
 

I'm hosting this on a remote server.  My provider has been kind enough to setup the permissions, but after 5 hours of speaking with tech support, we can't find a solution to the problem listed below.  If anyone has some suggestions, please offer them up. 

 

Thanks,

--Ken

 

Installing DotNetNuke

Version: 04.00.02

 

Installation Status Report

00:00:00.078 - Installing Version: 3.1.0
00:00:00.078 - Installing Script: DotNetNuke.SetUp.SqlDataProvider
00:00:02.593 - Installing Script: DotNetNuke.Schema.SqlDataProvider
00:05:19.437 - Installing Script: DotNetNuke.Data.SqlDataProvider
00:05:50.312 - Installing MemberRole Provider:
00:05:50.312 - Executing InstallCommon.sql
00:06:00.328 - Executing InstallMembership.sql
00:06:01.515 - Executing InstallProfile.sql
00: - Executing InstallRoles.sql
00:06:03.031 - Upgrading to Version: 3.1.1
00:06:06.703 - Upgrading to Version: 3.2.0
00:06:06.812 - Upgrading to Version: 4.0.0
00:06:07.390 - Upgrading to Version: 4.0.1
00:06:07.500 - Upgrading to Version: 4.0.2
00:06:07.515 - Performing General Upgrades
00:06:08.281 - Loading Host Settings:
00:06:08.765 - Configuring SuperUser:
00:06:09.625 - Installing Desktop Modules:
00:06:09.625 - Installing Modules:
00:06:09.656 -   Installing Module File F:\mydomain\Install\Module\Announcements_3.1_Install.zip:
00:06:10.531 -   Installing Module File F:\mydomain\Install\Module\Contacts_3.1_Install.zip:
00:06:10.906 -   Installing Module File F:\mydomain\Install\Module\Discussions_3.1_Install.zip:
00:06:11.281 -   Installing Module File F:\mydomain\Install\Module\Documents_3.1_Install.zip:
00:06:11.656 -   Installing Module File F:\mydomain\Install\Module\Events_3.1_Install.zip:
00:06:12.734 -   Installing Module File F:\mydomain\Install\Module\FAQs_3.1_Install.zip:
00:06:13.218 -   Installing Module File F:\mydomain\Install\Module\Feedback_3.1_Install.zip:
00:06:13.312 -   Installing Module File F:\mydomain\Install\Module\HTML_3.1_Install.zip:
00:06:14.109 -   Installing Module File F:\mydomainInstall\Module\IFrame_3.1_Install.zip:
00:06:14.171 -   Installing Module File F:\mydomain\Install\Module\Image_3.1_Install.zip:
00:06:14.406 -   Installing Module File F:\mydomainInstall\Module\Links_3.1_Install.zip:
00:06:15.140 -   Installing Module File F:\mydomain\Install\Module\NewsFeeds_3.1_Install.zip:
00:06:15.500 -   Installing Module File F:\mydomain\Install\Module\Survey_3.1_Install.zip:
00:06:16.078 -   Installing Module File F:\mydomain\Install\Module\UserDefinedTable_3.1_Install.zip:
00:06:16.656 -   Installing Module File F:\mydomain\Install\Module\UsersOnline_3.1_Install.zip:
00:06:16.812 -   Installing Module File F:\mydomain\Install\Module\XML_3.1_Install.zip:
00:06:16.875 - Executing Additional Scripts:
00:06:16.875 -   Creating Portal: My Website
00:06:19.578 -   Error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_FolderPermission_Permission'. The conflict occurred in database 'dotnet', table 'Permission', column 'PermissionID'. The statement has been terminated.
00:06:19.578 -   Portal failed to install:
00:06:19.578 - Installing Optional Resources:

Installation Complete

 

Click Here To Access Your Portal

 

And when I click to access it, the following error displays:

 

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

 
[NullReferenceException: Object reference not set to an instance of an object.]
   DotNetNuke.Entities.Portals.PortalSettings.GetPortalSettings(Int32 TabId, PortalAliasInfo objPortalAliasInfo) +125
   DotNetNuke.Entities.Portals.PortalSettings..ctor(Int32 tabId, PortalAliasInfo objPortalAliasInfo) +83
   DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +3800
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

 


Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

 
New Post
5/25/2006 2:28 PM
 
I'm having the exact error.  Were you ever able to fix this?
 
New Post
5/26/2006 9:47 PM
 

remove the database in the app_data folder that was created, and make sure that the dotnetnuke_template.mdf that you have is a blank database, and does not contain any DNN tables in it. it should only have a login that you created for the installation of the DB.

review the installation video at www.traincert.net

Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table.

 
New Post
5/30/2006 9:24 AM
 
I'm sorry but I'm using a SQL 2000 Server and I don't think this answer applies.  All I want to do is have 2 separate installations of DNN 4.03 use the same database.  Each site would have it's unique table prefixes (object_qualifier).
 
New Post
5/30/2006 9:41 AM
 
Hi jonstalnaker!
The reason seems to be very simple. You had inserted an object that has the primary key (exactly it is the forein key + primarykey) that is duplicate with an already existed in the database. This is runtime error and it's hard to define the error.
You can try these intructions to solve it:
1. Check if the primary key is not duplicate when input your data.
2. Delete the object with the primary key you want to insert in database first to sure that we haven't that key before inserting the object.
3. All of these things is original form the database design and business rules. Check them again in oder to sure that this won't happen again.
Hope this helps,
CPC
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedInstalling DNN ...Installing DNN ...Error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint Error: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_FolderPermission_Permissio


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