Support » Networking WordPress » Disabling Multisite DB Error

  • I’m trying to disable and delete a multisite completely where my primary site is a BuddyPress website all other were (total 4) regular sites which I am moving elsewhere.

    Removing the specific codes from wp-config and htacces gives database error and wordpress shows a database repair screen. When I run the repair following error comes:

    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

    database_posts: Table ‘Database-User-Name_posts’ doesn’t exist
    database_comments: Table ‘Database-User-Name_comments’ doesn’t exist
    database_links: Table ‘Database-User-Name_links’ doesn’t exist
    database_options: Table ‘Database-User-Name_options’ doesn’t exist
    database_postmeta: Table ‘Database-User-Name_postmeta’ doesn’t exist
    database_terms: Table ‘Database-User-Name_terms’ doesn’t exist
    database_term_taxonomy: Table ‘Database-User-Name_term_taxonomy’ doesn’t exist
    database_term_relationships: Table ‘Database-User-Name_term_relationships’ doesn’t exist
    database_commentmeta: Table ‘Database-User-Name_commentmeta’ doesn’t exist

    For now I have restored the back up and everything is fine but I have to delete multistage from this setup.
    Any ides?
    Thank you for the help 🙂

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

    (@ipstenu)

    Lead Plugin Wrangler

    Hello
    Yes, I followed the tutorial. It gives the error when I come back to login at my-website.com/wp-admin.

    All other urls of the website show Database Error. Is it possible to reinstall WordPress from the scratch but VERY IMPORTANTLY keep my existing BuddyPress users?

    regards

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    That error usually comes from not cleaning the wp-config.php file correctly. Did you already delete all your other sites?

    Yes, I have already deleted all my sub site. I am very carefully cleaning the following code from wp-config.

    define('WP_ALLOW_MULTISITE', true);
    
    define('MULTISITE', true);
    define('SUBDOMAIN_INSTALL', true);
    $base = '/';
    define('DOMAIN_CURRENT_SITE', 'my-site.com');
    define('PATH_CURRENT_SITE', '/');
    define('SITE_ID_CURRENT_SITE', 1);
    define('BLOG_ID_CURRENT_SITE', 1);

    If I keep the following in my htaccess, returning to my website in a browser returns 403 Forbidden error.

    # BEGIN WordPress
    <IfModule mod_rewrite.c>
    RewriteEngine On
    RewriteBase /
    RewriteRule ^index\.php$ – [L]
    RewriteCond %{REQUEST_FILENAME} !-f
    RewriteCond %{REQUEST_FILENAME} !-d
    RewriteRule . /index.php [L]
    </IfModule>
    # END WordPress

    If I remove htaccess file completely, website shows following:

    Error establishing a database connection

    Visiting wp-admin page however shows following
    One or more database tables are unavailable. The database may need to be repaired.

    If I click on repair, it asks me to add following to wp-config file.

    define('WP_ALLOW_REPAIR', true);

    Clicking on Repair Database after adding the code, following message comes:

    Some database problems could not be repaired. Please copy-and-paste the following list of errors to the WordPress support forums to get additional assistance.

    database_posts: Table 'Database-User-Name_posts' doesn't exist
    database_comments: Table 'Database-User-Name_comments' doesn't exist
    database_links: Table 'Database-User-Name_links' doesn't exist
    database_options: Table 'Database-User-Name_options' doesn't exist
    database_postmeta: Table 'Database-User-Name_postmeta' doesn't exist
    database_terms: Table 'Database-User-Name_terms' doesn't exist
    database_term_taxonomy: Table 'Database-User-Name_term_taxonomy' doesn't exist
    database_term_relationships: Table 'Database-User-Name_term_relationships' doesn't exist
    database_commentmeta: Table 'Database-User-Name_commentmeta' doesn't exist

    I thought I should share this. I used the ‘Change Database Prefix’ option of Better WP Security (http://wordpress.org/extend/plugins/better-wp-security/) installed to my MultiSite which changed DB prefix from ‘wp’ to ‘raw9np’. Do you think this may be the reason of the problem? If yes, can you kindly guide me what can I do about it?

    If you want to ask/see anything else please tell me how can I share that if not suitable to post in public.

    I will appreciate your help
    Thank you.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    *sigh*

    Changing your DB prefix like that is problematic for a lot of things. If your prefix does NOT match what you have in wp_config, then you could be having problems galore. Also? Changing it does not make your site any safer. I promise, it’s just a feel-good thing.

    Check your wp-config to make sure it says your prefix is raw9np_

    Also did you remove the Multisite tables?

    Oh!
    Yes the prefix does match. So does this mean its not the problem causing db error?

    Also did you remove the Multisite tables?

    Should I do it even if I see this db error problem? I’m not doing it as I am afraid of losing the entire installation.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    It’s not really a huge issue. 🙂 I mean, you can leave ’em there forever and the only time it gives you a pain is if you try to make a new multisite 😉

    What happens if you just remove these:

    define('WP_ALLOW_MULTISITE', true);
    define('MULTISITE', true);

    If we can’t sort it out, the other idea is to make a new install in a subfolder, pull everything over to that new single install, and then run WP out of a subfolder, which you CAN do for single site. Often it’s easier than monkying around.

    I will try this.

    Thank you very much for your help and support 🙂

    I tried removing the following lines as per you suggestion.

    define('WP_ALLOW_MULTISITE', true);
    define('MULTISITE', true);

    It gives same error :
    Error establishing a database connection

    Trying accessing wp-admin says :
    One or more database tables are unavailable. The database may need to be repaired.

    When I click on repaired (is click-able) it says :

    ra29np_1_posts: Table 'eve1218809093172.ra29np_1_posts' doesn't exist
    ra29np_1_comments: Table 'eve1218809093172.ra29np_1_comments' doesn't exist
    ra29np_1_links: Table 'eve1218809093172.ra29np_1_links' doesn't exist
    ra29np_1_options: Table 'eve1218809093172.ra29np_1_options' doesn't exist
    ra29np_1_postmeta: Table 'eve1218809093172.ra29np_1_postmeta' doesn't exist
    ra29np_1_terms: Table 'eve1218809093172.ra29np_1_terms' doesn't exist
    ra29np_1_term_taxonomy: Table 'eve1218809093172.ra29np_1_term_taxonomy' doesn't exist
    ra29np_1_term_relationships: Table 'eve1218809093172.ra29np_1_term_relationships' doesn't exist
    ra29np_1_commentmeta: Table 'eve1218809093172.ra29np_1_commentmeta' doesn't exist

    ———————————————-

    Can you kindly elaborate the following.

    If we can’t sort it out, the other idea is to make a new install in a subfolder, pull everything over to that new single install, and then run WP out of a subfolder, which you CAN do for single site. Often it’s easier than monkying around.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    1) Install a new version of WP into a subfolder.

    2) Export from your current main site.

    3) Import into your new subfolder install.

    4) Delete the main site.

    5) http://codex.wordpress.org/Giving_WordPress_Its_Own_Directory#Using_a_pre-existing_subdirectory_install

    Ok, I’m going to do in now. However I doubt BuddyPress can be exported, my concern is to keep my BuddyPress users. As far as pages and posts I have a few only so I could recreate them.

    Thank you.

    Moderator Ipstenu (Mika Epstein)

    (@ipstenu)

    Lead Plugin Wrangler

    BuddyPress…

    Didn’t they introduce an import/export in 1.4? Oh. Guess not. http://codex.buddypress.org/buddypress-site-administration/exporting-data/

    Your users will be brought over so long as they have a post or (IIRC) a comment.

    The ‘trick’ is this 😉 Save your old DB. Once you’ve rebuilt everything, you should be able to copy over all the BP tables (and user tables, I think, but do it carefully).

Viewing 13 replies - 1 through 13 (of 13 total)
  • The topic ‘Disabling Multisite DB Error’ is closed to new replies.