wordpress upgrade failed. drops to install screen. database schema not upgraded
Bug #990615 reported by
rob
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
wordpress (Ubuntu) |
New
|
Undecided
|
Unassigned |
Bug Description
After I upgraded from 10.04.3 to 12.04, wordpress started redirecting to the install.php install screen.
Digging through the mysql database, I saw nothing wrong as all the settings and posts were there. So I continued on the install screen, and entered the admin user & password. Now in mysql there are duplicate tables with a fresh install.
For example there is both the 'options' table with all the old options and a 'wp_options' table with the fresh install.
So it looks like the upgrade from Lucid to Precise failed to migrate the wordpress database to a new schema.
To post a comment you must log in.
Update. As it seems that my wordpress instance does not have the 'wp_' prefix on most of the database tables, it was 3 new lines in the updated /etc/wordpress/ wp-config. php that caused the problem:
if (!isset( $table_ prefix) ) {
$table_prefix = 'wp_';
}
The fix was to restore the wordpress database from backup and then add one line, setting $table_prefix to '' in my site's /etc/wordpress/ config- default. php where the database passwords are.
$table_prefix = '';
And then run the Automatic Updater normally: localhost/ wordpress/ wp-admin/ update- core.php
http://