Comment 2 for bug 990615

Revision history for this message
Raphaël Hertzog (hertzog) wrote : Re: [Bug 990615] [NEW] wordpress upgrade failed. drops to install screen. database schema not upgraded

On Sat, 28 Apr 2012, rob wrote:
> Public bug reported:
>
> 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.

Hi,

This has nothing to do with a new schema but just with the $table_prefix
option. It's set to "wp_" by default in the precise package but AFAIK it
has been that way for a long time.

Are you sure you didn't have a specific configuration where the prefix was
set to empty ?

Can you attach the content of /etc/wordpress/ ?

Thus you can recover your former content by changing the wordpress
configuration in /etc/wordpress/wp-config.php and switching $table_prefix
to ''.

Cheers,
--
Raphaël Hertzog ◈ Debian Developer

Pre-order a copy of the Debian Administrator's Handbook and help
liberate it: http://debian-handbook.info/liberation/