Error Duplicate entry ‘4546-0’ for key ‘PRIMARY’ bij quer

  • Resolved NoWe

    (@nowe)


    3 years, 3 months ago

    hi there this is the error i ma getting, is there a way to solve this?
    I did aleady install and run the Yoast Test Helper to reset the indextables

    [22-Mar-2022 09:13:56 UTC] WordPress databasefout Duplicate entry ‘4546-0’ for key ‘PRIMARY’ bij query INSERT INTO AF42vP_yoast_indexable_hierarchy (indexable_id, ancestor_id, depth, blog_id) VALUES (‘4546’, ‘0’, ‘0’, ‘1’) gemaakt door require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/Divi/includes/builder/frontend-builder/theme-builder/frontend-body-template.php’), get_header, do_action(‘get_header’), WP_Hook->do_action, WP_Hook->apply_filters, et_theme_builder_frontend_override_header, et_theme_builder_frontend_override_partial, require_once(‘/themes/Divi/includes/builder/frontend-builder/theme-builder/frontend-header-template.php’), wp_head, do_action(‘wp_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->call_wpseo_head, do_action(‘wpseo_head’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End_Integration->present_head, 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->get_ancestors, Yoast\WP\SEO\Repositories\Indexable_Hierarchy_Repository->find_ancestors, 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 8 replies - 1 through 8 (of 8 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    3 years, 3 months ago

    Hello Nowe,

    Thanks for reaching out and we are sorry about that WordPress database error. Can you please let us know what version of WordPress and Yoast SEO you have on the site?

    You mentioned that you have already reset the indexables with the Yoast Test Helper plugin. Do you mean that the issue resurfaced? Were you able to complete the SEO data optimization analysis?

    Thread Starter NoWe

    (@nowe)

    3 years, 3 months ago

    WP Version 5.9.2
    Yoast Version 18.4.1
    Yes after resetting the indexables the issue resurfaced

    Plugin Support Michael Tiña

    (@mikes41720)

    3 years, 3 months ago

    Hi @nowe

    Just to clarify, after resetting the indexables using the Yoast Test Helper plugin, did you go to your WP admin dashboard > SEO > Tools and redo the SEO data optimization process and have it complete?

    And it still showed the same ‘WordPress databasefout Duplicate entry ‘4546-0’ for key ‘PRIMARY’ bij query INSERT INTO’ error in the server logs?

    Thread Starter NoWe

    (@nowe)

    3 years, 3 months ago

    yes i did do Dashboard > SEO > Tools and redo the SEO data optimization process and have it complete

    and it still shows/give the error

    [Moderator note: Please, No bumping].

    Plugin Support Michael Tiña

    (@mikes41720)

    3 years, 3 months ago

    Hi @nowe

    We would have expected that resetting the indexables with the Yoast Test Helper plugin and redoing the SEO data optimization process would have addressed this.

    Could you please check if this still occurs (the duplicate entry errors) even with just a default WP theme (e.g. TwentyTwenty) and only Yoast SEO 18.4.1 as the plugin enabled?

    Thread Starter NoWe

    (@nowe)

    3 years, 3 months ago

    ill give that a try

    Plugin Support Michael Tiña

    (@mikes41720)

    3 years, 3 months ago

    Hi,

    Please do try it out by resetting the indexables with the Yoast Test Helper plugin, then redoing the SEO data optimization process, and then checking with a default WP theme and just the Yoast SEO plugin (18.5) and see if the errors still generate in the database.

    Plugin Support Maybellyne

    (@maybellyne)

    3 years, 3 months ago

    Hi,

    This thread has been marked as resolved due to a lack of activity.

    You’re always welcome to re-open this topic. Please read this post before opening a new request.

    Thanks for understanding!

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Error Duplicate entry ‘4546-0’ for key ‘PRIMARY’ bij quer’ is closed to new replies.