CRITICAL ERROR after latest update

Hi @g22,

We’re really sorry to hear that you’re getting excessive errors after updating to the latest version of Yoast SEO.

Below are a few questions and steps to take that will hopefully get your site working with the latest version or, at least, provide us with more information to help us troubleshoot:

1. Can you confirm that your site meets minimum server requirements and all your other plugins and themes are updated?

2. We’d like you to reset the Yoast database tables and allow Yoast SEO to reindex the SEO data on the site.

You can use the steps below by either testing this on a staging site or by making a new backup if you haven’t done so already:

1. Install and activate the Yoast Test Helper plugin
2. Go to Tools > Yoast Test
3. Click the “Reset indexables and migrations” button
4. Go to SEO > Tools and under “Optimize SEO Data” click the “Start SEO data optimization” button.

For sites with more than 10,000 posts, we’d advise using the WP CLI command to do the indexation on the server instead of going to SEO > Tools. You can read more about this here: WP CLI – Reindex Indexables command

Do the errors still appear?

I experienced the exact same issue. The issue resolved once I disabled Yoast SEO via FTP, then deleted the error log file that had ballooned in size and crashed the server. It appears some residual damage to the database may also have occurred as a result.

I am also experiencing problems with my site after upgrading this plugin.I am unable to post a new blogposts also.

Hi @limitless_design & @aayush2019

We are sorry you’re having an issue with your website as well.

Per the forum guidelines, we ask that you please create separate topics for the issues you are experiencing. That way it’s easier to track issues and provide assistance on your specific concerns on your specific site. Plus, you will get your own alerts for the issue rather than someone else’s.

You may make a new topic here: https://www.ads-software.com/support/plugin/wordpress-seo/#new-post.

Tried to do data optimisation and it responded with….

Oops, something has gone wrong and we couldn’t complete the optimization of your SEO data. Please click the button again to re-start the process.

@mikes41720 @priscillamc I can’t play mouse and cat on this website. I have a backup running now that works. I’ll let some time so you fix the issue with someone else and wait for an update or come back and check in 2 weeks if it’s resolved.

Please don’t close the ticket.

Thanks.

@g22 We do understand if you’re not able to perform any diagnostic testing on the site due it being a live site. We’ll also keep this forum thread open for an additional week to give you and others additional time to reply back.

As for the issue, have you ever considered setting up a?staging environment?for your tests? This means that you can do all the testing and only change the live site when all works like intended.Your host might be able to helpSome popular web hosts offer quick setups for a staging site so please contact your web host for assistance. They will probably be able to help you out.

Alternative options to set up a staging environmentIf your web host does not offer staging sites, the WordPress plugin repository offers?staging?plugins?or you can?create your own staging site.

We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.

Hi, it’s been one week, I’m curious if there are any developments on this issue?

Thanks.

Just happened on an other client website. This is really annoying.

Hi, I tried updating and as of now (15 minutes since updating), the error_log file isn’t increasing in gigabytes. Still I have an error and would like to know how to resolve it.

[06-Jan-2021 02:34:17 UTC] Erreur de la base de données WordPress Table 'emoment_femmehockey.gf_yoast_indexable' doesn't exist pour la requête INSERT INTOgf_yoast_indexable(object_type,title,breadcrumb_title,permalink,blog_id,description,is_robots_noindex,open_graph_title,open_graph_image,open_graph_image_id,open_graph_description,permalink_hash,created_at,updated_at) VALUES ('home-page', '%%sitename%% %%page%% %%sep%% %%sitedesc%%', 'Accueil', 'https://femme.hockey/', '1', 'Parce que le hockey ne se joue pas que sur la patinoire', '0', '', '', '', '', '21:25c7a6992e68161fa644465dca983646', '2021-01-06 02:34:17', '2021-01-06 02:34:17') faite par require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/kenozoik/framework/modules/blog/templates/lists/masonry/templates/blog-masonry.php'), get_header, locate_template, load_template, require_once('/themes/kenozoik/header.php'), wp_head, do_action('wp_head'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->call_wpseo_head, do_action('wpseo_head'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->present_head, Yoast\WP\SEO\Presenters\Schema_Presenter->present, Yoast\WP\SEO\Presenters\Schema_Presenter->get, Yoast\WP\SEO\Presentations\Abstract_Presentation->__get, Yoast\WP\SEO\Presentations\Indexable_Presentation->generate_schema, Yoast\WP\SEO\Generators\Schema_Generator->generate, Yoast\WP\SEO\Generators\Schema\Organization->generate, Yoast\WP\SEO\Presentations\Abstract_Presentation->__get, Yoast\WP\SEO\Context\Meta_Tags_Context->generate_site_url, Yoast\WP\SEO\Repositories\Indexable_Repository->find_for_home_page, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_home_page, Yoast\WP\SEO\Builders\Indexable_Builder->save_indexable, Yoast\WP\SEO\Models\Indexable->save, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::execute

Thank you!

We are sorry to hear that you’re still seeing an error in the server error log and we can imagine how that could be frustrating for you. Let’s see what’s going on here.

The error you’re seeing occurs in the server error log when Yoast SEO fails to create the {prefix}_yoast_indexable table in the database. Can you please confirm whether you’ve performed the SEO data optimization from the SEO → Tools page? If not, please run the relevant analysis to see whether this resolves the issue for you.

However, if you have already performed the relevant analysis and the issue persists, we’d like you to please reset the Yoast SEO Indexables tables and migrations by following the steps given below:

• Install and activate Yoast Test Helper plugin;
• Go to Tools → Yoast Test → Yoast SEO → Reset Indexables tables & migrations options to reset it;
• Runthe SEO data optimization from Yoast SEO → Tools page.

Let us know whether the issue persists after performing the above suggestions.

@mazedulislamkhan Can you please confirm whether this resolved the issue for you?

It’s not resolved yet, I can’t always work on this website as it is live and there are many visitors. There’s a promotion at the moment and I can’t do this. Please leave this ticket open until I can try the troubleshooting steps.

Hi @g22,

Thanks for the update. We’re sorry to hear that there’s still a problem. Just to make sure that we understand, do you mean that you tried to reset the indexables database tables and that didn’t solve the problem?

We can understand that you’re working with a busy site. Is it possible to set up a staging site or a separate test site where you can test a copy of the site with the latest version of Yoast SEO 15.6.2?