Keyword

Delete all comments

  • Emily Bunting
  • Emily Bunting's Avatar Topic Author
  • Offline
  • New Member
More
4 years 9 months ago #174880 by Emily Bunting
Delete all comments was created by Emily Bunting
I have just realised I had comments enabled on some K2 posts, there have been 162k spam comments since 2015 - so I have quite a lot of deleting to do! I've read that you can delete all the K2 comments within the back end K2 comments file, but the post was from about 9 years ago and did not have any clear instructions. Can anyone help with this?

Please Log in or Create an account to join the conversation.

More
4 years 9 months ago #174882 by JoomlaWorks
Replied by JoomlaWorks on topic Delete all comments
If the comments are unpublished, there's an option to "delete all unpublished comments" in the K2 backend > Comments.

If the comments are published, you need to empty the #prefix_k2_comments table using a tool like phpMyAdmin. Do you know how to do that?

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.

  • Emily Bunting
  • Emily Bunting's Avatar Topic Author
  • Offline
  • New Member
More
4 years 9 months ago #174883 by Emily Bunting
Replied by Emily Bunting on topic Delete all comments
Hi there,
Unfortunately they are all published!! I do not know how to use phpMyAdmin - do you have some tips? If not, I'll take a look at their documentation.

Please Log in or Create an account to join the conversation.

More
4 years 9 months ago #174886 by JoomlaWorks
Replied by JoomlaWorks on topic Delete all comments
Ironically, there's a great guide on wordpress.org :)

wordpress.org/support/article/emptying-a-database-table/

You need to empty the table XYZ_k2_comments where XYZ is your actual database prefix, usually a 3-4 alphanumeric string.

Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

Please Log in or Create an account to join the conversation.


Powered by Kunena Forum