Unknown column ‘estimated_reading_time_minutes’

Installed and activated Yoast Test Helper plugin.
Did Tools → Yoast Test → Yoast SEO → Reset indexables tables & migrations options to reset it;

Then went to Start SEO data optimization
got an error
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.

Error.log returned
PHP Fatal error: Uncaught TypeError: Argument 1 passed to Yoast\WP\SEO\Builders\Indexable_Hierarchy_Builder::is_invalid_ancestor() must be an instance of Yoast\WP\SEO\Models\Indexable, bool given, called in /home/user/public_html/wp-content/plugins/wordpress-seo/src/builders/indexable-hierarchy-builder.php on line 176 and defined in /home/user/public_html/wp-content/plugins/wordpress-seo/src/builders/indexable-hierarchy-builder.php:340
Stack trace:
#0 /home/user/public_html/wp-content/plugins/wordpress-seo/src/builders/indexable-hierarchy-builder.php(176): Yoast\WP\SEO\Builders\Indexable_Hierarchy_Builder->is_invalid_ancestor(false, 340, Array)
#1 /home/user/public_html/wp-content/plugins/wordpress-seo/src/builders/indexable-hierarchy-builder.php(112): Yoast\WP\SEO\Builders\Indexable_Hierarchy_Builder->add_ancestors_for_post(340, 3090, Array)
#2 /home/user/public_html/wp-content/plugins/w in /home/user/public_html/wp-content/plugins/wordpress-seo/src/builders/indexable-hierarchy-builder.php on line 340

@artakevn We’re sorry to hear you are experiencing this issue on your site.

As there were multiple hotfix releases for bugs yesterday, can you please first confirm you are using the most recent version of Yoast SEO, version 15.6.2? You can learn more about updating here: https://yoast.com/help/how-can-i-update-my-free-plugin/

Also, can you confirm you are using WordPress 5.6? You can check by clicking on the W in the top left and selecting About. If you need to update, please check with your host provider. Please know that if you are using an older version of WordPress Core you may experience unexpected behavior with Yoast. This guide explains more: https://yoast.com/why-we-dont-support-old-wordpress-versions/

If you update to the most current version of WordPress and Yoast SEO, does this resolve the issue?

If after ensuring that both WordPress, Yoast SEO, and your other plugins and themes are up to date the issue is still occurring, we’d next recommend performing a conflicting check to see whether another plugin or theme is interfering with the Yoast SEO Plugin. This will help us narrow down the exact cause and determine what the next steps are while saving you time.

The fastest way to do this is to?deactivate all non-Yoast plugins and switch to a standard theme?like?Twenty Nineteen.?Test this on your development or staging site, if you have one. If not, we recommend using the?Health Check & Troubleshooting?plugin. This plugin allows you to run a conflict check?without affecting normal visitors to your site.

If you’re unfamiliar with checking for conflicts, we’d like to point you to a step-by-step guide that will walk you through the process:?How to check for plugin conflicts.

Thank you for quick response.
Looks like uninstall/fresh install fixed the issue.

Thank you

I have the same problem! Reinstalling does not help. The suggested steps do not help! Please help.

I am also having this problem, though not on every page. I had to go back to 15.5 to get my site working again. I’ll hold on updating until I see something about this error in the release notes.

Same issue for me. Deactivating/re-activating has not resolved.

Only occuring on some pages. Can’t see a trend as to which pages.

Same issue here. I have done everything commented above: everything updated, reinstall, deactivate all plugins, default theme, etc. Nothing solved the issue. Please, change the “resolved” status because it is not solved. Please provide some help. Thanks in advance!

What is the exact and complete error message that you are seeing? And which version of Yoast are you running?

I’m running Yoast SEO version 15.6.2 and the exact and complete error message in error log is:

