www.lewiz.org

I finally got around to upgrading my blog to the latest and greatest version of WordPress… 2.2 right now.

At the same time I switched away from the WordPress HashCash plugin I was using to prevent comment spam.  It’s actually done me pretty well over the last year or so.  I do get the odd spam comment, but nothing is perfect.

Where wp-hashcash has failed me though is in keeping the comment count associated with each blog post up-to-date.  For example, five minutes ago WordPress thought somebody had left a comment on my post about a new keyboard… I believe this to be a side effect of rejected spam comments.

Here’s a quick fix for the problem:

update posts set comment_count=(select count(*) from comments where comment_post_id=id);

Very quick, very simple.  Amazingly the stats on my WordPress database were not all that encouraging:

Query OK, 395 rows affected (0.06 sec)
Rows matched: 926  Changed: 395  Warnings: 0

So 395 of my blog posts had the wrong comment count… ouch!

Tags: Website

This entry was posted on Saturday, June 16th, 2007 at 6:12 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.