database error Column ‘statusCode’ cannot be null

  • Resolved rglcote

    (@rglcote)


    5 years, 3 months ago

    Hello

    WordPress 5.2.2
    PHP version: 7.3.8
    Wordfence 7.4.0

    I have started seeing these errors in my log files:

    WordPress database error Column ‘statusCode’ cannot be null for query INSERT INTO [WORDPRESS_TABLE_PREFIX]wfHits (ctime, statusCode, isGoogle, IP, userID,
    URL, referer, UA, jsRun) VALUES (‘1567076903.685156’, NULL, ‘0’, ‘\0\0\0\0\0\0\0\0\0\0<FF><FF><90>LE\”, ‘0’, [URL], ”, ‘serpstatbot/1.0 (advanced backlink tracking bot; curl/7.58.0; https://serpstatbot.com/; [email protected])’, ”) 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, sharing_process_requests, Share_Reddit->process_request, wp_redirect, apply_filters(‘wp_redirect_status’), WP_Hook->apply_filters, wordfence::wpRedirectStatusFilter, wfLog->logHit, wfRequestModel->save, wfModel->
    save, wfModel->insert

    I didn’t see these errors before. It might be coincidental, though I doubt it, but I have just recently upgraded the PHP version on my webhost form 5.6 to 7.3.

    Any thoughts?

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

  • Hey @rglcote,

    My apologies for the delayed response with this.

    I don’t believe this is going to be due to your PHP upgrade.

    Can you try resetting Wordfence and let me know if it helps?

    https://www.wordfence.com/help/advanced/remove-or-reset/

    Please let me know how it goes.

    Thanks,

    Gerroald

    Thread Starter rglcote

    (@rglcote)

    Hi Gerroald

    I reset the tables using the “delete on deactivation” method. This seems to have fixed the issue, as I have not seen anything in the error_log since. Would you have any idea on what caused it in the first place? I regularly check the error logs and it’s the first time in years that I’ve seen that type of error.

    Cheers and many thanks,
    Richard

    Hey @rglcote,

    Thanks for the update, and happy to hear it.

    It sounds like the table may have become corrupt. Reinstalling it recreated the table. As far as what caused it, it’s tough to say.

    Please let us know if anything else comes up.

    Thanks,

    Gerroald

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘database error Column ‘statusCode’ cannot be null’ is closed to new replies.

Tags