Dashboard widget causing error messages

  • Resolved andymiller

    (@andymiller)


    5 years, 9 months ago

    Hi

    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 5 years, 9 months ago by andymiller.
    • This topic was modified 5 years, 9 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?

    Thanks,

    Gerroald

    Thread Starter andymiller

    (@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.