Support » Networking WordPress » missing tables after WPMU 2.9 to WP3 upgrade

  • Resolved Mikkel Breum


    After I’ve upgraded the files in my WPMU 2.0.2 install with the WP3.0 ones (following all the steps in – I’ll upgrade to 3.9.2 as the last step.)

    I can no longer access the Admin.

    When I go to /wp-admin/ to run the network upgrade of the database, WP tells me that the DB needs repairing, and after trying that, it tells me it can’t and that:

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

    *actual database name changed to dbname above.

    It’s a multisite install so these tables should not be there. They exists for each blog as dbname.wp_1_posts, dbname.wp_2_posts, etc..

    What could be going wrong here, and how can I fix it?

Viewing 1 replies (of 1 total)
  • Found the solution:

    Yes WP was ‘triggered’ to think it was evaluating a WordPress and not a WordPress-MU table structure.

    This was caused by the following lines:

    define('WP_ALLOW_MULTISITE', true);
    define( 'MULTISITE', true ); the wp-config.php. Those lines should NOT be there in a WordPress-MU 2.9.2 installation (but some former developer had tossed them in there anyway)

    Once I removed them, I could proceed to the /wp-admin without problems and update the site network.

Viewing 1 replies (of 1 total)
  • The topic ‘missing tables after WPMU 2.9 to WP3 upgrade’ is closed to new replies.