April 2012 Issue

Semper Ubi Sub Ubi


Well, that was fun.

Back in the first week of April, I was putting together this issue when I noticed that some comments needed approving. So I started combing through them as usual, approving the sane ones and nuking the spam, when I noticed that one of the less coherent spam comments could not be deleted. As they say on Law & Order, DUM dum. That ain’t right.

So I decide to think on it for a while (which is my response to almost every crisis that doesn’t involve either loaded weapons or the fire department) and went back to updating the site. Which is when I noticed that the entire site had suddenly gone bananas. Password-protected subscriber-only posts were appearing on the front page (not good), the Ask a Question page was non-functional (really bad), and the Index of one zillion pages suddenly consisted of just two entries, both in the category of “Odds & Ends.” Boy howdy. OK, now I’m freaking out.

You may not know this, but when you read a blog or other site running on WordPress, what you’re seeing is actually data pulled from a separate MySQL database. Everything on this site — posts, comments, categories, dates, etc. — is data in tables in that database. So evidently My Little Database is borked. No problemo! I have site backups created every day by a plugin and stashed elsewhere in my hosting account at Pair.com. I’ll just fire up the old FTP program, fetch them and restore the whole shebang. Uh, no. Apparently the permissions on that target directory got changed at some point and all my backups since March 2011 have been sliding straight into the bit-bucket. They don’t exist. It is now 3 am and I am seriously starting to freak.

So I write to support at Pair.com. And they answer about five minutes later. At 3:30 am! I love Pair. They say they have a backup, but it’s a general server backup, so no guarantees. And, in fact, it makes things worse. So I go back to square one, install the latest version of WP, restore the site to what it was a year ago, and start manually editing the database.

As it stands now, the site contains everything it should, but there are gaps in its memory (sounds familiar). If you’re looking for a particular word or phrase, the search box at the top of the left column is probably the best way to find it. I’m going to keep working on it. As to how all this happened, I don’t know. It may have been a botched hack (I was using a version of WP that apparently had vulnerabilities) or it could have just been a toxic conflict between two of the dozen or so plugins that I use to make the site run. Part of my problem is that I’ve been tinkering and adding things for years, and I am no longer sure just how everything works. As to why this all took so long to sorta-fix, it’s because my eyes have been on the fritz lately, making it hard to see much of anything.

Anyway, we’re up and running, at least. This issue is a bit short, but I will do my best to produce a proper May issue withing the next two weeks. If you’d like to boost my morale, you might consider subscribing.

And now, on with the show.

Page 1 of 2 | Next page