Error Duplicate entry ‘6883-6822’ for key ‘PRIMARY’

  • Resolved ssoulless

    (@ssoulless)


    4 years, 5 months ago

    During the maintenance of our site we turn off all plugins and after some tests we turn them all on again, after a couple of hours we started to notice some weird errors in our log file:

    Error Duplicate entry '6883-6822' for key 'PRIMARY' de la base de datos de WordPress para la consulta INSERT INTO'wp_yoast_indexable_hierarchy'('indexable_id','ancestor_id','depth','blog_id') VALUES ('6883', '6822', '1', '1') realizada por do_action('wp_ajax_save-attachment'), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_save_attachment, 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

    Not sure what this means, the only thing we did was to turn off and then turn on the plugin…

    • This topic was modified 4 years, 5 months ago by ssoulless.
Viewing 4 replies - 1 through 4 (of 4 total)

  • Hi @ssoulless ,

    We are sorry to hear about the issue you are having. The “duplicate entry” error occurs when the Yoast SEO plugin cannot complete the relevant MySQL query to add the relevant data into the Yoast SEO Indexables tables and as such, it throws the related error.

    To investigate the issue further, we would like you to please perform the following steps:
    1. Install and activate the Yoast Test Helper plugin.
    2. Go to the Tools → Yoast Test → Yoast SEO and click on the “Reset indexables tables & migrations” button.
    3. Go to SEO → Tools and run the “Start processing and speed up your site now” again to run the new indexables analysis.

    Can you let us know if it resolves the issue?

    Thread Starter ssoulless

    (@ssoulless)

    Thanks, I have done what you specified, it seems the error has been fixed, however, I will wait a couple of hours since this error occurs randomly.

    Plugin Support Michael Ti?a

    (@mikes41720)

    Hi,

    If you were able to reset the indexables tables & migrations and re-run the indexables analysis without any further issue, we would expect that the issue would indeed have been resolved. Please do let us know if if you encounter any other issues or concerns, or if we can set the thread to resolved accordingly. Thank you!

    Plugin Support devnihil

    (@devnihil)

    We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Error Duplicate entry ‘6883-6822’ for key ‘PRIMARY’’ is closed to new replies.