Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Ayo Adesina 419 posts 1001 karma points
    Feb 08, 2017 @ 16:08
    Ayo Adesina
    0

    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 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?

  • Ayo Adesina 419 posts 1001 karma points
    Feb 09, 2017 @ 16:16
    Ayo Adesina
    0

    Tried it again today... and I can delete those nodes...

    Would really like to know why I couldn't delete it before

    Any ideas?

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies