Limited Support
Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.
We appreciate your patience and understanding while our team is away. Thank you for being part of the wpForo community!
Merry Christmas and Happy Holidays! 🎄
Hi,
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
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: https://wpforo.com/community/faq/how-to-stop-spam/#post-39862
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.
@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
