Title: Disabling Multisite DB Error Last modified: August 20, 2016 --- # Disabling Multisite DB Error * [mairaj](https://wordpress.org/support/users/mairaj/) * (@mairaj) * [13 years, 8 months ago](https://wordpress.org/support/topic/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)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953516) * Did you read [http://wpmututorials.com/how-to/how-to-disable-multisite/](http://wpmututorials.com/how-to/how-to-disable-multisite/)? * Thread Starter [mairaj](https://wordpress.org/support/users/mairaj/) * (@mairaj) * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953553) * 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)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953612) * That error usually comes from not cleaning the wp-config.php file correctly. Did you already delete all your other sites? * Thread Starter [mairaj](https://wordpress.org/support/users/mairaj/) * (@mairaj) * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953634) * 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 RewriteEngine On RewriteBase / RewriteRule ^index\.php$ – [L] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME}!- d RewriteRule . /index.php [L] # 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 ``` * Thread Starter [mairaj](https://wordpress.org/support/users/mairaj/) * (@mairaj) * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953638) * 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/](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)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953647) * *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? * Thread Starter [mairaj](https://wordpress.org/support/users/mairaj/) * (@mairaj) * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953675) * 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)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953678) * 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. * Thread Starter [mairaj](https://wordpress.org/support/users/mairaj/) * (@mairaj) * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953696) * I will try this. * Thank you very much for your help and support 🙂 * Thread Starter [mairaj](https://wordpress.org/support/users/mairaj/) * (@mairaj) * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953706) * 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)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953708) * 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](http://codex.wordpress.org/Giving_WordPress_Its_Own_Directory#Using_a_pre-existing_subdirectory_install) * Thread Starter [mairaj](https://wordpress.org/support/users/mairaj/) * (@mairaj) * [13 years, 8 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953710) * 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)](https://wordpress.org/support/users/ipstenu/) * (@ipstenu) * 🏳️‍🌈 Advisor and Activist * [13 years, 7 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953714) * BuddyPress… * Didn’t they introduce an import/export in 1.4? Oh. Guess not. [http://codex.buddypress.org/buddypress-site-administration/exporting-data/](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. * In: [Networking WordPress](https://wordpress.org/support/forum/multisite/) * 13 replies * 2 participants * Last reply from: [Ipstenu (Mika Epstein)](https://wordpress.org/support/users/ipstenu/) * Last activity: [13 years, 7 months ago](https://wordpress.org/support/topic/disabling-multisite-db-error/#post-2953714) * Status: not resolved ## Topics ### Topics with no replies ### Non-support topics ### Resolved topics ### Unresolved topics ### All topics