Support » Networking WordPress » SQL tables missing after multisite install

  • Resolved Gil

    (@gil-jones)


    I have an existing site and am converting it to multisite. Hosted on hostgator. I did the wp-config.php and .htaccess modifications, disabled all plugins, went through the steps in dashboard/tools/network.

    Tried to log in again and got the message that a network connection could not be established. Wound up at the step to repair the database and got the following:

    wp_1_posts: Table ‘capnj_wrdp1.wp_1_posts’ doesn’t exist
    wp_1_comments: Table ‘capnj_wrdp1.wp_1_comments’ doesn’t exist
    wp_1_links: Table ‘capnj_wrdp1.wp_1_links’ doesn’t exist
    wp_1_options: Table ‘capnj_wrdp1.wp_1_options’ doesn’t exist
    wp_1_postmeta: Table ‘capnj_wrdp1.wp_1_postmeta’ doesn’t exist
    wp_1_terms: Table ‘capnj_wrdp1.wp_1_terms’ doesn’t exist
    wp_1_term_taxonomy: Table ‘capnj_wrdp1.wp_1_term_taxonomy’ doesn’t exist
    wp_1_term_relationships: Table ‘capnj_wrdp1.wp_1_term_relationships’ doesn’t exist
    wp_1_commentmeta: Table ‘capnj_wrdp1.wp_1_commentmeta’ doesn’t exist

    Anyone have clues for me?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Andrea Rennick

    (@andrea_r)

    Customer Care at Copyblogger Media and Studiopress

    Did you se the One-Clikc install to make the wordpress install to begin with?

    Look in the db – were the tables actually created?

    (don;t look for wp_1_x ones)

    Gil

    (@gil-jones)

    Hostgator installed it originally and imported my old blog.
    The multisite tables are actually there, just not with the wp_1_XXX ones.

    The WP-X directories are directly under public_html

    Gil

    (@gil-jones)

    I’ve tinkered and now can log into the site with the network enabled. I think I was missing

    define( ‘MULTISITE’, true );

    But in the dashboard there are no network settings available.

    gil

    Gil

    (@gil-jones)

    Oh, wait! Found it! I”m good to go now.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL tables missing after multisite install’ is closed to new replies.