Thread Starter
dooza
(@dooza)
Hi @johnny5 , thank you for the link. Logging is enabled. The site is hosted on Cloudways and is using the Breeze caching plugin along with Object Cache Pro. I tried disabling them and it made no difference. We are using iThemes Security as well, are there any know conflicts with that?
Thread Starter
dooza
(@dooza)
Hi @johnny5, I have also deactivated all plugins and switched to TwentyNineteen theme, still no logging going on. What next?
The logging relies on WordPress serving a standard 404 page. If anything stops that happening then the request won’t be logged. For example, a caching system may serve it directly from the cache and bypass WordPress. Another plugin may hijack the request and do it’s own thing.
Do you have any errors in your server log?
I can see that 404s on your site are served using an object cache.
I don’t really have anything else to suggest as this is almost certainly some site specific problem for which I have no insight into.
Thread Starter
dooza
(@dooza)
Hi @johnny5 I switched to a staging site for testing: https://exprodat.indzine.net/ this is where there is no object cache, no varnish, just your plugin and twentynineteen theme.
Just checked the logs:
[Wed Apr 19 11:02:14.749598 2023] [proxy_fcgi:error] [pid 19988:tid 140637403858688] [client 176.35.57.186:0] AH01071: Got error 'PHP message: WordPress database error Unknown column 'domain' in 'field list' for query INSERT INTO
wp_redirection_404
............Sleuth/1.3.8', 'GET', '404') 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, WordPress_Module->template_redirect, Red_404_Log::create'
Thread Starter
dooza
(@dooza)
Hi @johnny5, I have fixed it! From the error it was clear the database tables were out of date. So from the Support tab I applied 2.4, 4.0 and 4.1. It’s now logged everything on staging and live.
Very strange, but glad you got it working.
Thread Starter
dooza
(@dooza)
Hi@johnny5, I think the site had once had this installed but when it was removed it didn’t delete the tables. When I installed it again it didn’t do a DB update.