Suddenly a lot of tables does not exist!! (In creating a multisite)

  • Resolved Aureola

    (@aureola)


    11 years ago

    Hello!
    I’m about to install multisite following the Codex. So, I added the lines:

    /* Multisite */
define( 'WP_ALLOW_MULTISITE', true );

    to wp-config.php, just above */That’s all folks…/*
    Refreshed admin-panel and went on to Tools – Network Setup, Next: Then I’m asked to add these lines to config.php to the same place as above;

    define('SUBDOMAIN_INSTALL', true);
define('DOMAIN_CURRENT_SITE', 'www.ct-equestrian.com');
define('PATH_CURRENT_SITE', '/');
define('SITE_ID_CURRENT_SITE', 1);
define('BLOG_ID_CURRENT_SITE', 1);

    (Although I would like to install to a subfolder, not a subdomain, but I never got the choice)
    Then this to the .htaccess:

    # BEGIN WordPress
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ - [L]

# add a trailing slash to /wp-admin
RewriteRule ^wp-admin$ wp-admin/ [R=301,L]

RewriteCond %{REQUEST_FILENAME} -f [OR]
RewriteCond %{REQUEST_FILENAME} -d
RewriteRule ^ - [L]
RewriteRule ^(wp-(content|admin|includes).*) $1 [L]
RewriteRule ^(.*\.php)$ $1 [L]
RewriteRule . index.php [L]

# END WordPress

    Now everything has crashed. I can’t access mysite.com/wp-admin anymore, nor /wp-login. I just get a Database error. I try to run the repair, and it just says a lot of tables doesn’t exist! An excerpt:

    The wp_1_posts table is not okay. It is reporting the following error: Table ‘ct_equestrian_c.wp_1_posts’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_1_posts table. Error: Table ‘ct_equestrian_c.wp_1_posts’ doesn’t exist

    The wp_1_comments table is not okay. It is reporting the following error: Table ‘ct_equestrian_c.wp_1_comments’ doesn’t exist. WordPress will attempt to repair this table…
    Failed to repair the wp_1_comments table. Error: Table ‘ct_equestrian_c.wp_1_comments’ doesn’t exist

    Anyone know how to get through this?! It is really urgent because I’m doing this on the live site (I practiced on localhost first and there everything worked like a charm) and it is very very down right now… Please help!

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Aureola

    (@aureola)

    I restored both files (wp-config and htaccess) and tried one more time, with just the first adjustment; allow multisite:true.
    I could then log in to the admin panel and once more go to Network Setup, clicked, then there was a message saying that another network site (? I’m not really sure what it called it anymore+) exists, but it still gave me the text lines to change wp-config and htaccess, and this time, the subdomain setting was changed to false, like so:
    define('SUBDOMAIN_INSTALL', false);

    I also applied the new changes to htaccess, but the same thing happened.. As soon as I click the Login link from the network setup page(which goes to wp-login.php) after the modifications, I get a Database error again.
    “Error establishing a database connection”. The user- and database-definitions in wp-config.php have worked fine until now, so what on earth could be the problem..?

    Thread Starter Aureola

    (@aureola)

    Thank god (Or Andrea in this thread) it works now!
    https://www.ads-software.com/support/topic/when-multi-site-enabled-stie-says-database-is-broken?replies=29

    I didn’t realize you have to have BOTH these lines in wp-config.php:
    define(‘WP_ALLOW_MULTISITE’, true);
    define( ‘MULTISITE’, true );

    *smashing my forehead*

    At least hope this helps others.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Suddenly a lot of tables does not exist!! (In creating a multisite)’ is closed to new replies.

Tags