wfhits table issue

You might wanna fix your plugin to avoid these schema mismatches:

INSERT INTO wp_wfhits (…, jsRun, …)
VALUES (…, '', …)

MariaDB behavior in strict mode:

• ” → numeric column
• Value coerces to 0
• Warning is still emitted
• Insert succeeds

So even when changing that column jsRun to TINYINT(1) DEFAULT 0, MariaDB will still log:

WARNING 1366: Incorrect integer value: ''

This is expected behavior in MariaDB 10.4+ so the ALTER of that column doesn’t fix this at all and the warnings still show up in mariadb query error log, and when you have dozen or two of these sites with Wordfence installed that query error log fills up in no time.

It’s obviously a schema / insert value mismatch on your end, and it’s been for a while, so might wanna fix that in versions going forward…