delete the test forum from the first board then try again
Deleting via YetAnotherForum.NET admin gave me following error:"There has been a serious error loading the forum. No further information is available.
Please contact the administrator if this message persists. "
Win log says:"Undantagsmeddelande: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_yaf_Active_yaf_User'. The conflict occurred in database 'yet_another_forum_test', table 'yaf_Active', column 'UserID'.
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_yaf_User_yaf_Rank'. The conflict occurred in database 'yet_another_forum_test', table 'yaf_User', column 'RankID'.
DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_yaf_Rank_yaf_Board'. The conflict occurred in database 'yet_another_forum_test', table 'yaf_Rank', column 'BoardID'.
The statement has been terminated."
When I try to delete in SQL Server Management Studio 2008 I get following message:"No rows were deleted.
A problem occured attempting to delete row 1.
Error Source: .Net SqlClient Data Provider.
Error Message: DELETE statement conflicted with COLUMN REFERENCE constraint 'FK_yaf_Active_yaf_Board'.
The conflict occured in database 'yet_another_forum_test', table 'yaf_Active',
column 'BoardID'.
The statement has been terminated.
Correct the errors and attempt to delete the row again or press ESC to cancel the change(s)."
So it seems alot of tables are nestled together with the Board id.
After having clearing the whole database almost, you can delete the default board. However, now user is deleted so now you can't do anything... How am I supposed to do anything now?
You can easily say this doesn't work. :D
So I will try everything from the beginning again.
When trying to clear the database with:EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
The following tables aren't removed:yaf_AccesMask
yaf_Board
yaf_Category
yaf_Forum
yaf_Message
yaf_NntpForum
yaf_NntpServer
yaf_PMessage
yaf_Poll
yaf_Rank
yaf_Topic
Error message is:Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_Message' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_PMessage' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_Poll' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_Topic' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_User' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_Rank' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_AccessMask' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_Board' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_NntpServer' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_NntpForum' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_Category' because it is referenced by a FOREIGN KEY constraint.
Msg 3726, Level 16, State 1, Line 1
Could not drop object 'dbo.yaf_Forum' because it is referenced by a FOREIGN KEY constraint.
So I simply deleted the whole database and remade everything.
This time everything went okay when I installed.
Edited by user
13 years ago
|
Reason: Not specified