WordPress database error Column ‘statusCode’ cannot be null

Update: I’m still seeing these errors on over a dozen of our sites, the only exception being the site I “cleaned” by updating the table structure to allow for NULL no longer reports the errors.

Here’s an example:

[23-Sep-2019 18:25:53 UTC] WordPress database error Column ‘statusCode’ cannot be null for query INSERT INTO wp_wfhits (ctime, statusCode, isGoogle, IP, userID, URL, referer, UA, jsRun, id) VALUES (‘1569263153.148954’, NULL, ‘0’, ‘\0\0\0\0\0\0\0\0\0\0ÿÿÏúêd’, ‘0’, ‘https://xxxxxxxxxx.com/’, ”, ‘Mozilla/5.0 (compatible; MSIE 10.0; Windows NT 6.1; Trident/6.0; .NET CLR 1.1.4322; .NET CLR 1.0.3705; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729) DMBrowser/2.1 (SV)’, ”, ‘0’) made by wfLog->logHit, wfRequestModel->save, wfModel->save, wfModel->insert

Does WordFence have an idea of what is causing these errors? My logs are ballooning to ridiculous sizes.

Thank you.

• This reply was modified 6 years, 5 months ago by a305587.

Thank you Gerroald, I appreciate your time. I have submitted the report via email.

I did not obfuscate the IP address, it actually comes through as that on the error log. And it appears to do this for most entries. I did obfuscate the URL of my site for public display here (although this will be visible to you in the emailed report).

I did try changing how WordFence gets IPs to the 2nd option (Use PHP’s built-in REMOTE_ADDR), but this did not appear to fix the issue. When I checked the error log afterward I was still seeing the errors.

A note on the error logs when you view the emailed report: When I make a change to the settings, I reset the error logs by appending the date to the end of the file. So for example when I tried changing a setting in WordFence on 9/23/19 to test if it fixed the issue, I wanted to reset the error log, so I renamed the old error log “error_log-092319”. I’m explaining this so when you get said report you’ll understand the meaning of all the error logs and the numbers after them. 😉 The error log without a number after it is the current one. Most recent change attempt was me changing how WF gets its IP addresses.

Thanks again for taking the time to look into this, I appreciate your help sir.

Hello Gerroald,

Thank you for your continuing attention to this matter.

This particular issue is affecting every site under our purview (~15 sites across multiple servers) and we have a variety of plugins installed on each site. There are overlaps in the plugins used on each site, however there are many differences depending on the website’s mission.

I’ll pick one site for your query (same one used above from the error log):

* Advanced Custom Fields PRO
* Classic Editor
* Companion Auto Update
* Custom Post Type UI
* Ivory Search
* Jetpack
* LearnPress
* Post Snippets
* Really Simple SSL
* Shortcoder
* Simple CSS
* Slimstat Analytics
* UpdraftPlus Backup/Restore
* Wordfence Security
* WP Crontrol
* WPForms
* WPForms Custom Captcha
* Yoast SEO

These are the only plugins we have installed on every site (common denominators):

* Classic Editor
* Companion Auto Update
* Really Simple SSL
* UpdraftPlus Backup/Restore
* WordFence Security

Thank you again.

Hello Gerroald,

Thank you again for continuing attention. All sites are on a single Bluehost VPS, however they are split between two cPanels. We have control up to WHM level.

Regards

• This reply was modified 6 years, 4 months ago by a305587.