Calling all developers! We invite you to provide your input on Feature Experimentation by completing this brief survey.
AI OnAI Off
SQL exception when emptying recycle bin
I've investigated som more and the problem seems always to occure when a subpage contains pages that where copied using the copy/paste function.
As soon as I delete this subpage the error disappears.
#18399
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...
Sep 01, 2006 11:42
Hi René,
I’m trying to reconstruct your problem by doing the following
1) Create "page" in "Recycle bin"
2) Create "subpage" as a sub page for page
3) Create "subsubpage" as a sub page for “subpage”
4) Copy the "subsubpage" to the “subpage”
and get the structure
Recycle bin
page
subpage
subsubpage
subsubpage
5) Delete the "subpage"
Everything works fine!
Is it some thing that I’m missing, from witch version do you have upgrade from, are you using Multilanguage support?
Best regards,
Mattias Lövström
#18400
Sep 04, 2006 13:40
The error does not appear if you delete subpage but if you delete page.
The "Copy"-theory is just an assumption because pages causing this problem where created that way.
Multilanguage ist not activated and the sites are 4.60 installations upgraded to 4.61.
#18401
Sep 06, 2006 14:07
I can’t still reproduce your problem, but the "Copy"-theory is a very strong candidate because we have a bug in the 4.60 and 4.61 copy functionality that corrupts the page tree, and the emptying of the recycle bin uses the page tree.
I have requested that this fix will be included in hotfix 1 for the 4.61.
Regards,
Mattias Lövström
#18402
Sep 07, 2006 8:26
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.