Database error webshop (high urgency)

  • Resolved deddensweb

    (@deddensweb)


    8 years, 4 months ago

    Hey there,

    When visiting the page I mentioned (duographics.nl), there is a database error. In Dutch it says “Cannot connect to database”. At first I thought there was a MYSQL password error, so I changed that in both directadmin and wp-config.php.

    When this didn’t solve it I ran the MYSQL repair tool, which didn’t work either. When I ran the wordpress repair tool using the description on this page: http://www.wpbeginner.com/wp-tutorials/how-to-fix-the-error-establishing-a-database-connection-in-wordpress/

    I got the following error log:

    wp_options: Table is marked as crashed and last repair failed
    wp_woocommerce_termmeta: Table ‘xxxxxx_wp1.wp_woocommerce_termmeta’ doesn’t exist

    Note: I changed the db username in the error log for privacy reasons.

    How do I fix this? Thanks in advance.

    Erwin

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

Viewing 3 replies - 1 through 3 (of 3 total)
  • HudsonValleyWebDesign

    (@jaycbrf)

    8 years, 4 months ago

    Sorry, WooCommerce is not part of WordPress. If you are experiencing problems with third party products, please visit their support pages for assistance.

    Thread Starter deddensweb

    (@deddensweb)

    8 years, 4 months ago

    Update: Yes, but I think the problem doesn’t just have to do with woocommerce. When running MYSQL repair tool, I got the following error:
    xxxxxx_wp1.wp_options repair error Can’t create new tempfile: ‘./xxxxxx_wp1/wp_options.TMD’

    I think because of the crash it corrupted wp-options and now also the wp_woocommerce_termmeta is missing as a result?

    Edit update 2 when running optimizer:
    xxxxxx_wp1.wp_options optimize Error Table ‘./xxxxxx_wp1/wp_options’ is marked as crashed and last (automatic?) repair failed
    xxxxxx_wp1.wp_options optimize Error Table ‘wp_options’ is marked as crashed and last (automatic?) repair failed

    • This reply was modified 8 years, 4 months ago by deddensweb.
    • This reply was modified 8 years, 4 months ago by deddensweb.
    • This reply was modified 8 years, 4 months ago by deddensweb.
    Thread Starter deddensweb

    (@deddensweb)

    8 years, 4 months ago

    I have fixed the problem. In my case, the problem was with the table wp_options which was corrupted by the crash. Seems like the wordpress repair tool misdiagnosed.

    In the future this problem can be fixed by:
    1. Connecting to your server using SSH (Putty).
    2. Go to the specific database folder using the command:
    cd /var/lib/mysql/<databasename>
    3. run the command:
    myisamchk -r -f wp_options.MYI
    (change to wp_options to the table which gives the error: is marked as crashed and last (automatic?) repair failed)
    4. Your database should work again!

    • This reply was modified 8 years, 4 months ago by deddensweb.
    • This reply was modified 8 years, 4 months ago by deddensweb.
Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Database error webshop (high urgency)’ is closed to new replies.