Delete a ton of stuff
vuuch - September 28, 2009 - 15:26
I have about 800 pages of junk comments that I want to delete so 800*50=40,000 comments. I had turned on comments and got spammed... They are all from an anonymous user. How can I delete all these in one step? I looked at the module delete all but it is not working with 6.X
More info
I was just poking around more relative to the spam I got and it is worse than I thought. I have 40,000 pages and these pages have comments. Actually I have 3,000 pages of comments - so I have 30,000*50= 150,000 comments to delete and 40,000 page nodes to delete. Please help with a way to do this. Thanks.
Perhaps a Views with Views
Perhaps a Views with Views Bulk Operations. If you can create a view to filter a list to show the content you want to delete, then with VBO you can easily remove them.
Complete Computer Care
Thanks
Hey that is a great way of doing it. I expected Views to do this out of the box but they do not. I ended up just doing this at the DB level with SQL. I think I did it correct, I hope...