WordPress.org

Ready to get started?Download WordPress

Forums

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

  1. blogachover
    Member
    Posted 3 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
    Member
    Posted 3 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
    Member
    Posted 3 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.

    http://wpebooks.com/2010/09/how-to-enable-multisite-in-wordpress/

    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