Delete Multiple Comments At Once?

Is there an easy way to delete multiple comments and reviews ? we have hundreds of spam comments to delete. One at a time is crazy!

You can do it in the DB if you know the User_id and the thread_id you are wanting to delete from.

Or you can delete all user_id == 0 posts if you allow anonymous users to post reviews.

Thanks! I have thousands of comments, the google captcha was not setup properly. I was able to go into the test (copy) site and empty the table cscart_discussion_messages (all is junk, no need to save anyting) but I'm not sure if i also have to delete anything from any of the other discussion tables? Is there any detriment to only emptying the cscart_discussion_messages table?

Also, do you happen to know of a way to give ALL administrators access to the Website/Comments & Reviews to manage approvals?

Also, do you happen to know of a way to give ALL administrators access to the Website/Comments & Reviews to manage approvals?

Never mind, I found it in the privileges section of the group, thanks.

There are 3 tables that are linked together via keys

discussion

discussion_messages

discussion_posts

Just truncating the messages table may cause a lot of errors.

Suggest you write a small sql command that will identify the thread_id of each row in discussion_messages and remove the corresponding items in discussion and discussion_posts.

Thank you, Tony!