My forum was hit with a massive amount of spam over the past couple of days. Hundreds of users registered and posted 2-5,000 threads despite activating the reCapthca option instead of my regular questions and answers.
My problem is, when I click the spam cleaner to remove these posts it sits there for about 45 seconds and doesn't seem to do anything.
Yeah the request is timing out. After looking at some, a few of the users have over 7,000 posts. Is there an sql I could use to show users with more than 1000 posts and remove them and their content? If I can't remove all of this I'll be forced to shut the forum down
The batch update threads is a timed based batch system, so it shouldn't be timing out. There is a configuration variable you can use to set it to be lower than it currently is, but I don't have the name off hand right now (it should be in the manual).