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"/>

---

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.