[20-Jan-2021 06:29:02 UTC] Error Unknown column ‘estimated_reading_time_minutes’ in ‘field list’ de la base de datos de WordPress para la consulta UPDATE wp_yoast_indexable SET object_id = ‘10785’, object_type = ‘post’, object_sub_type = ‘post’, permalink = ‘https://rafalabrador.com/informe-mensual-diciembre-2020/’, primary_focus_keyword_score = ’67’, readability_score = ’30’, is_cornerstone = ‘0’, is_robots_noindex = NULL, is_robots_nofollow = ‘0’, is_robots_noimageindex = NULL, is_robots_noarchive = NULL, is_robots_nosnippet = NULL, open_graph_image = ‘https://rafalabrador.com/wp-content/uploads/2021/01/informe-mensual-diciembre-2020.png’, open_graph_image_id = ‘10786’, open_graph_image_source = ‘set-by-user’, open_graph_image_meta = ‘{\”width\”:800,\”height\”:350,\”url\”:\”https://rafalabrador.com/wp-content/uploads/2021/01/informe-mensual-diciembre-2020.png\”,\”path\”:\”/home2/rafaelcl/public_html/rafalabrador.com/wp-content/uploads/2021/01/informe-mensual-diciembre-2020.png\”,\”size\”:\”full\”,\”id\”:\”10786\”,\”alt\”:\”Informe mensual diciembre 2020\”,\”pixels\”:280000,\”type\”:\”image/png\”}’, twitter_image = ‘https://rafalabrador.com/wp-content/uploads/2021/01/informe-mensual-diciembre-2020.png’, twitter_image_id = ‘10786’, twitter_image_source = ‘set-by-user’, primary_focus_keyword = ‘informe mensual de diciembre 2020’, canonical = NULL, title = ‘xxInforme mensual de diciembre 2020 por Rafa Labrador’, description = ‘Por fin damos patada al 2020 y comenzamos 2021 llenos de esperanza. En este informe mensual de diciembre 2020 hago balance del a?o.’, breadcrumb_title = ‘Informe mensual diciembre 2020’, open_graph_title = ‘Informe mensual de diciembre 2020 por Rafa Labrador’, open_graph_description = ‘Por fin damos patada al 2020 y comenzamos 2021 llenos de esperanza. En este informe mensual de diciembre 2020 hago balance del a?o.’, twitter_title = ‘Informe mensual de diciembre 2020 por Rafa Labrador’, twitter_description = ‘Por fin damos patada al 2020 y comenzamos 2021 llenos de esperanza. En este informe mensual de diciembre 2020 hago balance del a?o.’, estimated_reading_time_minutes = ‘8’, author_id = ‘1’, post_parent = ‘0’, number_of_pages = NULL, post_status = ‘publish’, is_protected = ‘0’, is_public = NULL, has_public_posts = NULL, blog_id = ‘1’, schema_page_type = NULL, schema_article_type = NULL, permalink_hash = ’56:68ddacee04407c857331504254fc4c34′, updated_at = ‘2021-01-20 06:29:02’ WHERE id = ‘1345’ realizada por require(‘wp-blog-header.php’), wp, WP->main, WP->parse_request, do_action_ref_array(‘parse_request’), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Posts_Controller->update_item, wp_update_post, wp_insert_post, do_action(‘wp_insert_post’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->build_indexable, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, 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

• This reply was modified 3 years, 10 months ago by rafalabrador.

@rafalabrador thanks. That error seems to be caused by to some missing database settings that should have been applied during the update of our plugin. Can you:

– tell me how you update your plugins, in this case the Yoast plugin? Was this done via a 3rd party (management) tool, or via the WordPress backend?
– verify that installing the Yoast Test Helper plugin and resetting the indexables and migrations does not solve this issue? Because this should completely recreate the necessary tables including all needed settings.

What I’ve also done trying to fix the issue is “Reset Configuration Wizard” in Yoast Test Helper and went through wizard steps. Maybe that helped me to fix the issue. not sure

@djennez Thanks a lot! It worked! I have installed Yoast Test Helper plugin and click on “Reset Indexables tables & migrations” button. After that, I have seen updated my title seo in a post with the information I had written. Also, I have checked that one page changed to NOINDEX as I had done yesterday. So, database is updating and everything seems work fine. Thanks a lot for your help! It’s solved.

@artakevn Thanks! Similar to your comment. It solved with “Reset Indexables tables & migrations”.

@rafalabrador good to know! Though I am still wondering, for our information, how did you update our plugin initially? “Just” by updating via the WordPress backend?

@djennez Always updating via the WordPress backend. Hope this help.

Same trouble.
Fixed by @artakevn tip: Installed and activated Yoast Test Helper plugin.
Did Tools → Yoast Test → Yoast SEO → Reset indexables tables & migrations options to reset it;

After this, everything is fine