Strange messages on Log

Hi @angelo-pagano

Upon checking https://schoolvolley.it/, we do see it is on the latest version of Yoast SEO v17.6. Upgrading to Yoast SEO Premium doesn’t mean that this issue would be resolved. Based on the error message, it looks to be related to some data in the indexables database tables.

Can you please try resetting our indexables in the database tables by following the steps below?
1. Install & activate the?Yoast Test Helper plugin
2. Go to Tools > Yoast Test
3. Locate the Yoast SEO section and click on the ‘Reset indexables tables & migrations’, ‘Reset Prominent words calculation’, and ‘Reset Internal link counter’ buttons. After each click, the page will reload to confirm that each reset was successful. Note: Resetting the optimization doesn’t undo any of the hard work you’ve put into the plugin as the SEO data is also stored in WordPress’ default tables. It’ll just reset the custom Yoast tables that contain the combined data pulled from those default tables.
4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your?content.

For your site’s health and safety, we recommend creating regular backups of your site and database. This is especially important before installing, updating, or removing plugins.

Could you then check if the error messages resolve accordingly?

Hi Michael! I think I was having the same problem as Angelo. Every x seconds the error log say something like this I paste below. Then I ran the plugin Yoast Help as you said and I think it’s fixed. See the last 2 lines. Do you think I fixed the problem or should I do something else? Thank you!

[30-Nov-2021 08:19:14 UTC] Error Unknown column ‘estimated_reading_time_minutes’ in ‘field list’ de la base de datos de WordPress para la consulta UPDATEwp_yoast_indexableSETobject_id= ‘13896’,object_type= ‘post’,object_sub_type= ‘page’,permalink= ‘https://rutadelmate.com/’,primary_focus_keyword_score= ’58’,readability_score= ’90’,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://rutadelmate.com/wp-content/uploads/2019/11/Juan-Flor-Benji-Ruta-del-Mate-1-e1593954026765.jpeg’,open_graph_image_id= ‘10997’,open_graph_image_source= ‘featured-image’,open_graph_image_meta= ‘{\”width\”:1280,\”height\”:720,\”url\”:\”https://rutadelmate.com/wp-content/uploads/2019/11/Juan-Flor-Benji-Ruta-del-Mate-1-e1593954026765.jpeg\”,\”path\”:\”/home/rutadelm/public_html/rutadelmate.com/wp-content/uploads/2019/11/Juan-Flor-Benji-Ruta-del-Mate-1-e1593954026765.jpeg\”,\”size\”:\”full\”,\”id\”:10997,\”alt\”:\”Juan Flor y Benji de Ruta del Mate\”,\”pixels\”:921600,\”type\”:\”image/jpeg\”}’,twitter_image= ‘https://rutadelmate.com/wp-content/uploads/2019/11/Juan-Flor-Benji-Ruta-del-Mate-1-e1593954026765.jpeg’,twitter_image_id= ‘10997’,twitter_image_source= ‘featured-image’,primary_focus_keyword= ‘Ruta del Mate’,canonical= NULL,title= NULL,description= ‘Encuentra en nuestro blog de viajes y destinos toda la información para viajar solo, en pareja y en familia. ?Inspiración viajera para vos y los tuyos!’,breadcrumb_title= ‘Ruta del Mate – blog de viajes’,open_graph_title= NULL,open_graph_description= NULL,twitter_title= NULL,twitter_description= NULL,estimated_reading_time_minutes= ‘5’,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= ‘WebPage’,schema_article_type= NULL,object_last_modified= ‘2021-11-24 13:05:14’,object_published_at= ‘2020-07-05 20:33:13’,version= ‘2’,permalink_hash= ’24:ca3c44238ce131cf18cfb23330756ac0′,updated_at= ‘2021-11-30 08:19:14’ WHEREid = ‘1372’ realizada por require(‘wp-admin/edit-form-blocks.php’), block_editor_rest_api_preload, array_reduce, rest_preload_api_request, rest_do_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, WP_REST_Users_Controller->get_current_item, WP_REST_Users_Controller->prepare_item_for_response, WP_REST_Controller->add_additional_fields_to_object, Yoast\WP\SEO\Routes\Yoast_Head_REST_Field->for_author, Yoast\WP\SEO\Actions\Indexables\Indexable_Head_Action->for_author, Yoast\WP\SEO\Actions\Indexables\Indexable_Head_Action->with_404_fallback, Yoast\WP\SEO\Surfaces\Values\Meta->get_head, Yoast\WP\SEO\Surfaces\Values\Meta->create_html_presentation, 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_Generator->generate_graph, Yoast\WP\SEO\Generators\Schema\Breadcrumb->generate, Yoast\WP\SEO\Presentations\Abstract_Presentation->__get, Yoast\WP\SEO\Presentations\Indexable_Presentation->generate_breadcrumbs, Yoast\WP\SEO\Generators\Breadcrumbs_Generator->generate, Yoast\WP\SEO\Repositories\Indexable_Repository->find_by_id_and_type, Yoast\WP\SEO\Repositories\Indexable_Repository->upgrade_indexable, Yoast\WP\SEO\Builders\Indexable_Builder->build, 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

