WordPress.org

Ready to get started?Download WordPress

Forums

Some database problems could not be repaired. Please copy-and-paste the followin (9 posts)

  1. sayjumner
    Member
    Posted 2 years ago #

    SSIA

    wp_r5k7ks_1_posts: Table 'speculatorliving_com_1.wp_r5k7ks_1_posts' doesn't exist
    wp_r5k7ks_1_comments: Table 'speculatorliving_com_1.wp_r5k7ks_1_comments' doesn't exist
    wp_r5k7ks_1_links: Table 'speculatorliving_com_1.wp_r5k7ks_1_links' doesn't exist
    wp_r5k7ks_1_options: Table 'speculatorliving_com_1.wp_r5k7ks_1_options' doesn't exist
    wp_r5k7ks_1_postmeta: Table 'speculatorliving_com_1.wp_r5k7ks_1_postmeta' doesn't exist
    wp_r5k7ks_1_terms: Table 'speculatorliving_com_1.wp_r5k7ks_1_terms' doesn't exist
    wp_r5k7ks_1_term_taxonomy: Table 'speculatorliving_com_1.wp_r5k7ks_1_term_taxonomy' doesn't exist
    wp_r5k7ks_1_term_relationships: Table 'speculatorliving_com_1.wp_r5k7ks_1_term_relationships' doesn't exist
    wp_r5k7ks_1_commentmeta: Table 'speculatorliving_com_1.wp_r5k7ks_1_commentmeta' doesn't exist

    ---------------------------------
    I had a blog network i wanted to set up with the wordpress multisite function. and I have a blog started there. I wanted to disable the multisite feature because of some problems i was having with loading plug-ins and stuff.I have tried to remove it and ran across a few error. Can you please help me repair the DB.

  2. esmi
    Forum Moderator
    Posted 2 years ago #

    Did you backup the database before making these "changes"?

  3. And what directions did you follow to unsinatll MultiSite?

  4. sayjumner
    Member
    Posted 2 years ago #

    i removed the code just before happy blogging in wp-config, changed allow multisite from true to false. this iw when i was getting a DB error. Then WP suggested i add a code to config to fix the db and i did then a report produced those errors above.

  5. You should document your changes better (saying 'a code' doesn't help us if we don't know WHAT code). As it happens, I'm assuming you mean the repair database line.

    Read this: http://wpmututorials.com/how-to/how-to-disable-multisite/

  6. sayjumner
    Member
    Posted 2 years ago #

    i have already read an article like that, but i was wondering how do i Drop these global tables in the database:
    wp_blogs
    wp_blog_versions
    wp_registration_log
    wp_signups
    wp_site
    wp_sitemeta

    i have yet to do this on my own.

  7. Do you know how to get into your database at all?

    FWIW, wp_r5k7ks_1_ actually never exists if you've used WordPress MultiSite (it did exist on WPMU, which was the predecessor to MultiSite). So it shouldn't be looking for it at all.

    I pointed you to the doc becuase I'm not sure what directions you DID follow, so it's hard to tell you what to do.

    I would say to put the MultiSite lines back into the wp-config and see if that gets you back up. THEN make sure you deleted all your sites (did you?) except site #1.

  8. but i was wondering how do i Drop these global tables in the database:

    go into phpmyadmin, click the box in front of those tables, then click "drop tables".

  9. sayjumner
    Member
    Posted 2 years ago #

    That sounds "Easy Like Sunday Morning" I will go and try that today and post back to let you know how it all worked out.

    Thanx =)

Topic Closed

This topic has been closed to new replies.

About this Topic