Title: WF database table broken
Last modified: August 24, 2016

---

# WF database table broken

 *  Resolved [Eccola](https://wordpress.org/support/users/eccola-www/)
 * (@eccola-www)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/wf-database-table-broken/)
 * Hi there,
 * my hosting went down due to memory issues, and after waking up, _wfHits -table
   broke: “Table ‘./user/wp_wfHits’ is marked as crashed and last (automatic?) repair
   failed”
    Data is missing and it won’t take new data. All other tables and data
   are intact.
 * My question is what would be the best way to fix _wfHits?
    DROP & CREATE ?
 * Do you happen to have nice sql I could run with phpMyadmin?
 * Have no clue of table structure and don’t want to hack into the plugin.
 * This is not really a Wordfence _issue_, as it was caused by a force-majeure server
   issue.
 * Any good suggestions?
 * [https://wordpress.org/plugins/wordfence/](https://wordpress.org/plugins/wordfence/)

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

 *  [WFSupport](https://wordpress.org/support/users/wfsupport/)
 * (@wfsupport)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/wf-database-table-broken/#post-6012159)
 * The easiest way to fix would be to
    - export your settings (bottom of options page)
    - check the box to “Delete Wordfence tables and data on deactivation” (bottom
      of options page)
    - deactivate and delete the plugin
    - reinstall it
    - import your settings (bottom of options page)
 * I’m sure there are mysql commands that you could run but this way you are sure
   things are set up the way they should be.
 * tim
 *  Thread Starter [Eccola](https://wordpress.org/support/users/eccola-www/)
 * (@eccola-www)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/wf-database-table-broken/#post-6012164)
 * Thanks WFSupport, greatly appreciated!
 *  Thread Starter [Eccola](https://wordpress.org/support/users/eccola-www/)
 * (@eccola-www)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/wf-database-table-broken/#post-6012167)
 * Unluckily, I lost my Blocked IPs.
    Fortunately, there’s just so many IPs to block.
   🙂
 *  [WFSupport](https://wordpress.org/support/users/wfsupport/)
 * (@wfsupport)
 * [11 years, 1 month ago](https://wordpress.org/support/topic/wf-database-table-broken/#post-6012168)
 * Sorry about that 🙁 Glad it is working again, though.
 * tim
 *  [ymf](https://wordpress.org/support/users/ymf/)
 * (@ymf)
 * [10 years, 11 months ago](https://wordpress.org/support/topic/wf-database-table-broken/#post-6012515)
 * Thanks Tim! I had a similar problem — an error message in the `error_log` file:
 * > WordPress database error Table ‘<db_name>.wp_wfHits’ doesn’t exist for query
   > SHOW FULL COLUMNS FROM `wp_wfHits` made by require(‘wp-blog-header.php’), require_once(‘
   > wp-includes/template-loader.php’), do_action(‘template_redirect’), call_user_func_array,
   > wordfence::templateRedir, wordfence::doEarlyAccessLogging, wfLog->logHit, wfDB-
   > >queryWrite
 * After delete-reinstall the plugin, the problem is gone.

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

The topic ‘WF database table broken’ is closed to new replies.

 * ![](https://ps.w.org/wordfence/assets/icon.svg?rev=2070865)
 * [Wordfence Security - Firewall, Malware Scan, and Login Security](https://wordpress.org/plugins/wordfence/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordfence/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordfence/)
 * [Active Topics](https://wordpress.org/support/plugin/wordfence/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordfence/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordfence/reviews/)

 * 5 replies
 * 3 participants
 * Last reply from: [ymf](https://wordpress.org/support/users/ymf/)
 * Last activity: [10 years, 11 months ago](https://wordpress.org/support/topic/wf-database-table-broken/#post-6012515)
 * Status: resolved