Support » Networking WordPress » MulitSite fails to create new tables with subdomain install

  • blogachover


    I just did a fresh install of 3.0.4, with wordpress installed in the / directory of the website. All was well, dashboard and everything. I then added “define(‘WP_ALLOW_MULTISITE’, true);” and went and enabled a network, with SUBDOMAIN_INSTALL set to true. I changed wp-config, changed htaccess, created blogs.dir.

    When I try to go to this site I get “Error Establishing a Database Connection”. Going to wp-admin I get more information on what’s missing. I have changed the values of my database and prefix to “my_wp_db” and “prefix_”, but here are the specifics of what the network install apparently did not create:

    prefix_1_posts: Table ‘my_wp_db.prefix_1_posts’ doesn’t exist
    prefix_1_comments: Table ‘my_wp_db.prefix_1_comments’ doesn’t exist
    prefix_1_links: Table ‘my_wp_db.prefix_1_links’ doesn’t exist
    prefix_1_options: Table ‘my_wp_db.prefix_1_options’ doesn’t exist
    prefix_1_postmeta: Table ‘my_wp_db.prefix_1_postmeta’ doesn’t exist
    prefix_1_terms: Table ‘my_wp_db.prefix_1_terms’ doesn’t exist
    prefix_1_term_taxonomy: Table ‘my_wp_db.prefix_1_term_taxonomy’ doesn’t exist
    prefix_1_term_relationships: Table ‘my_wp_db.prefix_1_term_relationships’ doesn’t exist
    prefix_1_commentmeta: Table ‘my_wp_db.prefix_1_commentmeta’ doesn’t exist

    I have checked my mysql directory and indeed, all the ‘regular’ files like ‘my_wp_db.prefix_posts’ do exist, while no files matching ‘*_1_*’ exist.

    Thanks for any help!

Viewing 3 replies - 1 through 3 (of 3 total)
  • blogachover


    I failed to note that if I comment out “define( ‘SUBDOMAIN_INSTALL’, true );” then the site displays and I can post to the “main” sitename. But I don’t have a “Super Admin” section. So as far as what I need to do here, we’re dead in the water pending help.

    Thanks again…



    Any ideas? I suppose I could manually create the tables…

    Andrea Rennick


    Customer Care at Copyblogger Media and Studiopress

    Please follow the instructions *exactly* and make sure the db user has ALL permissions on the db.

    Do not put the config statements at the bottom of the file.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘MulitSite fails to create new tables with subdomain install’ is closed to new replies.