• Resolved nilreb5

    (@nilreb5)


    WF was fine a few hours ago now all the sudden this. I uninstalled and reinstalled and the problem persists. It’s an ANSI_QUOTES enabled issue but I did not change my.ini Did anything change in WF?

    WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT IP, countryCode, unixday, blockType, SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 day)) / 86400) GROUP BY IP ORDER BY blockCount DESC LIMIT 100 WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT IP, countryCode, unixday, blockType, SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 7 day)) / 86400) GROUP BY IP ORDER BY blockCount DESC LIMIT 100 WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT IP, countryCode, unixday, blockType, SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 30 day)) / 86400) GROUP BY IP ORDER BY blockCount DESC LIMIT 100 WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 day)) / 86400) AND blockType IN ("fakegoogle", "badpost", "country", "advanced", "waf") WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 7 day)) / 86400) AND blockType IN ("fakegoogle", "badpost", "country", "advanced", "waf") WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 30 day)) / 86400) AND blockType IN ("fakegoogle", "badpost", "country", "advanced", "waf") WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 day)) / 86400) AND blockType IN ("throttle", "brute") WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 7 day)) / 86400) AND blockType IN ("throttle", "brute") WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 30 day)) / 86400) AND blockType IN ("throttle", "brute") WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 day)) / 86400) AND blockType IN ("blacklist", "manual") WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 7 day)) / 86400) AND blockType IN ("blacklist", "manual") WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT SUM(blockCount) as blockCount FROM wp_wfblockediplog WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 30 day)) / 86400) AND blockType IN ("blacklist", "manual") WordPress database error: [Table 'wordpress.wp_wfblockediplog' doesn't exist] SELECT *, COUNT(IP) as totalIPs, SUM(ipBlockCount) as totalBlockCount FROM (SELECT *, SUM(blockCount) AS ipBlockCount 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
Viewing 1 replies (of 1 total)
  • Plugin Support wfpeter

    (@wfpeter)

    Hi @nilreb5,

    Wordfence is trying to show/report block data, but it has nowhere to read it from, so it looks like the wfblockediplog table is either corrupted or missing.

    If the table is present in phpMyAdmin, you could try an optimize/repair from your hosting control panel. If it turns out the table no longer exists, deactivating and reactivating Wordfence should normally recreate any missing tables. If you do that, make sure to choose “Keep Wordfence tables and data” on deactivation so your existing settings are preserved.

    Let us know how you get on,
    Peter.

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.