[wp-hackers] Lost categories upgrading to 2.5.1

[DD32]

It looks like certain tables havnt been created.

Heres what i'd personally do:
Check the permissions for the user that WordPress uses to connect to the  
database and grant it Drop and Create Privledges (at least temporarily),  
Set the db_version option in the database back to the 2.2.x value, and  
then force another upgrade to take place.

For the db_version:  
http://codex.wordpress.org/FAQ_Installation#How_do_you_force_a_database_upgrade.3F

If you dont want to give WP the ability to create/drop tables, You could  
manually create the wp_terms, wp_term_taxonomy, and wp_term_relationships  
tables from the SQL Schema in /wp-admin/includes/schema.php, but thats  
potentially difficult if you dont set the correct names/charsets

On Wed, 30 Apr 2008 15:04:39 +1000, Elliotte Harold  
<elharo at metalab.unc.edu> wrote:

> This is probably relevant:
>
> mysql> show tables;
> +----------------------------+
> | Tables_in_elharo_wordpress |
> +----------------------------+
> | wp_bad_behavior            |
> | wp_categories              |
> | wp_comments                |
> | wp_link2cat                |
> | wp_links                   |
> | wp_options                 |
> | wp_post2cat                |
> | wp_postmeta                |
> | wp_posts                   |
> | wp_usermeta                |
> | wp_users                   |
> +----------------------------+
>
> Looking in the forums it seems that this has happened to others, and
> there's been some trouble tracking the cause down.
>
> At this point I strongly suspect that some necessary tables were not
> created, and consequently a lot of commands failed. I'm going to see if
> I can fix this manually before In attempt to restore form the backup and
> reupgrade or revert.
>