Database problem

  • Juuthvk

    (@juuthvk)


    10 years, 3 months ago

    Today, my site started saying there was trouble connecting to the database. After running the WordPress troubleshooter (suggested by wordpress itself, I added a line of code to wp-config.php), this is the error log that came out if it:

    wp_usermeta: 10 clients are using or haven’t closed the table properly
    wp_posts: 26 clients are using or haven’t closed the table properly
    wp_options: Table is marked as crashed
    wp_postmeta: 31 clients are using or haven’t closed the table properly
    wp_term_taxonomy: 2 clients are using or haven’t closed the table properly
    wp_term_relationships: 2 clients are using or haven’t closed the table properly

    What does this mean and how should I solve it?

    Thank you!!

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

    (@interservernet-web-hosting)

    10 years, 3 months ago

    From the error log it is clear that the table wp_options is crashed and it needs to be repaired. You can repair the table from PhpMyAdmin.

    Steps:

    1: Login to PhpMyAdmin
    2: Open the database.
    3: Select the table which needs to be repaired.
    4: At the bottom of the page you can see a drop-down box, and select “Repair table” from the drop-down. This will repair the selected table.

    Once it repaired you will be bale to access website without any issues.

    Thread Starter Juuthvk

    (@juuthvk)

    10 years, 3 months ago

    Thanks @InterServer, I’ll try that!

    Thread Starter Juuthvk

    (@juuthvk)

    10 years, 3 months ago

    Thanks again @InterServer, your solution worked perfectly!

    Do you know what could have caused the table to be damaged like this?

    Kind regards, J

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

The topic ‘Database problem’ is closed to new replies.