Multiple database errors

  • Resolved tomeydemarcos

    (@tomeydemarcos)


    1 year, 2 months ago

    When trying to do a scan, mulitple error show like this below:

    WordPress database error: [Unknown column ‘fakegoogle’ in ‘where clause’]
    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: [Unknown column ‘fakegoogle’ in ‘where clause’]
    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: [Unknown column ‘fakegoogle’ in ‘where clause’]
    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: [Unknown column ‘throttle’ in ‘where clause’]
    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: [Unknown column ‘throttle’ in ‘where clause’]
    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: [Unknown column ‘throttle’ in ‘where clause’]
    SELECT SUM(blockCount) 

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

    (@wfpeter)

    1 year, 2 months ago

    Hi @tomeydemarcos, thanks for getting in touch about this.

    I have seen a similar error crop up with a mismatched plugin vs. database version of Wordfence on a site that had been cleaned after a malware infection.

    Update to the latest version of Wordfence if you haven’t already done so, then send a diagnostic report to wftest @ wordfence . com? You can find the link to do so at the top of the Wordfence > Tools > Diagnostics page. Then click on “Send Report by Email”. Please add your forum username where indicated and respond here after you have sent it.

    NOTE: It should look as follows – Screenshot of Tools > Diagnostic > Send by Email

    Thanks,
    Peter.

    Thread Starter tomeydemarcos

    (@tomeydemarcos)

    1 year, 2 months ago

    Hello! Thanks for reply. I tried to send email but i have this error ” There was an error while sending the email.”

    WHat can be the issue?

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

The topic ‘Multiple database errors’ is closed to new replies.