There was spammer who used a bot to post 1500 posts on my forum. Whenever I try to delete a users posts with over 200 posts or so, I just get an error, so I tried deleting the user in Admin CP but it left his posts. When I search for the user, it does not return his posts. His posts appear like a guest made them now.
How can I delete
Run this query in phpMyAdmin:
DELETE FROM mybb_posts WHERE username='his username'
and
DELETE FROM mybb_threads WHERE username='his username'
In the future, here's a useful plugin:
http://mods.mybb.com/view/goodbye-spammer
There are 3 ways I can think of.
1) Delete them from database as Paul H. said above.
2) Use a plugin like GoodBye Spammer.
3) Delete his posts/threads before actually deleting him (might be slow and take a while though).
Downloaded the plugin, and used the phpMyAdmin query, thank-you.