Limited Support
Our team is currently on holiday, so support will be limited during this period. Response times may be slower than usual, and some inquiries may be delayed.
We appreciate your patience and understanding, and we’ll resume our usual support by the end of August.
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
