get error after last update

  • Resolved AMIR Heydari

    (@djamir121)


    2 years, 6 months ago

    hi there. after last update yoast in my site. my host’s cpu going to 99% and not coming down. after review the error log in my subdomain i recieve that error and the error log gonna bigger every second. in root site its good but in subdomain site yoast use cpu.

    [14-Sep-2022 21:26:45 UTC] WordPress database error Unknown column 'blog_id' in 'field list' for query INSERT INTOwp_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,open_graph_image_source,open_graph_image_meta,object_published_at,object_last_modified,version,permalink_hash,created_at,updated_at) VALUES ('home-page', '%%sitename%% %%page%% %%sep%% %%sitedesc%%', 'Home', 'https://en.daylinews.ir/', '1', 'Breaking News Around The World', '0', '%%sitename%%', 'https://en.daylinews.ir/wp-content/uploads/2021/01/daylinews.ir-png.png', '0', '', 'set-by-user', NULL, '2021-01-18 09:32:44', '2022-09-11 15:07:19', '2', '24:bc8948df156e51ffe21fb46e803092eb', '2022-09-14 21:26:45', '2022-09-14 21:26:45') made by 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, Yoast\WP\SEO\Routes\Indexing_Route->index_general, Yoast\WP\SEO\Routes\Indexing_Route->run_indexation_action, Yoast\WP\SEO\Routes\Abstract_Indexation_Route->run_indexation_action, Yoast\WP\SEO\Actions\Indexing\Indexable_General_Indexation_Action->index, 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->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

    my site is daylinews.ir and the subdomain is en.daylinews.ir.

    please check it and help to resolve that. i already use yaost help tester plugin and use indexable reset.

    thanks.

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

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

    (@maybellyne)

    Hello Amir,

    I am sorry about the error in your WordPress database table. Please try the following steps:

    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 the specific reset was successful.
    4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your content.

    Please let us know if the reported issue remains after resetting the optimized data.`

    Thread Starter AMIR Heydari

    (@djamir121)

    Hi there. I do the yoast test plugin and reset the indexable and run the optimization. But optimization involve my host cpu and my error log going bigger every second.

    That is my last error line:

    WordPress database error Unknown column 'blog_id' in 'field list' for query INSERT INTOwp_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,open_graph_image_source,open_graph_image_meta,object_published_at,object_last_modified,version,permalink_hash,created_at,updated_at) VALUES ('home-page', '%%sitename%% %%page%% %%sep%% %%sitedesc%%', 'Home', 'https://en.daylinews.ir/', '1', 'Breaking News Around The World', '0', '%%sitename%%', 'https://en.daylinews.ir/wp-content/uploads/2021/01/daylinews.ir-png.png', '0', '', 'set-by-user', NULL, '2021-01-18 09:32:44', '2022-09-14 21:55:33', '2', '24:bc8948df156e51ffe21fb46e803092eb', '2022-09-21 10:14:38', '2022-09-21 10:14:38') made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Raysam.ir/index.php'), get_header, locate_template, load_template, require_once('/themes/Raysam.ir/header.php'), wp_head, do_action('wp_head'), WP_Hook->do_action, WP_Hook->apply_filters, wp_robots, apply_filters('wp_robots'), WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End\WP_Robots_Integration->add_robots, Yoast\WP\SEO\Integrations\Front_End\WP_Robots_Integration->get_robots_value, Yoast\WP\SEO\Memoizers\Meta_Tags_Context_Memoizer->for_current_page, Yoast\WP\SEO\Repositories\Indexable_Repository->for_current_page, 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->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

    Plugin Support devnihil

    (@devnihil)

    @djamir121 We’re sorry to hear that you’re still receiving this error after resetting the indexables data on your site.

    Can you please confirm you are using the most recent release of Yoast SEO version 19.7.1? 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 6.0.2? 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?

    This thread was marked resolved due to a lack of activity, but you’re always welcome to re-open the topic. Please read this post before opening a new request.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘get error after last update’ is closed to new replies.