Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
1. Recycle Bin
1.1 Page
1.1.1 SubPage
1.1.1.1 SubSubPage
1.1.1.2 Copy of SubSubPage
...
That means if you try to delete "1.1 Page" you will most likely get the SQL exception. If you first delete "1.1.1 SubPage" the error will not appear.
Hope that will help...
DELETE statement conflicted with COLUMN SAME TABLE REFERENCE constraint 'FK_tblPage_tblPage'. The conflict occurred in database 'myDB', table 'tblPage', column 'fkParentID'.
When deleting the pages one by one the problem doesn't appear, but it's quite tedious when there are several hundreds of them.