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?
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.
Was a solution found for this? Could you please update for others? Thanks.
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.
Please, sign in to be able to submit a new answer.