wp_wfTrafficRates corrupt

  • Resolved greencode

    (@greencode)


    1 year, 10 months ago

    I’ve been getting the following error in the site error log

    [05-Mar-2024 07:52:08 UTC] WordPress database error Incorrect key file for table 'wp_wfTrafficRates'; try to repair it for query INSERT INTO wp_wfTrafficRates (eMin, IP, hitType, hits) VALUES (FLOOR(UNIX_TIMESTAMP() / 60), '\0\0\0\0\0\0\0\0\0\0ÿÿ-ƒÃ6', '404', @wfcurrenthits := 1) ON DUPLICATE KEY UPDATE hits = IF(@wfcurrenthits := hits + 1, hits + 1, hits + 1) made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), do_action('template_redirect'), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::templateRedir, wordfence::doEarlyAccessLogging, wfLog->logLeechAndBlock, wfRateLimit::countHit, wfDB->queryWrite

    I’ve tried to repair the table in phpMyAdmin but it fails:

    Error Incorrect key file for table 'wp_wfTrafficRates'; try to repair it
Error Corrupt

    Am I okay just to delete that table and the plugin will recreate it?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support wfpeter

    (@wfpeter)

    1 year, 10 months ago

    Hi @greencode,

    The wp_wfTrafficRates table stores IPs that are being counted for possible rate limiting. I would first try repairing the table in phpmyadmin if you have that option available to you.

    If you do need to remove the table or can’t repair it, do it before deactivating and re-activating the plugin and it’ll be recreated, yes. The top option to “Keep all Wordfence tables and data” will prevent your settings and other data from being removed when you perform the initial deactivation.

    Thanks,
    Peter.

    Thread Starter greencode

    (@greencode)

    1 year, 10 months ago

    Hi @wfpeter.

    Thanks for this. I have had to go ahead and delete the table as I had already tried the repair.

    Hopefully that’ll do the trick.

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

The topic ‘wp_wfTrafficRates corrupt’ is closed to new replies.