IMPORTANT MESSAGE REGARDING THE FORUM

As you may already know, the JoomlaWorks Forum is powered by Kunena (the only decent forum component for Joomla).

Unfortunately, the latest update for Kunena has seemingly broken all code snippets (old and new) in the forum.

Until this message is removed, please paste any code as regular text - in other words, don't use the [code]...[/code] tags in Kunena's post editor.

Keyword

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

  • Luis Bango
  • Luis Bango's Avatar Topic Author
  • Offline
  • New Member
More
4 weeks 1 day ago #179402 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 weeks 13 hours ago #179448 by Fotis
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.

IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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

  • Luis Bango
  • Luis Bango's Avatar Topic Author
  • Offline
  • New Member
More
3 weeks 12 hours ago #179450 by Luis Bango
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 weeks 11 hours ago #179460 by Fotis
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.

IMPORTANT: Please search the forum before posting a question!

JoomlaWorks Support Team Member

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


Powered by Kunena Forum