COMMUNITY FORUM

Keyword
  1. Forum
  3. K2 Community Forum
  5. English K2 Community
  7. Deleting loads of Spam comments - Can't find K2 Comments in phpMyAdmin

Deleting loads of Spam comments - Can't find K2 Comments in phpMyAdmin

  • Luis Bango
  • Luis Bango's Avatar Topic Author
  • Offline
  • New Member
More
3 years 2 months ago #179402 by Luis Bango
Deleting loads of Spam comments - Can't find K2 Comments in phpMyAdmin was created by Luis Bango
Hi folks,
I made the mistake of not disabling K2 comments and now I have thousands of spam comments that I need to delete.
I'm trying to find the K2_comments table in phpMyAdmin and can't find it anywhere after scouring for a long time.

Can someone identify the location?  I've attached a screenshot of my tables below.
thank you

Luis in Vermont



 
Attachments:

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

More
3 years 2 months ago #179448 by JoomlaWorks
Replied by JoomlaWorks on topic Deleting loads of Spam comments - Can't find K2 Comments in phpMyAdmin
These are the databases. Find the actual database that your site is using and then locate the xyz_k2_comments table (replace xyz with your actual database prefix). Truncate that table and you're done.
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  • Luis Bango
  • Luis Bango's Avatar Topic Author
  • Offline
  • New Member
More
3 years 2 months ago #179450 by Luis Bango
Replied by Luis Bango on topic Deleting loads of Spam comments - Can't find K2 Comments in phpMyAdmin
Thanks Fotis.
I've searched high and low with no success. I'll give it another try.
Should the K2 tables be within the Joomla dB?

thanks,
Luis

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

More
3 years 2 months ago #179460 by JoomlaWorks
Replied by JoomlaWorks on topic Deleting loads of Spam comments - Can't find K2 Comments in phpMyAdmin
Yes, of course. You need to click on the database that corresponds to your site. IN THERE you'll find the relevant xyz_k2_comments table to truncate.
Fotis / JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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

  1. Forum
  3. K2 Community Forum
  5. English K2 Community
  7. Deleting loads of Spam comments - Can't find K2 Comments in phpMyAdmin

Powered by Kunena Forum