Troubleshooting

I’ve been having a bit of trouble with my hosting provider — first, of course, there was that ill-timed and unannounced bit of downtime last week, which I can’t be too upset with them about, given that their presence somewhere in SoCal may have been under the same kind of threat that mine was. But then there was another crash night before last, and when they brought the site back up, we’d entered a bit of a time-warp: the .php pages for the site as it was supposed to exist at that moment were still there, no problem, but MT’s Berkeley DB had reverted to its state as of 26 October.

What follows is even more arcane than that, so I’m going to take this inside.

I e-mailed my support folks, who didn’t respond, and didn’t respond, and then finally apparently fixed whatever it was that had hosed the DB, because when I logged into MT, the entries that had gone missing were back.

Great. But I noticed that my referrer logs — I’m running Dean Allen’s Refer — were no longer functional; when I attempt to load them (at http://www.plannedobsolescence.net/blog/refer[UPDATE, 5.27.04: post-site-migration, no longer in service], I get the following error message:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/virtual/site12/fst/var/www/html/refer/display.php on line 264

Now, this has all been thoroughly functional for months. And I’m completely ignorant when it comes to MySQL — were it not for Dean’s tools, I’d be unlikely to have gone near it. So I can’t figure out what could have gone wrong here. I’ve logged into my site admin tools, and my MySQL database appears to be perfectly functional; it’s just the display that’s gone wonky. It seems to me it’s got to be something that happened in the crash, but I haven’t a clue what it could be. I’ve e-mailed my good support folks, who are once again not responding.

If any of you have any ideas, I’d be most thankful. It’s funny: when Shelley threw down the gauntlet — “I challenge you to not to check your referrers or your ranks for the next week, and see when you start sweating” — I piffled at the thought. Me, addicted to my referrer log? Not likely.

Anyone who can help me get it fixed (ahem) will be my new best friend.

4 thoughts on “Troubleshooting

  1. I don’t know this script, but the error is familiar to me. You have a bad SQL statment that you are sending to mysql_query(). When that fails it sends FALSE to mysql_num_rows(), which it can’t understand and says “not a valid MySQL result resource”.

    Now what to do about it. Again I don’t know this script at all, but I would suggest that you use PHP-MySQL Admin and check the database schema, perhaps something is screwed up there, like missing tables/fields.

  2. Aha. Poking at the database, it looks like referrers have not been recorded since 26 October… suggesting that this DB also got restored, post-2 November hosing, to an old state. I’ll e-mail the support folks again and see if they can do something…

  3. Whew. Whatever the problem was, the powers that be have fixed (ahem) it. Now I need not confront my demons, or at least not anytime soon.

Leave a Reply

Your email address will not be published. Required fields are marked *