WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] missing tables after WPMU 2.9 to WP3 upgrade (2 posts)

  1. Mikkel Breum
    Member
    Posted 2 years ago #

    After I've upgraded the files in my WPMU 2.0.2 install with the WP3.0 ones (following all the steps in http://codex.wordpress.org/Upgrading_WPMU - 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?

  2. Mikkel Breum
    Member
    Posted 2 years ago #

    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 );

    ..in 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.

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags