How To Diagnose And Fix Incorrect Post Comment Counts In WordPress
Updated: August 8th, 2010

Introduction
If your WordPress comment counts got messed up, whether because of a plugin (I'm talking about you, DISQUS) or you messed with your database manually and did something wrong (yup, that's what I just did), fear not – I have a solution for you.
But first, a little background.
Comment Counts In WordPress
Here's how comment counts work in WP:
- Posts live in a table called wp_posts and each has an ID.
- Comments reside in a table called wp_comments, each referring to an ID in wp_posts.
- However, to make queries faster, the comment count is also cached
…
Sprint And HTC Release The First HTC Hero Firmware Update 1.56: Fixes Major Bugs, Adds Small Tweaks
Only 2 days after I posted the list of problems with my HTC Hero (The Not So Good, The Bad, And The Ugly: My List Of 20+ Problems With HTC Hero) Sprint and HTC released the first firmware update.
The Update
To update your Hero, go to Settings->About phone->System updates->Firmware update.
The update took about 10 minutes to install, weighed 3.7MB or so, and rebooted the phone twice – once to install and once to reboot after the installation, so make sure you don't need to make any important phone calls during that time.
After the update, I…
Is Your Simplifymedia For Winamp Broken On A 64 Bit Windows 7? Here's How To Fix It
SimplifyMedia is an extremely useful program, which allows super easy song and playlist sharing via streaming between multiple computers. It also works as a Winamp plugin, so the shared songs simply show up inside Winamp's own media library – each computer sharing music appears under the special "Shared" tab. And the beauty is – there is no need to muck around with network settings, open ports, or even touch your router.
Here's a screenshot of how it's supposed to work:
![]()
The Problem
Since I recently installed Windows 7 64bit on my laptop, I wanted to set up…


beer planet is a blog about technology, programming, computers, and geek life. It is run by Artem Russakovskii - a local San Francisco geek who currently works at