Recently I decided to upgrade WordPress to 3.0, this didn’t went as smoothly as one might expect. Since it took me quite some time to Google the right answer. I’m gonna post the solution to my problem here on my website, with the right keywords ;-).
The error I got when running upgrade.php was “One or more database tables are unavailable. The database may need to be repaired.” Obviously a repair wouldn’t help, since my database was found to be OK.
The solution is executing a simple MySQL command to update the siteurl option.
UPDATE wp_options SET option_value=’http://yoururl.nl‘ WHERE option_name=’siteurl’;
I couldn’t update the record since it wasn’t there (law of Murphy) so I added the record:
insert into wp_options (option_value,option_name) value (‘http://yoururl.nl‘,’siteurl’);
Now upgrade.php worked just fine. Yay!
3 Comments