Jump to content

How to mass delete Guest posts as comments on articles

Featured Replies

Posted

Not sure how / why but Guest posting was turned on for a while. 

Is there any way to delete Guest posts that on Pages Articles that were not stored in a Forum?

:(

 

  • Author

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. 

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.

Archived

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

Recently Browsing 0

  • No registered users viewing this page.