Removing Multisites and repairing database, cannot login now

  • Resolved cubanology

    (@cubanology)


    14 years, 2 months ago

    I was removing mutisites from wordpress and was prompted to repair my database. I repaired and optimized and there were some files which could not be repaired. Now I cannot login, I get this message:
    “Error establishing a database connection”
    This is the website: https://cubanology.com/home/

    This was the result of my repair and optimize:
    wp_usermeta: Table upgrade required. Please do “REPAIR TABLE wp_usermeta” or dump/reload to fix it!
    wp_1_posts: Table ‘cubano2_home.wp_1_posts’ doesn’t exist
    wp_1_comments: Table ‘cubano2_home.wp_1_comments’ doesn’t exist
    wp_1_links: Table ‘cubano2_home.wp_1_links’ doesn’t exist
    wp_1_options: Table ‘cubano2_home.wp_1_options’ doesn’t exist
    wp_1_postmeta: Table ‘cubano2_home.wp_1_postmeta’ doesn’t exist
    wp_1_terms: Table ‘cubano2_home.wp_1_terms’ doesn’t exist
    wp_1_term_taxonomy: Table ‘cubano2_home.wp_1_term_taxonomy’ doesn’t exist
    wp_1_term_relationships: Table ‘cubano2_home.wp_1_term_relationships’ doesn’t exist
    wp_1_commentmeta: Table ‘cubano2_home.wp_1_commentmeta’ doesn’t exist

Viewing 15 replies - 1 through 15 (of 20 total)
  • Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Did you delete blog #1?

    Thread Starter cubanology

    (@cubanology)

    Hello, how are you doing? No, I didn’t.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Okay, go into your database and see if the tables are there at all?

    Thread Starter cubanology

    (@cubanology)

    I just went right ahead and removed “define(‘WP_ALLOW_MULTISITE’, true);” and replaced the htaccess file with the original one.

    Thread Starter cubanology

    (@cubanology)

    Yes they are there

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Was this WPMU upgraded to WP 3.0 or was it always built on the 3.0 code?

    Thread Starter cubanology

    (@cubanology)

    Yeah, well, I figured that if I reversed the process then it would go back to how it was before. Not thinking on my part.

    Thread Starter cubanology

    (@cubanology)

    I have the latest update on the blog

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    Yeah, you can’t go back really. I mean, you can, but it’s not that clear.

    If you were on WPMU, the first blog’s database tables are WP_1

    If you start from WP 3.0, the first blog is at WP_ (no number).

    So I THINK that if you try and ‘undo’ a WPMU site, it’ll get … barfy.

    It’s probably ‘better’ to make a new 3.0 Single Site and then export/import.

    Thread Starter cubanology

    (@cubanology)

    I just converted it to a multisite two days ago

    Thread Starter cubanology

    (@cubanology)

    What if I try to make it a multisite again. Do the process over??

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    ?????? Advisor and Activist

    So it was a single site in WP 3.0?

    I think… try removign this stuff as well

    define( 'MULTISITE', true );
define( 'SUBDOMAIN_INSTALL', false );
$base = '/';
define( 'DOMAIN_CURRENT_SITE', 'localhost' );
define( 'PATH_CURRENT_SITE', '/' );
define( 'SITE_ID_CURRENT_SITE', 1 );
define( 'BLOG_ID_CURRENT_SITE', 1 );

    And put this in instead
    define('WP_ALLOW_MULTISITE', false);

    Instead of removing it, we’ll just say ‘No! Go away!’

    Thread Starter cubanology

    (@cubanology)

    Yes it was a single site at 3.0

    Thread Starter cubanology

    (@cubanology)

    I don’t see what you have there on my config.php file exactly but I do see this :

    /** Sets up WordPress vars and included files. */
    require_once(ABSPATH . ‘wp-settings.php’);
    define(‘WP_ALLOW_MULTISITE’, true);

    Remove whatever plugins you had in mu-plugins and disable the other plugins as well.

Viewing 15 replies - 1 through 15 (of 20 total)
  • The topic ‘Removing Multisites and repairing database, cannot login now’ is closed to new replies.