DB Error When creating a new Forum · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Kamyar
100% (Exalted)
YAF Developer Topic Starter

14 years ago

When trying to create a new forum, the db returns the following error:

The INSERT statement conflicted with the FOREIGN KEY SAME TABLE constraint "FK_yaf_Forum_yaf_Forum". The conflict occurred in database "yafnet", table "dbo.yaf_Forum", column 'ForumID'.
Cannot insert the value NULL into column 'ForumID', table 'yafnet.dbo.yaf_ForumAccess'; column does not allow nulls. INSERT fails.
The statement has been terminated.
The statement has been terminated.

That's because the @ParentID is set to 0 which conflicts with the foreign key defined in yaf_forum.

Adding

if @ParentID = 0 set @ParentID = null

to the yaf_forum_save stored procedure solves the issue.

If at first you don’t succeed, call it version 1.0

Wanna join the discussion?! Login to your YAF.NET Support Forum forum account or Register a new forum account

Sponsor

Kamyar
100% (Exalted)
YAF Developer Topic Starter

14 years ago

Just committed to SVN No. 3433

Hopefully, it works fine now.

If at first you don’t succeed, call it version 1.0

Important Information: