Jump to content

How to mass delete Guest posts as comments on articles


socceronly

Recommended Posts

5 hours ago, socceronly said:

Is there a way to simply delete all comments from a Database.   

It must in the thousands of posts, can't delete them manually.

Have to through out them all. 

To delete all the posts made by guests in your forum run this sql query.

DELETE FROM `forums_posts` WHERE author_id = 0 AND new_topic = 0;

But first make a backup of the forums_table table. And if you are using a prefix for your tables, add it to the table name in the above query when you run it.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...