kfitz

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://kfitz.info/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.

Webmentions

No replies yet.