YAFLogo

doxa
  • doxa
  • 100% (Exalted)
  • YAF All-the-Time Topic Starter YAF Version: 3.1.14
11 years ago
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


Sponsor