Artem Russakovskii's programming and technology blog

Updated: May 17th, 2012

Well, this one took ages. And whenever something takes me ages, rather than write it down in my personal notes, I prefer to put it out online for everyone with the same problem to easily find and benefit from.

The problem I'm talking about today is trying to upgrade your Windows 7 installation to SP1 by applying Microsoft's update KB976932, called "Windows 7 Service Pack 1 for x64-based Systems" and getting nothing but a failure every time. The same problem may affect 32-bit systems as well, and I'm not sure what the update number for that would be, but the solution should work for either one.

The update starts just fine, chugs along for 10 minutes or so, then reboots …

Updated: September 16th, 2012

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 in the wp_posts table, rather than getting calculated on every page load.
  If this count ever gets out of sync with

…

Read the rest of this article »

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 immediately noticed the broken application icons (issue #4 on my bug list) fixed. The phone seems is definitely quite a …

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 SimplifyMedia on it and listen to some tracks in my favorite music player Winamp. However, after I downloaded and installed it and …