Mass delete spam comments, threads

[jcomeauictx]

I've got a ton of unwanted threads posted by a spammer. How do I mass delete them and prevent it from happening again?

Thanks

I just had this problem, hundreds of new users with hundreds of spam messages (about 1 per user). I found a pattern to the email addresses, there were about 5 primary domains in use. so I enabled maintenance mode, and from root on the server, I did:

su - postgres
psql smf
delete from smf_members where email_address like '%.fusdren.com';
delete from smf_messages where poster_email like '%.fusdren.com';

and repeated the last two lines for each domain.

it could have caused some problems, but if so we haven't noticed them yet.

[Kindred]

yes... that will cause problems.

You should NEVER delete things directly in the database. Really. Just don't do it.

There are interconnected tables and columns... which are now broken in your case.