SQL query errors for WP_wfhits table

  • Resolved snaphappyme

    (@snaphappyme)


    4 years, 5 months ago

    I have looked at error_Log and found strange query errors. Not sure how to resolve or if it’s a bug?

    WordPress database error Column ‘statusCode’ cannot be null for query INSERT INTO wp_wfhits

    Query log info:

    [18-Oct-2019 04:54:51 UTC] WordPress database error Column ‘statusCode’ cannot be null for query INSERT INTOwp_wfhits(ctime,statusCode,isGoogle,IP,userID,URL,referer,UA,jsRun) VALUES (‘1571374467.424675’, NULL, ‘0’, ‘\0\0\0\0\0\0\0\0\0\0ˇˇe∞«Ò’, ‘0’, ‘http://myWebsiteName.com.au/’, ”, ‘Mozilla/5.0 (Macintosh; Intel Mac OS X 10.13; rv:69.0) Gecko/20100101 Firefox/69.0’, ”) made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), do_action(‘template_redirect’), WP_Hook->do_action, WP_Hook->apply_filters, redirect_canonical, wp_redirect, apply_filters(‘wp_redirect_status’), WP_Hook->apply_filters, wordfence::wpRedirectStatusFilter, wfLog->logHit, wfRequestModel->save, wfModel->save, wfModel->insert

    There are a lot of similar ones.

    • This topic was modified 4 years, 5 months ago by snaphappyme.

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support wfphil

    (@wfphil)

    4 years, 5 months ago

    Hi @snaphappyme

    The conclusion we have come to about this is that your theme or another plugin is incorrectly stripping out the response status code as a null status code isn’t normal.

    We would like to have a look at your Wordfence diagnostics report. Please go to the top of the “Diagnostics” tab on the Wordfence “Tools” page. There will be a “SEND REPORT BY EMAIL” button to send the diagnostics report. Enter wftest [@] wordfence [dot] com as the email and @snaphappyme as the forum username please.

    Once you have emailed me the diagnostics report can you reply here to let me know that it has been sent. This is important in the unlikely event that your installation of WordPress is having an issue with sending mail.

    Thank you.

    Thread Starter snaphappyme

    (@snaphappyme)

    4 years, 5 months ago

    @wfphil

    Thanks for the follow-up.

    I suspect it is a hosting configuration issue.

    We have now changed hosting environment so the log you want will not provide accurate info.

    I will do as requested if the issue returns.

    Thanks

    Plugin Support wfphil

    (@wfphil)

    4 years, 5 months ago

    Hi @snaphappyme

    If it happens again can you send us the following please:

    1) We would like to have a look at your Wordfence diagnostics report. Please go to the top of the “Diagnostics” tab on the Wordfence “Tools” page. There will be a “SEND REPORT BY EMAIL” button to send the diagnostics report. Enter wftest [@] wordfence [dot] com as the email and @snaphappyme as the forum username please.

    2) The PHP error logs, with half an hour of logs either side of the error, sent to wftest [@] wordfence [dot] com. Put @snaphappyme in the email subject field so that we know it is from you.

    3) The server raw access logs, with half an hour of logs either side of the error, sent to wftest [@] wordfence [dot] com. Put @snaphappyme in the email subject field so that we know it is from you.

    4) If a scan was running at the same time then please use the EMAIL ACTIVITY LOG function on the Scan page and send to wftest [@] wordfence [dot] com

    Let me know here when the above has been done.

    • This reply was modified 4 years, 5 months ago by wfphil.
    Thread Starter snaphappyme

    (@snaphappyme)

    4 years, 4 months ago

    @wfphil

    Will do as requested should it return.

    Appreciate your advice and prompt support.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘SQL query errors for WP_wfhits table’ is closed to new replies.