I am trying to change the URL from http to https but it is not updating the Yoast SEO database. It is throwing me a gateway error. I checked for errors before I ran the update and everything looked good.
Could you tell me a little more about the issue you are experiencing? Here are a couple questions to help:
What do you mean by Yoast database? Could you explain a bit more what you are referring to?
Which URL(s) are giving a gateway error?
Note: This plugin does not update any site files and will only update URLs which are found in the database. Any URLs which are hard coded into code file or any files generated by plugins such as sitemaps will need to be update or regenerated via the plugins which originally created the files. If you are using Yoast to generate sitemaps, it is possibly you need to regenerate them using Yoast’s settings.
Also, be sure to clear any caches you may have. This plugin will clear any standard WordPress caches, but is unable to clear any server or plugin based page caches. Browser caches may also be a factor if only some computers are not seeing the change.
Based on the screenshots it appears the tables which still have links to the old URL are:
wp_commentmeta
wp_postmeta
wp_redirection_404
Is this correct? If so, I’m not seeing a pattern of why these tables would be skipped. They come from 3 different section check-boxes. Unless a section is not checked when the plugin runs, tables are not skipped.
Posts, Pages, Custom Post Types
Comments
Custom tables created by plugins
My hunch is there is something going on with the way the URLs are stored in the database and/or the Old URL and New URL entered when the plugin runs.
How do I do a database dump? I can provide you with the rest. I checked them all and I run it and it throws me a gateway error. So I tried to run them individually.
Do you get the gateway error when you check the box for “Custom tables created by plugins”? If so, it issue is almost certainly being caused by the wp_redirection_404 table. Based on your screenshots from before, this table is massive (70 times the size of any other table) and is likely too large to update.
Hi Anushree,
Could you tell me a little more about the issue you are experiencing? Here are a couple questions to help:
Note: This plugin does not update any site files and will only update URLs which are found in the database. Any URLs which are hard coded into code file or any files generated by plugins such as sitemaps will need to be update or regenerated via the plugins which originally created the files. If you are using Yoast to generate sitemaps, it is possibly you need to regenerate them using Yoast’s settings.
Also, be sure to clear any caches you may have. This plugin will clear any standard WordPress caches, but is unable to clear any server or plugin based page caches. Browser caches may also be a factor if only some computers are not seeing the change.
Have a great day!
Mat Lipe
Hi Mat,
I used another plugin to check if all the updates were made. Looks like these tables were skipped. Can you please help?


Hi Anushree,
Based on the screenshots it appears the tables which still have links to the old URL are:
Is this correct? If so, I’m not seeing a pattern of why these tables would be skipped. They come from 3 different section check-boxes. Unless a section is not checked when the plugin runs, tables are not skipped.
My hunch is there is something going on with the way the URLs are stored in the database and/or the Old URL and New URL entered when the plugin runs.
Are you able to provide the following?
Have a great New Years!
Mat Lipe
Hi Mat –
Hi Anushree,
Do you get the gateway error when you check the box for “Custom tables created by plugins”? If so, it issue is almost certainly being caused by the
wp_redirection_404
table. Based on your screenshots from before, this table is massive (70 times the size of any other table) and is likely too large to update.I did a search and found the Redirection plugin creates the table and it has been known to grow out of control. It appears that you may change the log settings to prevent this from happening, but I can’t say if there is a flush logs options.
I recommend emptying or deleting the
wp_redirection_404
table and then running Go Live with all sections checked.Have a great day!
Mat Lipe