Running in to problems upgrading Kentico 5.5R2 to 6.0

Dylan McDonald asked on July 22, 2014 19:53

Hello, SQL upgrade script throws an error:

The DELETE statement conflicted with the REFERENCE constraint "FK_CMS_RolePermission_PermissionID_CMS_Permission". The conflict occurred in database "mncee_upgr5_5", table "dbo.CMS_RolePermission", column 'PermissionID'.

I can't seem to find a solution for this. Can this be ignored?

Thank you,

Alex

sql error v6 upgrade

Recent Answers

Roman Koníček answered on August 4, 2014 00:43

Hi,

Just update for others - I was not able to reproduce the issue using my database and since Alex has a valid maintainance, I have asked him for a backup of his database and our conversation continues via e-mails.

Best regards, Roman Konicek

0 votesVote for this answer Mark as a Correct answer

Joel Dahlin answered on August 20, 2014 06:59

Was a solution found for this? Could you please update for others? Thanks.

0 votesVote for this answer Mark as a Correct answer

Filip Ligač answered on October 5, 2014 13:55 (last edited on October 5, 2014 13:58)

Hi Joel,

The bottom line was Alex's database was a little inconsistent and he ended up removing the "FK_CMS_RolePermission_PermissionID_CMS_Permission" foreign key before applying the SQL upgrade script and adding it back after executing it. Even though this step should not be necessary for standard 5.5R2 databases, it helped him run the script successfully.

0 votesVote for this answer Mark as a Correct answer