Copied to clipboard

Flag this post as spam?

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


  • Ulrik Nedergaard 44 posts 175 karma points
    Jan 21, 2022 @ 13:33
    Ulrik Nedergaard
    2

    Delete node manually in database

    I would like to delete some corrupted nodes manually by doing it directly in the database, because they give me problems in the backend, and I'm looking for a SQL query to do just that.

    Like mentioned here in this old post, but for v8 and not v4. The table structure has changed

    https://our.umbraco.com/forum/developers/api-questions/19620-delete-nodes-from-database

  • Arun 141 posts 394 karma points
    Apr 12, 2022 @ 14:59
    Arun
    1

    Hi
    What I have done is just executed this query

    UPDATE [umbracoNode]  
    SET parentNode=-20, level = 1,trashed=1
    WHERE id= Node id i want to remove

    Not sure whether better ways are there but, this solved my need,
    Thanks

Please Sign in or register to post replies

Write your reply to:

Draft