Nginx Error Logs

  • Resolved abbiegator

    (@abbiegator)


    1 week ago

    Hey folks, So I’ve got a bunch of errors appearing from Wordfence in my error logs which I think are due to something being misconfigured from Wordfence.

    2026/08/28 11:21:26 [error] 53270#53270: *58009 FastCGI sent in stderr: "PHP message: WordPress database error Unknown column 'fakegoogle' in 'where clause' for query SELECT SUM(blockCount) as blockCount
    FROM wp_wfblockediplog

    2026-08-28 11:21:26.322 error WHERE unixday >= FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 30 day)) / 86400) AND blockType IN ("fakegoogle", "badpost", "country", "advanced", "waf") made by do_action('toplevel_page_Wordfence'), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::menu_dashboard, require('/plugins/wordfence/lib/menu_dashboard.php'), wfDashboard->__construct, wfActivityReport->getBlockedCount; PHP message: WordPress database error Unknown column 'throttle' in 'where clause' for query 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") made by do_action('toplevel_page_Wordfence'), WP_Hook->do_action, WP_Hook->apply_filt

    2026/08/28 11:21:26 [error] 53270#53270: *58009 FastCGI sent in stderr: "rd->__construct, wfActivityReport->getBlockedCount; PHP message: WordPress database error Unknown column 'blacklist' in 'where clause' for query 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") made by do_action('toplevel_page_Wordfence'), WP_Hook->do_action, WP_Hook->apply_filters, wordfence::menu_dashboard, require('/plugins/wordfence/lib/menu_dashboard.php'), wfDashboard->__construct, wfActivityReport->getBlockedCount" while reading response header from upstream, client: 1.44.109.153, server: <HOST>, request: "GET /wp-admin/admin.php?page=Wordfence HTTP/1.1", upstream: "fastcgi://unix:/run/php/php8.4-fpm.sock:", host: "<HOST>", referrer: "https://<HOST>/wp-admin/"

    The first error appeared several times when I tried to access the wordfence page on my website. So curious what you think.

    These logs also spread out over multiple lines breaking any logging monitoring tool that you might have which is a problem.

    • This topic was modified 1 week ago by abbiegator.
Viewing 1 replies (of 1 total)
  • Plugin Support wfmargaret

    (@wfmargaret)

    1 day, 18 hours ago

    Hi @abbiegator,

    Thank you for reaching out! We found that this is due to ANSI_QUOTES being enabled in the database. I’ve reported it to the team, and we’ve created an issue to resolve this. Unfortunately, I can’t provide timelines or expected release dates on the forums, but you can check our change log at https://wordpress.org/plugins/wordfence/#developers for updates. Thank you again for reporting this!

    Thanks,
    Margaret

Viewing 1 replies (of 1 total)

You must be logged in to reply to this topic.