Friday, 23 November 2018

Remove Spam Comments from K2 component

Remove Spam Comments from K2 component


  1. Navigate to PHPMyadmin
  2. Select your Joomla database from the drop down
  3. Make a backup of the database (always safer than sorry!)
  4. Navigate to the k2_comments table in your database. Depending on your custom prefix, it may look something like: ag3w_k2_comments
  5. Click on the SQL tab
  6. Replace "yourprefix" below with your databases prefix, copy it into the text field then run the query below by clicking GO


DELETE FROM yourprefix_k2_comments WHERE id > 1

No comments:

Post a Comment