Table ‘wp_options’ is marked as crashed

  • Resolved bachormee

    (@bachormee)


    7 years, 10 months ago

    Hi,

    I would really appreciate any help urgently! Many of the articles on my website has crashed with below error message. I have tried using the “Repair Table” function in PHPMyadmin but it is still not working.

    Warning: mysqli_query(): (HY000/1194): Table ‘wp_options’ is marked as crashed and should be repaired in /home1/evans/public_html/eatandtravelwithus.com/wp-includes/wp-db.php on line 1924

    Thanks,
    evan

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

Viewing 7 replies - 1 through 7 (of 7 total)
  • Moderator t-p

    (@t-p)

    7 years, 10 months ago

    Repairing the database. Review this codex for some instructions:
    https://codex.wordpress.org/FAQ_Troubleshooting#How_do_you_repair_a_MySQL_database_table.3F

    Thread Starter bachormee

    (@bachormee)

    7 years, 10 months ago

    Hi i have already done that but it is still not working

    Moderator t-p

    (@t-p)

    7 years, 10 months ago

    You have a backup of your DB taken before this problem, try restoring it.

    Or, ask your hosting provider if they have backup of your site. If they, ask them to restore it.

    Thread Starter bachormee

    (@bachormee)

    7 years, 10 months ago

    Hi all,

    Found out that it’s due to the W3 Total Cache plugin. My website started having the above issue after I started using Cloudflare. I disabled the “minify” function on W3TC and it solved the issue. Perhaps it was clashing with the minify function on Cloudflare (though I didn’t enable it in the Cloudflare dashboard). Hope this helps anyone else who has the same issue in future.

    • This reply was modified 7 years, 10 months ago by bachormee.
    • This reply was modified 7 years, 10 months ago by bachormee.
    Moderator t-p

    (@t-p)

    7 years, 10 months ago

    Glad to know it 🙂

    Moderator t-p

    (@t-p)

    7 years, 7 months ago

    @ikone227,

    If you noticed this thread is marked as “resolved”.

    Please do not jump into other topics. If the troubleshooting already posted made no difference for you, then, as per the Forum Welcome, please post your own topic. A lot more people will see your post this way. That way you stand a good chance of getting the assistance you want.

    I’m archiving your reply.

    • This reply was modified 7 years, 7 months ago by t-p.
    thadru

    (@thadru)

    7 years, 4 months ago

    Hi all, also found that the W3 Total Cache plugin was causing problems and the repai wouldn’t work. So I connected via ftp, went to wp-content > plugins and renamed the w3 total cache folder to disable it, then run repair. You may still get an error logging into your admin, so go one folder up in your ftp site and find a file named ‘advanced-config.php’ or something similar, and rename that as well.
    I then was able to log in, and you guessed it, deleted the little shit! hahaha

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

The topic ‘Table ‘wp_options’ is marked as crashed’ is closed to new replies.