Error establishing a database connection

  • iveet

    (@iveet)


    15 years, 10 months ago

    I dunno why and how it happended. My domain is http://onioholic.com/, it’s hosted on IX Webhosting

    I just found out my website (http://onioholic.com) seems cant show up. It shows “Error establishing a database connection “.

    I googled how to solved this problem, I did change MySQL db username and password, but it didn’t work.

    So that I got back to check MySQL (http://onioholic.com/mysql_test.php), and I think it’s okay and connected successfully. Then I head to http://onioholic.com/wp-admin/ , it shows out “One or more database tables are unavailable. The database may need to be repaired.”

    I followed the instruction(attached pic: error_01), put this code “define(‘WP_ALLOW_REPAIR’, true);” and reload the page (attached pic: error_02), press down the “Repair Database” button, but I got this (attached pic: error_03).

    Now I have no idea about my site, so I need your guys professional assist.

Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator James Huff

    (@macmanx)

    15 years, 10 months ago

    Access your WordPress database via phpMyAdmin (most hosting providers offer this in their control panel), check all of the tables, and choose “Repair tables” from the pull-down menu.

    Thread Starter iveet

    (@iveet)

    15 years, 10 months ago

    Thanks for your reply.I have done it a bit,but didn’t work, too.

    REPAIR TABLE cd_ad_sponsor, cd_ad_sponsor_banners, cd_ad_sponsor_clickthrough, cd_ad_sponsor_excluded, cd_ad_sponsor_program, cd_ad_sponsor_reports, cd_ad_sponsor_revenue, cd_ad_sponsor_rotation, cd_ad_sponsor_schedule, cd_ad_sponsor_zones, refererstat, viewstat, wp_1_commentmeta, wp_1_comments, wp_1_featurific_image_cache, wp_1_links, wp_1_mobilepress, wp_1_ngg_album, wp_1_ngg_gallery, wp_1_ngg_pictures, wp_1_options, wp_1_postmeta, wp_1_posts, wp_1_seo_title_tag_category, wp_1_seo_title_tag_tag, wp_1_seo_title_tag_url, wp_1_social_links, wp_1_social_links_sidebar, wp_1_terms, wp_1_term_relationships, wp_1_term_taxonomy, wp_1_tweet_urls, wp_1_wordtube, wp_1_wordtube_med2play, wp_1_wordtube_playlist, wp_1_wp125_ads, wp_1_yarpp_keyword_cache, wp_1_yarpp_related_cache, wp_blogs, wp_blog_versions, wp_registration_log, wp_signups, wp_site, wp_sitecategories, wp_sitemeta, wp_usermeta, wp_users

    Thread Starter iveet

    (@iveet)

    15 years, 10 months ago

    I got back the CHECK TABLE,

    Something show up

    Problems with indexes of table refererstat
    The indexes PRIMARY and refererstatid seem to be equal and one of them could possibly be removed.

    Problems with indexes of table viewstat
    The indexes PRIMARY and refererstatid seem to be equal and one of them could possibly be removed.

    Problems with indexes of table wp_1_posts
    The indexes crp_related_content and yarpp_content seem to be equal and one of them could possibly be removed.
    The indexes crp_related_title and yarpp_title seem to be equal and one of them could possibly be removed.

    Problems with indexes of table wp_1_tweet_urls
    The indexes url_index and url_index_2 seem to be equal and one of them could possibly be removed.

    Are those could be the main problem for the db connection error?

    Moderator James Huff

    (@macmanx)

    15 years, 10 months ago

    Before digging into that, contact your hosting provider and ensure that your connection details are correct.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Error establishing a database connection’ is closed to new replies.