Announcement

Collapse
No announcement yet.

SQL query for deleting posts? (want to use to mass delete posts)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • SQL query for deleting posts? (want to use to mass delete posts)

    I have to delete a few hundred posts due to some defamation legal issue between posters. I've been given URLs to the individual posts, which i can easily extract a list of post numbers from.

    What's the SQL query used to delete a post? I don't know if I can just delete from the post table by postid, or if that would cause bugs with other things (like searching) and more is required.

  • #2
    There is not a simple query to delete posts because there are joined records to consider. You should use the pruning feature:

    Admin CP -> Threads & Posts -> Prune

    If you can't match the desired posts with the criteria on that page then you will need to delete them manually on the front end.

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X