YAFLogo

infinitep
  • infinitep
  • 72.8% (Friendly)
  • YAF Lover Topic Starter
16 years ago
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'.

connectionStringName="ConnectionString"

applicationName="/"

type="System.Web.Security.SqlMembershipProvider" />

connectionStringName="yafnet"

applicationName="YetAnotherForum"

type="System.Web.Security.SqlMembershipProvider" />

connectionStringName="ConnectionString"

applicationName="/"

type="System.Web.Security.SqlRoleProvider"/>

connectionStringName="yafnet"

applicationName="YetAnotherForum"

type="System.Web.Security.SqlRoleProvider"/>

connectionStringName="yafnet"

applicationName="YetAnotherForum"

type="System.Web.Profile.SqlProfileProvider"/>


[url=http://craigwhiteman.blogspot.com.au/]Capt. ArkCAW HonourNRespect- Need an Ark? I Noah Guy![url]

Sponsor
wesclyburn
16 years ago
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.