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?

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.

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

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.