Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Delete Multiple Comments At Once? Rate Topic   - - - - -

 
  • susanpaz
  • Advanced Member
  • Members
  • Join Date: 10-Jun 15
  • 91 posts

Posted 23 May 2017 - 05:38 PM #1

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!



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12040 posts

Posted 23 May 2017 - 10:54 PM #2

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.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • susanpaz
  • Advanced Member
  • Members
  • Join Date: 10-Jun 15
  • 91 posts

Posted 24 May 2017 - 04:20 PM #3

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?



 
  • susanpaz
  • Advanced Member
  • Members
  • Join Date: 10-Jun 15
  • 91 posts

Posted 24 May 2017 - 04:24 PM #4

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



 
  • susanpaz
  • Advanced Member
  • Members
  • Join Date: 10-Jun 15
  • 91 posts

Posted 24 May 2017 - 06:56 PM #5

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.



 
  • tbirnseth
  • CS Cart Expert
  • Authorized Reseller
  • Join Date: 08-Nov 08
  • 12040 posts

Posted 24 May 2017 - 07:15 PM #6

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.


EZ Merchant Solutions: Custom (USA based) B2B Development, Consulting, Development and Special Projects (get a quote here).
Commercial addons, payment methods and modifications to meet your business and operations needs.


 
  • susanpaz
  • Advanced Member
  • Members
  • Join Date: 10-Jun 15
  • 91 posts

Posted 25 May 2017 - 06:51 PM #7

Thank you, Tony!