Hi thanks for the clarification. I agree the problem was in the prefix,
or lack thereof, of my database's wordpress tables.
I originally installed wordpress in Jan 2008 and have propagated the
database all the way from 32-bit feisty to 64-bit lucid and, recently,
precise. So sometime in the past 4 years the default 'wp_' prefix was
set but didn't get applied to my mysql instance.
The fix that worked for me was to include $table_prefix=''; in my
/etc/wordpress/config-default:
<?php
define('DB_NAME', 'wordpress');
define('DB_USER', 'wordpress');
define('DB_PASSWORD', '***my*password*here****');
define('DB_HOST', 'localhost');
$table_prefix = '';
?>
Incidentally only some of the wordpress tables have the wp_ prefix on my system.
mysql> use wordpress
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables
-> ;
+----------------------+
| Tables_in_wordpress |
+----------------------+
| commentmeta |
| comments |
| links |
| options |
| postmeta |
| posts |
| term_relationships |
| term_taxonomy |
| terms |
| usermeta |
| users |
| wp_email_list |
| wp_email_list_config |
| wp_email_list_future |
+----------------------+
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/990615
Title:
wordpress upgrade failed. drops to install screen. database schema not
upgraded
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/wordpress/+bug/990615/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
