We have moved to GitHub Issues
Created by Anders Brannmark 08 Apr 2013, 09:53:59 Updated by Sam 15 May 2015, 14:13:06
Is duplicated by: U4-2125
Seams like there is a bug in v6.0.3 that makes the path corrupt when deleteing an item with many decendants.
Have a content tree that looks like this: *Content root ** Catalog *** Product category **** Product ***** Variant
Deletion of the product category results in that the variant gets the wrong path. See attached screenshoot. When the varinat doesnt get -20 in the path empty recyclebin crashes due to constraints as contentservice does this filter:
var query = Query
Has this site been upgraded from 4.11.4 or earlier by any chance?
Its upgraded from a 4.9. Have run fixup path tool. But the nodes above was created after upgrade also.
Also database was started with a blank 6.0.3 database.
I'm seeing issues here as well. Fresh 6.0.3 install and database. Deleting an item with descendants and trying to empty the recycle bin will cause a 500 Server Error -> "The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "U6", table "dbo.umbracoNode", column 'parentID'. The statement has been terminated.". For now, a workaround is to simply right click the item and delete it. I recorded a quick screen cast to show it -> http://screencast.com/t/wSE5lrDJGWQ
Can confirm I am also getting the following error. This is the error shown in chrome when I try to empty the trash.
Sys.Net.WebServiceFailedException: Sys.Net.WebServiceFailedException: The server method 'EmptyTrashcan' failed with the following error: System.Data.SqlClient.SqlException-- The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_umbracoNode_umbracoNode_id". The conflict occurred in database "CLIENTNAMEREMOVED", table "dbo.umbracoNode", column 'parentID'. The statement has been terminated. [http://localhost:13893/ScriptResource.axd?d=ELbyFT1WV0dv2AHeEOpC6UfeJkk6to6cYtPcmjCRQRKBtzkER3_fIDnONRAL_nL443uJdjXHauNw3APL9qVRCdxfPT1KUgAqdneL22FLRbeMiX7ZLJRBI2Hp0r2D0TTE9iDXWY29RTeNt4iiBIJsrSuoaSmZedNu8TheNDKI65qZTiqv7ELxChtOIuZrs_tl0&t=6119e399:6965]
Fixed in changeset 84644bda46ba for both Content and Media.
I'm seeing this in 6.1.6 still.
I am seeing this in 7.1.7 as well. https://db.tt/iiuXo0uF
Assignee: Morten Christensen
Backwards Compatible: True
Affected versions: 6.0.3
Due in version: 6.0.4