Standard Mischief

I got a bug in the system way back when I first installed WordPress 2.0.1

People could leave comments OK, and those comments displayed OK, but when there was a overview of the posts, the comment count was displayed wrong.

This problem followed me through several upgrades. Finally I decided to do a fresh install. Well that didn’t fix things, but I noticed that Spam Karma 2 (hereafter SK2) was no longer bundled with WordPress. I got the latest version and installed it, but I still had problems. At that point I returned to searching my problems in the WordPress forums.

I finally found the problem. There was a big bug in the version of SK2 bundled with WordPress 2.0.1, so the upgrade actually did fix the problem, at least on any future comments. I had Spam Karma 2.0 Final r2 installed. The one you need to upgrade to is currently Spam Karma version 2.2 r3.

To fix older posts you have two known options:

1) Go into the database and do it by hand (yes, that’s slow and you do need to know how to stumble around in mySQLadmin) Specifically wp_posts in the field comment_count category.

or

2) Go to every post that has the wrong comment count, and add a comment. When the new SK2 approves it, the total proper count will be corrected. You could then erase that comment, count should then decrement OK.

Yea, both of those options suck. Sorry, that’s the best I can do. Oh and I really wish that Dr. Dave would splash this all over his home page. I have months of posts that I now need to fix by hand.

Still, to put this in perspective, the only reason comments are open is because of this plug-in. I wouldn’t be blogging without it.

Images from the old blog are still missing, and the template needs fooling with, but things seem to be working OK in the comments department. I’ll have those restored soon.