My Thoughts... Exactly!

Hey, you wanna know what I think?

Fixing a Blog

Comments have mysteriously disappeared.

But they still exist in the database.

The problem is due to an upgrade of a WordPress Plugin called Spam Karma. I have to use this plug-in or another to combat “Comment Spam” which is a huge problem for bloggers—unscrupulous people try to attract blog readers to sites that are usually disgusting by putting links in people’s comments which include keywords and URLs designed to increase popularity in Google searches.

At least 200
spam comments
everyday
Currently I get about 200 such comment spams a day, and fortunately Spam Karma catches them and keeps them from displaying, though I still have to regularly empty the “caught” spams—an unwelcome time-sink.

The new version of Spam Karma somehow set the “comment count” to zero for nearly all my posts, so I must go into the MySQL database and manually reset the count to the actual count for that post. A huge time-sink. And not a little scary.

It will take some time.

I found the answer to my problem here.

Update

I think I got it fixed. And it wasn’t as bad as I thought. The problem only needed to be corrected back as far as the date I installed the upgrade to WordPress which was 2 or 3 days ago—so I didn’t have to correct very many database records.

That having been said, I have to say that I have no idea what someone would do if they are not comfortable with nor do they have the ability to manipulate data in their MySQL database. My guess is that 95% or more of WordPress users do not know how to change data safely in their database, if at all.

I was walking on thin ice, myself, in doing so.

1 Comment

  1. Yeah, I saw the ZERO comments thing even after I’d entered some stuff… I figured maybe it was just a Firefox glitch or something so I didn’t mention it. Glad you got it fixed.

Leave a Reply