WordPress database error Duplicate entry ‘51579-20939’ for key ‘PRIMARY’

  • Resolved mohamed95

    (@mohamed95)


    4 years, 9 months ago

    Hi I am getting this error in our website debug file.
    WordPress database error Duplicate entry '20570-20939' for key 'PRIMARY' for query INSERT INTOwp_yoast_indexable_hierarchy(indexable_id,ancestor_id,depth,blog_id) VALUES ('20570', '20939', '1', '1') 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, WPML_TM_REST_ATE_Public->receive_ate_job, WPML_TM_ATE_Jobs_Actions->update_jobs, WPML_TM_ATE_Jobs_Actions->maybe_apply_translation, WPML_TM_ATE_Jobs->apply, wpml_tm_save_data, WPML_Save_Translation_Data_Action->save_translation, do_action('wpml_pro_translation_completed'), WP_Hook->do_action, WP_Hook->apply_filters, WPML_Media_Translation_Status->save_bundled_media_translation, WPML_Media_Translation_Status->save_attachment_translation, wp_update_post, wp_insert_attachment, wp_insert_post, do_action('edit_attachment'), 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_Hierarchy_Builder->build, Yoast\WP\SEO\Builders\Indexable_Hierarchy_Builder->save_ancestors, Yoast\WP\SEO\Repositories\Indexable_Hierarchy_Repository->add_ancestor, Yoast\WP\Lib\Model->save, Yoast\WP\Lib\ORM->save, Yoast\WP\Lib\ORM::execute

Viewing 4 replies - 1 through 4 (of 4 total)
  • devnihil

    (@devnihil)

    4 years, 8 months ago

    @mohamed95 We’re sorry to hear you are experiencing this error. To resolve this, can you please try the following?:

      1. Install & activate the Yoast Test Helper plugin
      2. Go to Tools -> Yoast Test
      3. Hit the “Reset Indexables & Migrations” button
      4. Under SEO → Tools, click the “Start SEO Data Optimization” button.
    Thread Starter mohamed95

    (@mohamed95)

    4 years, 8 months ago

    Hi @devnihil,

    Thanks for replay, toady morning I checked debug file And I didn’t get any error, The only thing I did is clean database using wp-rocket plugin, I will keep monitoring debug file, And If I get same error Then I will use The above solutions.

    Plugin Support Michael Tiña

    (@mikes41720)

    4 years, 8 months ago

    Hi,

    Yes,

    Please do try and reset the indexables data using the Yoast Test Helper plugin, and re-run the SEO data optimization and please check if it completes successfully, and please let us know if you still continue to see any errors or notices from your WordPress database.

    Thanks!

    Thread Starter mohamed95

    (@mohamed95)

    4 years, 8 months ago

    Hi @mikes41720,

    I checked debug file and I didn’t see any error from WordPress database, So I didn’t do the above step.

    my problem is resolved.

    Thanks!

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘WordPress database error Duplicate entry ‘51579-20939’ for key ‘PRIMARY’’ is closed to new replies.