MulitSite fails to create new tables with subdomain install (4 posts)

  1. blogachover
    Posted 4 years ago #

    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!

  2. blogachover
    Posted 4 years ago #

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

  3. blogachover
    Posted 4 years ago #

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

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

Topic Closed

This topic has been closed to new replies.

About this Topic