Support » Plugin: Wordfence Security - Firewall & Malware Scan » Dashboard widget causing error messages

  • Resolved andymiller



    Thanks for a really useful plugin. I’ve been getting a series of messages in the PHP error log that all seem to be linked to the Activity Report in the Dashboard widget and are reporting that the table .wp_wfBlockedIPLog doesn’t exist.

    They are all basically similar. Here’s a sample:

    WordPress database error Table '{DELETED BY ME}.wp_wfBlockedIPLog' doesn't exist for query SELECT *, COUNT(IP) as totalIPs, SUM(blockCount) as totalBlockCount
    FROM (SELECT * FROM wp_wfBlockedIPLog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 7 day)) / 86400) GROUP BY IP) t
    GROUP BY countryCode
    ORDER BY totalBlockCount DESC
    LIMIT 10 made by do_action('wordfence-2_page_WordfenceOptions'), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::menu_options, require('/plugins/wordfence/lib/menu_options.php'), wfDashboard->__construct, wfActivityReport->getTopCountriesBlocked

    Does this mean that the .wp_wfBlockedIPLog has been deleted? Can I recreate it?

    I’ve disabled the Dashboard widget for the moment.

    Thanks again.

    • This topic was modified 2 years, 3 months ago by andymiller.
    • This topic was modified 2 years, 3 months ago by andymiller.
Viewing 2 replies - 1 through 2 (of 2 total)
  • Hey @andymiller,

    It does look like the table has been deleted. Can you deactivate and reactive Wordfence to regenerate it and let me know if it helps?



    Thread Starter andymiller


    Hi Gerroald

    Thanks very much for your time and the speedy response. Yes, that seems to have fixed it. I should have thought of deactivating and reactivating!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Dashboard widget causing error messages’ is closed to new replies.