I have quite a complex back office setup with lots of custom events, generally used to manipulate data. I had quite a few items in the trash can, So I deleted the items 1 by 1 but I am left with two items that I can not delete. Umbraco gives me this message..
The DELETE statement conflicted with the REFERENCE constraint "FK_umbracoAccess_umbracoNode_id2". The conflict occurred in database "umbraco_X", table "dbo.umbracoAccess", column 'noAccessNodeId'.
The statement has been terminated.
EXCEPTION DETAILS
System.Data.SqlClient.SqlException: The DELETE statement conflicted with the REFERENCE constraint "FK_umbracoAccess_umbracoNode_id2". The conflict occurred in database "umbraco_X", table "dbo.umbracoAccess", column 'noAccessNodeId'.
The statement has been terminated.
The reason why this is happening is obviously something to do with a reference in the umbraco db, but I don't understand why this would be the case, and the umbraco database schema is not easy to understand.
Has anyone got any ideas of why this might be happening?
Can't delete from trash
Hi guys,
I have quite a complex back office setup with lots of custom events, generally used to manipulate data. I had quite a few items in the trash can, So I deleted the items 1 by 1 but I am left with two items that I can not delete. Umbraco gives me this message..
The reason why this is happening is obviously something to do with a reference in the umbraco db, but I don't understand why this would be the case, and the umbraco database schema is not easy to understand.
Has anyone got any ideas of why this might be happening?
Tried it again today... and I can delete those nodes...
Would really like to know why I couldn't delete it before
Any ideas?
is working on a reply...