1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Soft delete all moderated posts (queries)

Useful for clearing out a backlog of moderated posts when you don't want to permanently delete them.

  1. Jake Bunce
    You can run these queries to soft delete all moderated posts. You need to change the red pieces to attribute these deletions to a user_id and username, as well as give the reason. These things are recorded in the deletion log:

    Code:
    INSERT INTO xf_deletion_log (content_type, content_id, delete_date, delete_user_id,...
    You do not have permission to view the full content of this resource.
    Afra, Valhalla, zzlovezz and 3 others like this.

Recent Reviews

  1. Ryan Hickman
    Ryan Hickman
    5/5,
    This works exactly as advertised and also includes the query to log the actions to the database. Would highly recommend for big boards requiring bulk moderation.
  2. dvsDave
    dvsDave
    5/5,
    Helped me clear over 600 entries out of my queue when I migrated. Very useful!