[30-Nov-2021 09:15:12 UTC] Error Unknown column ‘estimated_reading_time_minutes’ in ‘field list’ de la base de datos de WordPress para la consulta INSERT INTO wp_yoast_indexable (object_type, object_id, object_sub_type, permalink, primary_focus_keyword_score, readability_score, is_cornerstone, is_robots_noindex, is_robots_nofollow, is_robots_noimageindex, is_robots_noarchive, is_robots_nosnippet, open_graph_image, open_graph_image_id, open_graph_image_source, open_graph_image_meta, twitter_image, twitter_image_id, twitter_image_source, primary_focus_keyword, canonical, title, description, breadcrumb_title, open_graph_title, open_graph_description, twitter_title, twitter_description, estimated_reading_time_minutes, author_id, post_parent, number_of_pages, post_status, is_protected, is_public, has_public_posts, blog_id, schema_page_type, schema_article_type, object_last_modified, object_published_at, version, has_ancestors, permalink_hash, created_at, updated_at) VALUES (‘post’, ‘22994’, ‘customize_changeset’, ‘https://rutadelmate.com/?p=22994’, NULL, ‘0’, ‘0’, NULL, ‘0’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ”, NULL, NULL, NULL, NULL, NULL, ‘1’, ‘0’, NULL, ‘trash’, ‘0’, ‘0’, NULL, ‘1’, NULL, NULL, ‘2021-11-30 09:15:12’, ‘2021-11-30 09:15:12’, ‘2’, ”, ’32:deb2a57712adefb20508a5b38f3890b3′, ‘2021-11-30 09:15:12’, ‘2021-11-30 09:15:12’) realizada por do_action(‘wp_ajax_customize_save’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Customize_Manager->save, WP_Customize_Manager->save_changeset_post, wp_insert_post, wp_transition_post_status, do_action(‘transition_post_status’), WP_Hook->do_action, WP_Hook->apply_filters, _wp_customize_publish_changeset, WP_Customize_Manager->trash_changeset_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->build, 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

[30-Nov-2021 09:15:12 UTC] Error Unknown column ‘estimated_reading_time_minutes’ in ‘field list’ de la base de datos de WordPress para la consulta INSERT INTO wp_yoast_indexable (object_type, object_id, object_sub_type, permalink, primary_focus_keyword_score, readability_score, is_cornerstone, is_robots_noindex, is_robots_nofollow, is_robots_noimageindex, is_robots_noarchive, is_robots_nosnippet, open_graph_image, open_graph_image_id, open_graph_image_source, open_graph_image_meta, twitter_image, twitter_image_id, twitter_image_source, primary_focus_keyword, canonical, title, description, breadcrumb_title, open_graph_title, open_graph_description, twitter_title, twitter_description, estimated_reading_time_minutes, author_id, post_parent, number_of_pages, post_status, is_protected, is_public, has_public_posts, blog_id, schema_page_type, schema_article_type, object_last_modified, object_published_at, version, permalink_hash, created_at, updated_at) VALUES (‘post’, ‘22994’, ‘customize_changeset’, ‘https://rutadelmate.com/?p=22994’, NULL, ‘0’, ‘0’, NULL, ‘0’, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, ”, NULL, NULL, NULL, NULL, NULL, ‘1’, ‘0’, NULL, ‘trash’, ‘0’, ‘0’, NULL, ‘1’, NULL, NULL, ‘2021-11-30 09:15:12’, ‘2021-11-30 09:15:12’, ‘2’, ’32:deb2a57712adefb20508a5b38f3890b3′, ‘2021-11-30 09:15:12’, ‘2021-11-30 09:15:12’) realizada por do_action(‘wp_ajax_customize_save’), WP_Hook->do_action, WP_Hook->apply_filters, WP_Customize_Manager->save, WP_Customize_Manager->save_changeset_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->build, 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

[30-Nov-2021 09:28:10 UTC] Error Table ‘rutadelm_wprdm1.wp_yoast_prominent_words’ doesn’t exist de la base de datos de WordPress para la consulta TRUNCATE TABLE wp_yoast_prominent_words realizada por do_action(‘admin_post_wordpress-seo-feature-reset’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\Test_Helper\WordPress_Plugin_Features->handle_reset_feature, Yoast\WP\Test_Helper\WordPress_Plugin_Features->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_indexables, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_prominent_words_calculation
[30-Nov-2021 09:28:28 UTC] Error Table ‘rutadelm_wprdm1.wp_yoast_prominent_words’ doesn’t exist de la base de datos de WordPress para la consulta TRUNCATE TABLE wp_yoast_prominent_words realizada por do_action(‘admin_post_wordpress-seo-feature-reset’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\Test_Helper\WordPress_Plugin_Features->handle_reset_feature, Yoast\WP\Test_Helper\WordPress_Plugin_Features->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_prominent_words_calculation

When you confirm I will delete this code ??

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

@rayuela1 If the error does not show in the log anymore, we are convinced it is resolved.

Thanks!

Yes, no more error in the error_log file. Thank you!

I followed your advice and the error is gone.Thanks.