Support » Fixing WordPress » Strange glitch stemming from Establishing a Database Connection

  • Resolved thardus

    (@thardus)


    This is my first time posting on this forum, so I hope these descriptions help!

    I noticed that my blog hadn’t gone through a proper weekly scheduled backup, and when I tried to access the site, I got the error message of “Error Establishing a Database Connection”. I went into the wp-admin and clicked on “Repair and Optimize Database”. It came back and told me to copy and paste this information here:

    wp_posts: 1 client is using or hasn’t closed the table properly
    wp_comments: 4 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 1 client is using or hasn’t closed the table properly
    wp_terms: 12 clients are using or haven’t closed the table properly
    wp_term_relationships: 1 client is using or hasn’t closed the table properly
    wp_commentmeta: 4 clients are using or haven’t closed the table properly

    I was, however, able to login to my site normally after some of the tables were repaired.

    Here are the issues I’d like resolved, if anyone knows how:
    -I cannot update plugins.
    -It keeps saying that I need to auto-update the blog, but it is already the newest version.
    -I no longer am getting backups despite that the weekly backups are setup. This is the main thing I would like fixed.

    I am suspecting there is a bigger problem at hand with all of these tables being broken. Any help is much appreciated!

    The page I need help with: [log in to see the link]

Viewing 2 replies - 1 through 2 (of 2 total)
  • Hi, thardus, & welcome. I guess 1 of the things I’m wondering at this point is whether your database may be exceeding the size that your hosting provider (in this case it appears to be Yahoo), allows. There may also be database corruption–or both problems may coexist simultaneously.

    I’ve done some work w/clients who had Yahoo hosting in the past, but it’s been several years ago, so my memory’s pretty hazy on the subject. Some hosting providers have aplets in their control panels which permit repair of the database. I don’t recall if Yahoo does or not. This can also be done via command line, but, again, I’m not at all certain if Yahoo provides any sort of shell access.

    Part of the problem w/using WordPress plugins to optimize/repair a database is that, w/large databases, the script can time out so the job doesn’t get done. This is why I’m suggesting methods external to WordPress, if at all possible.

    This may require professional intervention, &, if that’s the case, you can post a job on http://jobs.wordpress.net, likely under ‘General’ or ‘Performance’.

    BTW, I just left a comment on your blog regarding buying from smaller companies. That was a pretty interesting article & entirely all too common, unfortunately. A good reminder for consumers to be aware of, especially in light of the upcoming holidays.

    thardus

    (@thardus)

    Thank you for replying and checking into this! Your post helped me to realize that maybe all I needed to do was just try repairing and optimizing the database again. I found a way to get back into it via wp-config.php. So, I think it’s fixed now. Thank you so much for giving me some information and also taking the time to read one of my blog posts and comment on it!

Viewing 2 replies - 1 through 2 (of 2 total)
  • You must be logged in to reply to this topic.