Posted by: doxa - Monday, 4 November 2013 14:36:56 |
---|
Hi, while upgrading 1.9.6 BETA 1 to YAF.NET v2.0 Final: FILE: mssql/constraints.sql ERROR: The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_dilliduduk_ForumReadTracking_dilliduduk_Forum". The conflict occurred in database "DilliDudukDB", table "dbo.dilliduduk_Forum", column 'ForumID'. STATEMENT: if not exists (select top 1 1 from sys.objects where name='FK_dilliduduk_ForumReadTracking_dilliduduk_Forum' and parent_object_id=object_id('[dbo].[dilliduduk_ForumReadTracking]') and type in (N'F')) alter table [dbo].[dilliduduk_ForumReadTracking] add constraint [FK_dilliduduk_ForumReadTracking_dilliduduk_Forum] foreign key (ForumID) references [dbo].[dilliduduk_Forum](ForumID) Do you have any idea what happened? *** I deleted from install/mssql/constraints.sql and it worked but, I don't know is it required to run because my forum is running perfectly. Line: 1150 if not exists (select top 1 1 from sys.objects where name='FK_{objectQualifier}ForumReadTracking_{objectQualifier}Forum' and parent_object_id=object_id('[{databaseOwner}].[{objectQualifier}ForumReadTracking]') and type in (N'F')) alter table [{databaseOwner}].[{objectQualifier}ForumReadTracking] add constraint [FK_{objectQualifier}ForumReadTracking_{objectQualifier}Forum] foreign key (ForumID) references [{databaseOwner}].[{objectQualifier}Forum](ForumID) go |