WordPress.org

Ready to get started?Download WordPress

Forums

Disabling Multisite DB Error (14 posts)

  1. mairaj
    Member
    Posted 2 years ago #

    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 :-)

  2. mairaj
    Member
    Posted 2 years ago #

    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

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

  4. mairaj
    Member
    Posted 2 years ago #

    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
  5. mairaj
    Member
    Posted 2 years ago #

    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.

  6. *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?

  7. mairaj
    Member
    Posted 2 years ago #

    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.

  8. 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.

  9. mairaj
    Member
    Posted 2 years ago #

    I will try this.

    Thank you very much for your help and support :-)

  10. mairaj
    Member
    Posted 2 years ago #

    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.

  11. 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

  12. mairaj
    Member
    Posted 2 years ago #

    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.

  13. 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).

Topic Closed

This topic has been closed to new replies.

About this Topic