• Resolved Angelo

    (@angelo-pagano)


    The webmaster reported me the following error on the schoolvolley.it website. Is it caused by the free version, that is, if I migrate to the premium it won’t be there anymore, or do I have to change some parameters?

    schoolvolley.it [Mon Nov 29 09:41:19 2021] [error] [pid 29100] mod_proxy_fcgi.c(860): [client 207.46.13.182:0] AH01071: Got error 'PHP message: WordPress errore sul database Unknown column 'estimated_reading_time_minutes' in 'field list' per la query INSERT INTOschool_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_…'”

    schoolvolley.it [Mon Nov 29 09:33:51 2021] [error] [pid 29569] mod_proxy_fcgi.c(860): [client 95.246.184.24:0] AH01071: Got error ‘NTO school_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_a...PHP message: WordPress errore sul database Unknown column 'estimated_reading_time_minutes' in 'field list' per la query INSERT INTOschool_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_a…PHP message: WordPress errore sul database Unknown column ‘estimated_reading_time_minutes’ in ‘field list’ per la query INSERT INTO school_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_a...PHP message: WordPress errore sul database Unknown column 'estimated_reading_time_minutes' in 'field list' per la query INSERT INTOschool_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_a…PHP message: WordPress errore sul database Unknown column ‘estimated_reading_time_minutes’ in ‘field list’ per la query INSERT INTO school_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_a...'"

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Michael Tiña

    (@mikes41720)

    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 2 years, 9 months ago by rayuela1.
    Plugin Support Maybellyne

    (@maybellyne)

    @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!

    Thread Starter Angelo

    (@angelo-pagano)

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Strange messages on Log’ is closed to new replies.