New to the community? Start here

having issues creating a sub-domain multisite

i’m having issues creating a multisite with sub-domains. I keep getting an ‘error establishing database connection’ error.

so i put in mysitename.com/wp-admin and it asked me to put WP_ALLOW_REPAIR into the config.php, which I did.

Then it said the database needed to be repaired, so I did this and got this in return:

wp_1_posts: Table ‘intothem_mythica.wp_1_posts’ doesn’t exist

wp_1_comments: Table ‘intothem_mythica.wp_1_comments’ doesn’t exist

wp_1_links: Table ‘intothem_mythica.wp_1_links’ doesn’t exist

wp_1_options: Table ‘intothem_mythica.wp_1_options’ doesn’t exist

wp_1_postmeta: Table ‘intothem_mythica.wp_1_postmeta’ doesn’t exist

wp_1_terms: Table ‘intothem_mythica.wp_1_terms’ doesn’t exist

wp_1_term_taxonomy: Table ‘intothem_mythica.wp_1_term_taxonomy’ doesn’t exist

wp_1_term_relationships: Table ‘intothem_mythica.wp_1_term_relationships’ doesn’t exist

wp_1_commentmeta: Table ‘intothem_mythica.wp_1_commentmeta’ doesn’t exist

Sun, 31 Aug 2014 22:53:26
  • Griffin
    • The Crimson Coder

    Note: I use Softaclicious to create the wordpress vanilla install. Sub-directory multisites don’t cause the issue.

    Is this a SERVER based issue?

    Am I out-of-alignment in creating an A name entry for *.mysitename.com wildcard?

    There are two aspects that I know of in my cPanel. One is a sub-domain creation aspect and the other is a DNS aspect. Please assist.

  • Michelle Shull
    • DEV MAN’s Apprentice

    Hi Griffin!

    I’m going to need a little more info to help sort out your issue.

    1. What did you do right before you got the “error establishing database connection” error?

    2. Where did you put in “mysitename.com/wp-admin”?

    3. What method did you use to repair your database?

    4. When and how did you change the prefixes on your database tables to intothem_mythica.wp_1 from wp_?

    Thanks!

  • Griffin
    • The Crimson Coder

    1. It was right after I put in define(‘WP_ALLOW_MULTISITE’, true) into the config.php and went to Tools -> Network Setup. I go back into config.php and put in the code, and go into .htaccess and put in the code.

    2. intothemythica.com/wp-admin

    3. I used the WP_REPAIR or something like that (from WordPress, in the config.php file)

    4. Did not change.

    Basically everything works until I get to this point.

    I went into cPanel, and created a DNS record, an ‘A” name record for *.intothemythica.com; doesn’t work..

    Alternatively, I go in, and create a sub-domain called *.intothemythica.com; doesn’t work.

    Each time I delete the ENTIRE install, return it to vanilla, and try again.

    I don’t know if i’m not doing something I need to on the cPanel side or not. It’s all very frustrating.