Tip: Fixing Post Comment Counts in WordPress

Two weeks ago I mentioned that I knew I was guilty of not paying much attention to my blog. You can choose to pretend you are handling your website, until you get hacked. That’s exactly what happened to me earlier this year. Sad thing is I didn’t even come to find out until about two months ago. How embarrassing.

If I wasn’t paying attention, how did I find out, you ask? I planned a sale on my jewelry website, only to find out it had been hacked. And so began my two month journey to remove/replace all the hacked code across my websites.

When I finally had a chance to start working on the jewelry website (because as is the plight of an independent contractor, clients come first always), I was able to migrate it from Textpattern to WordPress, but not without some trouble. The latest of which was fixing a discrepancy with post comment counts in WordPress.

I originally tried a few solutions, but myPHPAdmin was yelling at me… it didn’t like how the SQL was formatted for making the updates. Another quick search and I found this post: Reseting Post and Comment Count in WordPress by Ankur Banerjee. He wasn’t sure that it would function on everyone’s servers due to timeout settings, but it worked like a charm for me.

How about you out there porting from Textpattern to WordPress… What issues did you encounter that were not easily handled by the Textpattern importer plugin in WordPress?