Hello,
I understand K2 is very much used by Gavick Pro, but for now, I stick more to the basic but very versatile Joomla modules created by Gavick. Thus, usually I unpublished most of the K2 modules, and trash all the demo K2 articles (which now comprise most of the demo articles in the templates).
What happened though is that the K2 comment is very vulnerable, and has been saddled with spam in one site, even if it was unpublished from the beginning. I trashed all the K2 articles after installation. When I dropped the k2 comment module, it destroyed the site. And worked only after it was replaced taken from a clean source. But, once restored, in just a few hours, more than a million comments built up again. Trashing all the K2 modules and some undetected K2 articles did not help either. Comments build up in the database quite fast.
Fortunately, not all the sites are affected. I will install some anti-spam and possibly CAPCHA extensions, but for now, I would rather not have K2 modules in my sites
So, through the phpMyAdmin, how do I remove most if not all of the K2 modules (in the database tables) without destroying the site?
Cornelio