btocher

Yet another reinstall, and this time managed to import the database fine.

Hopefully no more CPU exceeded errors. I’m being very careful about which plugins I add.

Thanks again to everyone for their help.

Okay, I bit the bullet, backed up the sql database, uninstalled and reinstalled WordPress at my host.

I managed to import the database via MyPHPAdmin, and it looks fine there. But WordPress tells me it can’t see it, even though the name of the database WordPress is looking for is definitely correct.

BlueHost have now suggested that my index.php is getting stuck in a non-terminating loop.

Here’s the code:

<?php
/* Short and sweet */
define('WP_USE_THEMES', true);
require('./wp-blog-header.php');
?>

I’m pretty sure that this is the default, “out-of-the-box” file. And why would it get stuck in a loop sometimes but not others?

davidchait: I’ve turned wp-cache on again as you suggest. I guess it sure won’t make matters any worse.

Here’s a snippet of the log file, which is as you describe:

Mon Apr 9 02:20:43 2007: used 1.48 seconds of cpu time for /usr/bin/php index.php
Mon Apr 9 02:20:43 2007: used 0.02 seconds of cpu time for /usr/bin/php index.php
Mon Apr 9 02:20:48 2007: used 1.84 seconds of cpu time for /usr/bin/php index.php
Mon Apr 9 02:20:48 2007: used 1.72 seconds of cpu time for /usr/bin/php index.php
Mon Apr 9 02:20:48 2007: used 1.36 seconds of cpu time for /usr/bin/php index.php
Mon Apr 9 02:20:53 2007: used 0.03 seconds of cpu time for /usr/bin/php index.php
Mon Apr 9 02:20:53 2007: used 1.76 seconds of cpu time for /usr/bin/php index.php
Mon Apr 9 02:20:53 2007: used 1.54 seconds of cpu time for /usr/bin/php index.php
Mon Apr 9 02:20:53 2007: used 1.33 seconds of cpu time for /usr/bin/php index.php

I was running FireStats for a while (turned it off as I thought it may have been the problem!). There was no indication of unusual spammer activity – I get the odd thirty-forty a day, and have blocked a couple of IP ranges in my .htaccess file to prevent most of them from getting through.

Interestingly, there’ll be an hour or an hour-and-a-half with nothing in the log, then it starts again. The worst I can see, at a quick glance, is 5 in a second.

drmike: thanks for that – very helpful.

Can anyone suggest good experience of others?

whooami: I know I’m not the first, but is it fixable? Or is it specifically a BlueHost problem?

I’ve been looking (longingly) at alternatives from the search you suggested. I’m happy to move hosts if the problem doesn’t happen elsewhere.

drmike: what’s a mess, please? The service from my host? The CPU exceeded errors? My blog? ??

Same problem after upgrading the Google Sitemaps plugin.

Does anyone have any other suggestions, please? This is driving me crazy.

Thanks, HandySolo. For safety’s sake, I was running the most recent recommended version (2.7, from 2005). I’ve now installed v3.0b6.

I’ll let you know whether that solves the problem.