WordPress database error Commands out of sync

  • Resolved bigdrop.gr

    (@bigdropgr)


    2 years, 4 months ago

    Hi! I am getting the below error. Can you please tell me how to fix this?

    WordPress database error Commands out of sync; you can't run this command now for query INSERT INTOcrac_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', '62907', 'product', 'https://carit.gr/?post_type=product&p=62907', NULL, '0', '0', NULL, '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'BAMOER σκουλαρ?κια κρ?κο? SCE830 με κυβικ? ζιρκ?νια, ασ?μι 925, ασημ?', NULL, NULL, NULL, NULL, NULL, '1', '0', NULL, 'draft', '0', '0', NULL, '1', NULL, NULL, '2022-11-21 05:01:40', '2021-11-25 21:32:19', '2', '43:bda860c84eaa206dc677605a99b6d4fa', '2022-11-21 05:01:41', '2022-11-21 05:01:41') made by Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Meta_Watcher->update_indexables, 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

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

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

    (@maybellyne)

    Hello @bigdropgr

    I’m sorry about the WordPress database errors. The error occurred during data insertion into the database table while indexing. 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.

    Do let us know if the error persists afterwards.

    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.

    Thread Starter bigdrop.gr

    (@bigdropgr)

    Hi!
    After I did what you suggested I now get this erros/warnings:

    WordPress database error Commands out of sync; you can't run this command now for query SELECT post_id, meta_key, meta_value FROM crac_postmeta WHERE post_id IN (107074) ORDER BY meta_id ASC made by Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Meta_Watcher->update_indexables, 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_Post_Builder->build, Yoast\WP\SEO\Helpers\Meta_Helper->get_value, WPSEO_Meta::get_value, get_post_custom, get_post_meta, get_metadata, get_metadata_raw, update_meta_cache

    And this one:

    WordPress database error Commands out of sync; you can't run this command now for query SELECT * FROMcrac_yoast_indexableWHEREobject_id= '107074' ANDobject_type= 'post' LIMIT 1 made by Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Meta_Watcher->update_indexables, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->build_indexable, Yoast\WP\SEO\Repositories\Indexable_Repository->find_by_id_and_type, Yoast\WP\Lib\ORM->find_one, Yoast\WP\Lib\ORM->run, Yoast\WP\Lib\ORM::execute

    • This reply was modified 2 years, 3 months ago by bigdrop.gr.
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘WordPress database error Commands out of sync’ is closed to new replies.