Yoast Plugin is causing a 502 Bad Gateway

  • Resolved Ally Drez

    (@relp01)


    4 years, 7 months ago

    A bunch of my category pages are getting a 502 Bad Gateway error, as well as when I try to edit a post/page. My nginx server log is spitting out that the error is due to Yoast. When I disable the plugin, it goes away.

    I deleted all the Yoast tables from my database and reinstalled Yoast. It was working better, meaning I could edit pages again but what I mentioned above is still happening. When I load a 502 error, it specifically spits out an error pointing to Yoast. Here is just a part of that error.

    2020/08/12 08:28:39 [error] 14404#14404: *292409 FastCGI sent in stderr: "_indexable' doesn't exist for query SELECT * FROMwp_yoast_indexableWHEREobject_id= '4' ANDobject_type= 'term' LIMIT 1 made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'),...

    The page I need help with: [log in to see the link]

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello @relp01,

    Thanks for reaching out and we are sorry for the inconvenience that may have been caused by our plugin.

    Usually, a 502 Bad Gateway is related to the server and not the Yoast SEO plugin especially since you have reinstalled the plugin. You may want to reach out to your web hosting provider about this.

    Furthermore, please ensure that your site has the right permissions to create these tables in your database – wp_yoast_indexable, wp_yoast_indexable_hierarchy, wp_yoast_migrations, and wp_yoast_primary_term.

    Thank you.

    Thread Starter Ally Drez

    (@relp01)

    @maybellyne I looked at my server before writing this help post. I build and manage my nginx server, myself… so it was easy to deduce the issue to Yoast via the log files. I have many other sites on this particular server, which do not have any issues with Yoast. Therefore, I disabled Yoast on the problem site and discovered that it is for certain a communication issue between Yoast and my server.

    Thank you for the direction, and I will check the right permissions of the database tables particularly to Yoast as you suggested. I will let you know shortly…

    Plugin Support devnihil

    (@devnihil)

    @relp01 Thanks for your reply and please let us know once you’ve had a chance to confirm the database permissions.

    Thread Starter Ally Drez

    (@relp01)

    Sorry, it has been a long day. My database permissions appear fine. I checked via ssh and installed other plugins to play around. Yet Yoast was not able to create the necessary tables only yoast_seo_meta & yoast_seo_links. For now, I had a backup of my site, so I grabbed the tables you guys mentioned. I installed them and all is right in the world. When I have the bandwidth, I plan on recreating the issue to try and figure out what is actually going on.

    Thank you guys for pointing me towards a solution.

    Thread Starter Ally Drez

    (@relp01)

    This is still an issue – I have removed Yoast – completely and the issue is no longer a problem.

    It is now happening on a second site, and all the tables are there. The database has all the correct permissions. I ran site health check and there is literally nothing wrong with it. As for the webserver, it is up to date, current with the latest PHP and MySQL versions. This only started recently with the latest update to Yoast. Once again, I remove Yoast and the issue is gone.

    Thread Starter Ally Drez

    (@relp01)

    This all might be due to a memory limit – I have to test it more detailed but as soon as I put define( ‘WP_MEMORY_LIMIT’, ‘128M’ ); all is right in the world. I had it defaulted to 40…

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Yoast Plugin is causing a 502 Bad Gateway’ is closed to new replies.