Clear all

Spammed moderation section

3 Posts
2 Users
Posts: 9
Topic starter
Active Member
Joined: 1 month ago

So I've got my forum flooded with spam and there was just an option to delete the account with all of their comments, but WP just crashed - the user was deleted but the comments stayed. I've had several occurrences of this

Is there any way to delete the 60k comments other than manually? I might actually go insane 

2 Replies
Posts: 9979
Support Team
Joined: 7 years ago

Hi @oleksiitwenty,

I don't see reCAPTCHA on your registration form. First, please make sure your forum is protected as much as possible. Here are some tips:


You can delete topics and posts in Dashboard > wpForo > Moderation admin page, click the [published] tab to see them. Change the number of items in the top Screen Settings


You can also use SQL commands like:

DELETE FROM `wp_wpforo_posts` WHERE `userid` = X;

DELETE FROM `wp_wpforo_topics` WHERE `userid` = X;

SQLs can be sued in phpMyAdmin plugin or in the same tool of your cPanel.

G to your database, make sure the table prefix is correct, "wp_".

Browse wp_wpforo_posts table and find the spammer userid and replace X in the SQL commands with that userid. Then execute the commands.

Posts: 9
Topic starter
Active Member
Joined: 1 month ago

@robert Thanks for the help - previously I was doing it manually using the 1st method that you suggested - Although the maximum number of posts I can have on a page before it crashes when I try to delete them is 200, the maximum is 999.

I'm afraid I'm not educated enough to perform the 2nd method