infinitep
  • Posts: 34
  • Joined: 28/05/2008
When trying to install to an exsiting ASP.net site using the following web.config I get the following error on installing with full text search.

The INSERT statement conflicted with the FOREIGN KEY constraint 'FK_BBCode_Board'. The conflict occurred in database "Forum", table "dbo.yaf_Board", column 'BoardID'.

<membership>
<providers>
<clear/>
<add name="AspNetSqlMembershipProvider"
connectionStringName="ConnectionString"
applicationName="/"
type="System.Web.Security.SqlMembershipProvider" />
<add name="YafMembershipProvider"
connectionStringName="yafnet"
applicationName="YetAnotherForum"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>
<roleManager enabled="true">
<providers>
<clear/>
<add name="AspNetSqlRoleProvider"
connectionStringName="ConnectionString"
applicationName="/"
type="System.Web.Security.SqlRoleProvider"/>
<add name="YafRoleProvider"
connectionStringName="yafnet"
applicationName="YetAnotherForum"
type="System.Web.Security.SqlRoleProvider"/>
</providers>
</roleManager>
<profile enabled="true" defaultProvider="YafProfileProvider">
<providers>
<clear />
<add name="YafProfileProvider"
connectionStringName="yafnet"
applicationName="YetAnotherForum"
type="System.Web.Profile.SqlProfileProvider"/>
</providers>
</profile>

[url=http://craigwhiteman.blogspot.com.au/]Capt. ArkCAW HonourNRespect- Need an Ark? I Noah Guy![url]
Sponsor
wesclyburn
  • Posts: 34
  • Joined: 25/09/2004
That error occurs on all new installations. The wizard flow is bugged.

Step 2 calls UpgradeDatabase() (In ./install/default.aspx.cs), which imports the BB Code, but the board record isn't created until step 3 when the system_initialize sproc is executed.

My workaround was to comment-out the restraint in restraints.sql during installation, then run the sql to create it afterwards.
Forum Jump  
  • You cannot post new topics in this forum.
  • You cannot reply to topics in this forum.
  • You cannot delete your posts in this forum.
  • You cannot edit your posts in this forum.
  • You cannot create polls in this forum.
  • You cannot vote in polls in this forum.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved