Database problems upgrading from 2.8 to 3.0.1

  • Hello,

    I ran the manual upgrade to my WordPress MU from 2.8 to 3.0.1, after some failed attempts at automatic upgrading. Now I am having problems with the database. The error messages I get are as follows:

    wp_posts: Table ‘muwordpress.wp_posts’ doesn’t exist
    wp_comments: Table ‘muwordpress.wp_comments’ doesn’t exist
    wp_links: Table ‘muwordpress.wp_links’ doesn’t exist
    wp_options: Table ‘muwordpress.wp_options’ doesn’t exist
    wp_postmeta: Table ‘muwordpress.wp_postmeta’ doesn’t exist
    wp_terms: Table ‘muwordpress.wp_terms’ doesn’t exist
    wp_term_taxonomy: Table ‘muwordpress.wp_term_taxonomy’ doesn’t exist
    wp_term_relationships: Table ‘muwordpress.wp_term_relationships’ doesn’t exist
    wp_commentmeta: Table ‘muwordpress.wp_commentmeta’ doesn’t exist

    A ‘show tables’ on the database displays the following list of tables:

    +————————-+
    | Tables_in_muwordpress |
    +————————-+
    | wp_1_comments |
    | wp_1_links |
    | wp_1_options |
    | wp_1_postmeta |
    | wp_1_posts |
    | wp_1_term_relationships |
    | wp_1_term_taxonomy |
    | wp_1_terms |
    | wp_2_comments |
    | wp_2_links |
    | wp_2_options |
    | wp_2_postmeta |
    | wp_2_posts |
    | wp_2_term_relationships |
    | wp_2_term_taxonomy |
    | wp_2_terms |
    | wp_3_comments |
    | wp_3_links |
    | wp_3_options |
    | wp_3_postmeta |
    | wp_3_posts |
    | wp_3_term_relationships |
    | wp_3_term_taxonomy |
    | wp_3_terms |
    | wp_4_comments |
    | wp_4_links |
    | wp_4_options |
    | wp_4_postmeta |
    | wp_4_posts |
    | wp_4_term_relationships |
    | wp_4_term_taxonomy |
    | wp_4_terms |
    | wp_5_comments |
    | wp_5_links |
    | wp_5_options |
    | wp_5_postmeta |
    | wp_5_posts |
    | wp_5_term_relationships |
    | wp_5_term_taxonomy |
    | wp_5_terms |
    | wp_6_comments |
    | wp_6_links |
    | wp_6_options |
    | wp_6_postmeta |
    | wp_6_posts |
    | wp_6_term_relationships |
    | wp_6_term_taxonomy |
    | wp_6_terms |
    | wp_7_comments |
    | wp_7_links |
    | wp_7_options |
    | wp_7_postmeta |
    | wp_7_posts |
    | wp_7_term_relationships |
    | wp_7_term_taxonomy |
    | wp_7_terms |
    | wp_8_comments |
    | wp_8_links |
    | wp_8_options |
    | wp_8_postmeta |
    | wp_8_posts |
    | wp_8_term_relationships |
    | wp_8_term_taxonomy |
    | wp_8_terms |
    | wp_9_comments |
    | wp_9_links |
    | wp_9_options |
    | wp_9_postmeta |
    | wp_9_posts |
    | wp_9_term_relationships |
    | wp_9_term_taxonomy |
    | wp_9_terms |
    | wp_blog_versions |
    | wp_blogs |
    | wp_registration_log |
    | wp_signups |
    | wp_site |
    | wp_sitecategories |
    | wp_sitemeta |
    | wp_usermeta |
    | wp_users |
    +————————-+

    Any idea?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Anonymous User

    (@anonymized-3085)

    according to my installation the following tables:

    | wp_1_comments |
| wp_1_links |
| wp_1_options |
| wp_1_postmeta |
| wp_1_posts |
| wp_1_term_relationships |
| wp_1_term_taxonomy |
| wp_1_terms |

    shouldn’t have the _1 in them – so you could try renaming those.

    Thread Starter rafafallo

    (@rafafallo)

    It does not work. I lost all information, including admin privileges.

    according to my installation the following tables:
    <snip>
    shouldn’t have the _1 in them – so you could try renaming those.

    Please note – the OP upgraded from WPMU. They NEED to have those numbers in them. That’s the difference between upgrading from WPMU and starting from WP. The main blog will have the 1 in the tables.

    @rafafallo – when you did the manual upgrade, did you change anything in the wp-config.php file? If so do you have a backup for the file?

    Anonymous User

    (@anonymized-3085)

    ahh please accept my apologies, I assumed it would change them.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database problems upgrading from 2.8 to 3.0.1’ is closed to new replies.