phpbb v3.3.11 - Delete User & Posts

[Edward572]

Hello Again,

I deleted a registered (e-mail confirmation) user that had posted like 6,000 posts while I wasn't watching for a few months. It deleted the user but crashed and left all the replies and spam posts. Now the user name is still on the board with posts, but the user is deleted. If I purge posts it will delete all my good posts as well. I wish I would have checked this board more often, and did weekly backups.

QUESTION 1. Is this a phpbb board issue, or did my sever at godaddy just crash before the board was done deleting posts?
(Now I guess delete them one by one, like 6,000 no way, feel like dumping the whole board and starting from scratch, what a mess.started 2010)

Question 2. in my db phpbb_login_attempts is like 49.7MB, and phpbb_sortable_confirms is like 89.1MB, can this be reduced, no current maximum for MySQL db on my sever, but is there a way to reduce or delete information, or why bother?

Their are a few registered and confirmed users that have spammed the S#&T out of the board, while not checking daily and post like 100-500 posts a day that will never delete, just the user goes and the spam stays...

Any ideas how to get rid of the SPAM easily, I guess I need moderators?

Cheers & Thanks,
Edward

PS: phpbb v3.3.11, php version 8.1

[KevC]

See How to clean up a board hit by spam for some suggestions.

You don't have to delete one by one necessarily.
You can click the MCP link at the top of any forum and select whole pages of topics to trash. It might take some time but it's doable. Assign forums to each moderator and tackle it together.

[Edward572]

Thanks,

I will try that as well, I've noticed that deleted user posts are ghost posts with the reply on original post with username deleted and a ghost reply, with no post actually there.

Thanks Again
Edward