InstantWordPress DB Errors

  • Resolved jaymethunt

    (@jaymethunt)


    12 years, 5 months ago

    I’m not actually certain that the wordpress version is correct. I’m using InstantWordpress version 4.3 without any updates.

    The other day, my niece tried to get into her personal “diary” on her usb charm (the portable WordPress site I set up for her). Instead of it working as normal, she received a 500 error.

    Upon further investigation, I found it was actually a DB error. So, altered the wp-config file to add define(‘WP_ALLOW_REPAIR’, true);. Then out to wp-admin/maint/repair.php to repair the problem. Selected repair, and these results returned:

    wp_users: 1 client is using or hasn’t closed the table properly
    wp_usermeta: 9 clients are using or haven’t closed the table properly
    wp_posts: 16 clients are using or haven’t closed the table properly
    wp_links: 13 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 17 clients are using or haven’t closed the table properly
    wp_terms: 10 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 16 clients are using or haven’t closed the table properly
    wp_term_relationships: 15 clients are using or haven’t closed the table properly

    I’m *guessing* that my niece isn’t closing her instance of InstantWP correctly and just pulling out the usb instead. Bad for DBs, without a doubt! I’ll correct that usage error, but need a fix for this DB problem before I can even show her the correct way to unmount a DB. 🙂

    Thanks for any assistance you can give!

    ~Jay

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter jaymethunt

    (@jaymethunt)

    12 years, 5 months ago

    The actual version of WordPress is 3.5.2.

    Thread Starter jaymethunt

    (@jaymethunt)

    12 years, 5 months ago

    Found this suggestion and it worked:

    For whatever reason, the .htaccess file can become corrupt (perhaps due to a plugin however many things could cause it). So all you have to do is correct your .htaccess file and you should be able to see your site again.

    How To Fix The WordPress Internal Server Error

    Here is what you need to do :

    Back up your current .htaccess file.
    Delete all of the information from your .htaccess file and save it i.e. upload a blank .htaccess file.
    Your blog should now be usable again so go into the admin area and set your permalink structure again.
    Open your new working .htaccess file in an editor. Now copy over all the non WordPress .htaccecss information from your old backed up .htaccess file eg. any search engine htaccess information, ip blocks etc – basically everything Non-WordPress that you added before.
    If you find that adding all the code from the previous .htaccess file is causing an Internal Server Error again then remove it all and enter the information back to the working .htaccess file line by line to see what is causing the problem.

    Bear in mind, this might not resolve every Internal Server Error you get though if you suddenly get this error on your WordPress blog, this is the first thing I recommend doing before contacting your host or looking for an alternative solution.

    Read more at http://www.bloggingtips.com/2009/07/05/fix-wordpress-internal-server-error/#L4vMbLEmwxWVA15R.99

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

The topic ‘InstantWordPress DB Errors’ is closed to new replies.