How To Diagnose And Fix Incorrect Post Comment Counts In WordPress
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
…
How To Show Hidden/Invisible Files In Total Commander, Both Locally And On An FTP Server
Today I have 2 tips for Total Commander users:
- how to display hidden local directories and files and
- how to display hidden FTP directories and files
Really, Total Commander should just control this setting in one place but, unfortunately, it is not the case.
I usually prefer when my file manager shows me everything I have, so that I can be more in control and see the hidden directories, such as .svn or $Recycle.Bin, and files, such as .bashrc or pagefile.sys.
How To Display Hidden Local Directories And Files
- go to Configuration -> Options… -> Display
- put a check next to the "Show hidden/system files (for experts only)"
How To Display Hidden FTP Directories And Files
This one is a …
The Most Awesome VPN Tip: How To Make Windows Automatically Use Your Local WiFi/LAN Connection Directly For Requests That Don't Need To Go Through VPN
This tip can also be filed in the "post with the longest title that kind of makes sense but needs more explanation" category.
If you use a VPN (Virtual Private Network), this tip is for you.
The Problem
- you connect to a VPN to get access to your work/whatever network
- your connection is fast but the VPN connection is balls slow
- you try to stream a bit of online radio, go to a website, watch a video, or do anything, which is automatically routed through the VPN connection but everything TAKES AGES because the VPN connection is the limiting factor
- so not only are you frustrated by hiccupping radio, stuttering video, and a never disappearing progress bar but you're
…
beer planet is a blog about technology, programming, computers, and geek life. It is run by Artem Russakovskii - a local San Francisco geek who is currently pursuing his own projects and regularly enjoys hacking Android, PHP, CSS, Javascript, AJAX, Perl, and regular expressions, working on Wordpress plugins and tools, tweaking MySQL queries and server settings, administering Linux machines, blogging, learning new things, and other geeky stuff.
