Redirects & Captured 404s Not Recording Hits

[totalfood]

Hey Aaron, plugin is working great so far on my work site, and I've installed on my other Wordpress sites to use as well.

One small issue I noticed is that both the Page Redirects and Captured 404 URLs are not recording hits like 404 Redirect used to. I would always use that data to focus on addressing the 404s that were getting a lot of hits.

Hope you can fix this in the next update as it's very helpful. Thanks!

What I Expected To Happen

What Happened Instead

Steps to Reproduce the Bug

[aaron13100]

Hey totalfood. I'd love to help, but I'll need more specific information. For example, when I look at the "Page Redirects" or the "Captured 404 URLs" I can visit the URLs listed there and see the "Hits" count go up. Is that not what you're seeing?
thanks

[totalfood]

No, whether I sort the Hits top to bottom or vice versa, they all show up as 0 Hits. Same for the Captured 404s. See attached screenshots. I just noticed this too on the screenshots, but all of them say they were never used on the Last Used column. Let me know if I need to change a setting. Thanks!

[aaron13100]

Ok. Would you turn on the debug log under the options, then manually test one of the URLS, then view the debug log and send me the results? Maybe an error message will be there. Thanks

…

-Aaron

[totalfood]

Screenshot attached of the debug log. Let me know if you need something else. Thanks!

[aaron13100]

Hey totalfood. I guess this must be the same "Illegal mix of collations" issue that scidave was having. I put in what I think might fix it in version 1.7.4. If it doesn't fix it there should now be an error message in the log when the redirects or captured URLs pages are displayed. Let me know how it goes.
thanks!

[totalfood]

Hey Aaron, I updated to 1.7.4 after we spoke. Still not logging hits. Ran debug again, hit one Page Redirect and one Captured 404, screenshot attached.

Of note, currently I have number of redirects in the plugin: "All (5798) | Manual Redirects (3021) | Automatic Redirects (2777) | Trash (0)"... is it possible the plugin is maxed on memory?

Let me know what you think. Thanks again for your help.

[aaron13100]

hey totalfood. Does the "Logs" tab work correctly? If you view the Logs tab for the URL you tested do the recent hits appear there?
thanks

[aaron13100]

Are you able to offer access to your site or a duplicate site for me to test with?
thanks

[totalfood]

Logs screenshot attached... we're the 173 IP. Let me know if you need any other screenshots to help diagnose.

For your reference, we do have the Redirect option of Yoast SEO Premium activated, but it does not do auto 301 like your plugin. It only does it when we change a post title, or the Regex Redirect which seems to have mixed results.

Thanks! Mark

[totalfood]

[aaron13100]

Hey Mark. I'm not so much interested in the logs as I am interested in whether selecting a specific URL with the "View Logs For:" options on the Logs page works or not. On that page does selecting a specific URL and clicking "View Logs" show only the logs for that URL afterwards? If the specific URL you choose is the one you tested, can you see the most recent request appear there?

Also, are you able to offer access to your site or a duplicate site for me to test with?
thanks

[totalfood]

Understood. I’d prefer not to post a un/pw to a bulletin board, so please email me off Github and I will send you a login. Thanks!

[aaron13100]

Mark,

There's good news and there's bad news. The good news is that the problem seems to be resolved with version 1.8.1. I can see that the issue used to be there, but it seems to have been resolved around the time you upgraded to version 1.8.1. So new requests and redirects are now logged appropriately and the "hits" will appear.

The bad news is that there was no data in the log files (for which URL a user had requested) up to the exact time of the upgrade to version 1.8.1. So unfortunately, that history has been lost. I removed the lines from the database with the missing data.

On the other hand it's a clean slate or a fresh start as far your log goes. Maybe that's good.

Also I noticed another issue with the daily cleanup not running thanks to poking around today. So I'll be able to fix that before anyone else notices, perhaps :)

So it looks like it should work as of now. If there are any issues now then the data must be magically disappearing somehow. Let me know if that happens.

thanks

[totalfood]

Thank you for checking things out. Appreciate the extra effort to bug hunt!

I'll let the plugin run for a couple weeks and see how the data goes. If there's any problems I will check back in. Thanks again.