HenryMan
  •  HenryMan
  • 50.2% (Neutral)
  • YAF Forumling Topic Starter
2012-08-22T07:37:32Z
Hello
I decided to upgrade my forum from 1.9.3 running under Sql 2000 to the latest svn under SQL 2005 SP4 and I was not successful due to an error.
Steps I followed was :
1-backing up DB in SQL2000
2-restoring to SQL2005
3-Setting compatibility level to SQL2005
4-Running YAF through Installation procedures
5-General error page
6-Setting web.config to debug mode

Error:
ERROR:
The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "FK_yaf_UserMedal_yaf_User". The conflict occurred in database "yafnet", table "dbo.yaf_User", column 'UserID'.

Any idea?
Sponsor
bbobb
  •  bbobb
  • 100% (Exalted)
  • YAF Developer
2012-08-22T12:25:50Z
Try this before update.
DELETE from yaf_UserMedal where UserID NOT IN (select UserID from dbo.yaf_User)
If it works it should be added to YAF a bit changed for perfomance.
HenryMan
  •  HenryMan
  • 50.2% (Neutral)
  • YAF Forumling Topic Starter
2012-08-22T14:42:15Z
Originally Posted by: bbobb 

Try this before update.
DELETE from yaf_UserMedal where UserID NOT IN (select UserID from dbo.yaf_User)
If it works it should be added to YAF a bit changed for perfomance.



Thanks for reply.
Yes it worked and upgrade procedures went fine.

Once again Thanks

Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2012-08-23T03:11:14Z
Originally Posted by: bbobb 

Try this before update.
DELETE from yaf_UserMedal where UserID NOT IN (select UserID from dbo.yaf_User)
If it works it should be added to YAF a bit changed for perfomance.



Can you add this bbobb? Thanks.

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved