That is a SQL statement. What is shown in your server error log?
There is nothing on my hosting server’s error logs but this is the error log from my website’s firewall:
https://pastebin.sucuri.net/0lyna8hfkx2jeu6
Can you make any sense of it? I just want to make sure that I’m not dealing with a corrupted database here.
upstream prematurely closed connection while reading response header from upstream
Your server (probably Nginx) is closing the request and returning a 502. I don’t know why this is happening, and it’s something you will need to investigate further. It is unlikely this is directly a problem with Redirection, and it is more likely that it is somehow triggering a server problem.
I doubt it is a corrupted database. However, that is something you can check yourself using SQL.
What happens if you issue that SQL statement yourself? How many redirects do you have? Is your server timing out?
I’m not an expert when it comes to this, but yes, my server shows a timeout error only when I attempt to visit the link. Generally though, my website works fine.
As for checking the SQL, here’s the error I get (from http://sqlfiddle.com/):
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'https://www.contrahealthscam.com/utilcave_com/apps/js/recommended_pages.js?cb=7' at line 1
I don’t know what that means…
Normally, I wouldn’t have cared, but this error has been sitting in Google Search Console since last month and it’s hurting my Google rankings. I just want to be sure that the problem isn’t coming from your plugin.
Also, I checked my database and everything seems fine there. No errors or warnings of corruption there
You likely haven’t copied the SQL properly. It should be:
SELECT * FROM wpfv_redirection_items WHERE match_url='/utilcave_com/apps/js/recommended_pages.js' OR match_url='regex'
How many redirects do you have? Is your server timing out?
it’s hurting my Google rankings. I just want to be sure that the problem isn’t coming from your plugin.
The above problem is not related to your search rankings.
I ran the SQL as you said, and there were no redirects or server timeouts. In fact, the error has disappeared and no longer appears on Google Search Console.
Thanks for your help though. Much appreciated!
