4874 Spam Comments
I just deleted 4874 spam comments from the database. Wordpress crawled under the table and whimpered when I tried to use the normal interface, so I had to use PhpMyAdmin and figure out the database layout. Fortunately it wasn’t hard.
DELETE FROM `wp_comments` WHERE `comment_approved` = ‘0′
did the trick. I have now activated Akismet.
JohnJo said:
Apr 14, 07 at 11:26 amYou were wise to activate Akismet. It works brilliantly.
Dan said:
May 17, 07 at 4:20 pmYep. It’s already caught 1800 spam comments for me.
Dan said:
May 17, 07 at 4:38 pmMake that 5500.
Gavin Ayling said:
May 23, 07 at 7:53 pmThat is quite a few comments… Oh, and since when did you start blogging again Mr?