WordPress blog down after 2.3.3 upgrade



After using the DreamHost Panel to upgrade my WordPress one-click install from 2.3.2 to 2.3.3, my blog somehow lost its ability to see the database. When I go to my blog home page, I get:

Not Found
Sorry, but you are looking for something that isn’t here.

All of the other settings, such as the blogroll and static pages, are gone. Even the name of my blog has disappeared, replaced with the generic “My Blog: Just another WordPress weblog”.

In addition, all permalinks now give 404 Not Found errors. And when I try to login as an admin, I get “ERROR: Invalid username.”

I checked the settings in wp-config.php, and everything looks fine. The database it points to is up, and the tables all look okay.

How do I go about debugging this problem? Does WordPress generate any log files I could look at?


For starters, maybe your .htaccess file got munged. Compare your current one to the one in the .old directory of the old WordPress.

You could also try reverting to 2.3.2 to see if something still works. There should be a .old folder that contains your old installation. Rename your upgraded one to .new, and put the .old one back.



Why yes, it did get munged. The following rule was in the old .htaccess but not in the new one:

<IfModule mod_rewrite.c> RewriteEngine On RewriteBase /trevor/blog/ RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /trevor/blog/index.php [L] </IfModule>
Unfortunately, putting this rule into the new .htaccess didn’t fix anything.

Yes, that was the first thing I tried, but I’m still getting the same error.

It’s very troubling. I guess my next course of action is to start over completely and reinstall the blog from scratch.


I figured it out. Something in the one-click upgrade process changed the value of the table_prefix variable in wp-config.php. Previously it was ‘wp_’; after the upgrade it was ‘wp_zqzsgx_’.

I’m not sure why reverting to the previous installation (which did not have zqzsgx) didn’t fix the problem, but at least everything is back to normal now.