Many database error Duplicate entries

  • Resolved satperi

    (@satperi)


    3 years, 6 months ago

    Dear Yoast team,
    i use Yoast SEO plugin for over 2 years without problems, but this time the worst problem happened: Google doesn’t index a lot of our posts due to errors coming from Yoast SEO plugin. I know that this kind of problem has already been mentioned in this forum. I followed the procedure you proposed with “Yoast Test Helper” plugin and after some days, the same problem happens again.
    Due to the great importance of not getting indexed by Google, this is a LAST chance i give to Yoast SEO plugin. If there is no any solution, I will give up and install another plugin and of course i will not ever pay for the Premium version I was thinking of.

    The error logs are the following:

    WordPress database error Duplicate entry ‘11966-11965’ for key ‘PRIMARY’ for query INSERT INTO wp_yoast_indexable_hierarchy (indexable_id, ancestor_id, depth, blog_id) VALUES (‘11966’, ‘11965’, ‘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, WP_REST_Posts_Controller->get_item, WP_REST_Attachments_Controller->prepare_item_for_response, WP_REST_Posts_Controller->prepare_item_for_response, WP_REST_Controller->add_additional_fields_to_object, Yoast\WP\SEO\Routes\Yoast_Head_REST_Field->for_post, Yoast\WP\SEO\Actions\Indexables\Indexable_Head_Action->for_post, Yoast\WP\SEO\Actions\Indexables\Indexable_Head_Action->with_404_fallback, Yoast\WP\SEO\Surfaces\Values\Meta->get_head, Yoast\WP\SEO\Surfaces\Values\Meta->create_html_presentation, 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

    Thanking you in advance for your support (I hope)

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

Viewing 5 replies - 1 through 5 (of 5 total)
  • Jeroen Rotty

    (@jeroenrotty)

    3 years, 6 months ago

    Hey @satperi,

    Thank you for using Yoast SEO and for reaching out!

    Can you let us know what steps you took in the past with the Test Helper plugin? What reset did you run in the past to combat it? I’m wondering what is causing the duplicated primary key though. Would you be able to have a look at that entry number 11966 in the indexable table (not the hierarchy one) what that ID is and what content that is? It might lead us to know what is causing this.

    Just to note though, having this process fail, will not hinder or make any difference towards the output on your site or being indexed or not. If the indexable for a certain post or page is not created, we will just pull the data from the postmeta table for that page. So that is unrelated to your site being indexed or not.

    Thread Starter satperi

    (@satperi)

    3 years, 6 months ago

    Hi Jeroen and thanls a lot for the reply!
    The exact steps i have taken with the Test Helper plugin are the following (from a previous guide in this forum):

    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.

    I’m also wondering what is causing the duplicated primary key (there are many duplicated entries almost every day), and i would much appreciate if you could tell me how to have a look at that entry number 11966 in the indexable table (i’m not a pro web developer, i am electrical engineer and i have studied wordpress cms myself). I know how to enter phpmyadmin and run sql commands.

    So, i ‘m waiting for one more help, hoping to find the source of the problem.
    Best Regards
    Pericles

    Thread Starter satperi

    (@satperi)

    3 years, 6 months ago

    Finally i found entry number 11965 and it is the following post:
    https://www.iptvsat.gr/pistopoihsh-wifi6e-gia-tis-thleoraseis-samsung-neo-qled-8k/
    and entry number 11966 is the featured image of the specific post.

    Actually the specific post has been indexed by Google, as i have seen in Google Search Console…so the indexing problem propably is not generated by Yoast and sorry for getting a little bit angry.

    The only remaining problem is the relatively big number of duplicated entries.

    Plugin Support Maybellyne

    (@maybellyne)

    3 years, 6 months ago

    Hello Satperi,

    I’m sorry that the WordPress database errors persist after resetting the indexables table and migrations with the Yoast Test Helper plugin. Thank you for bringing this issue to our attention! I’m sorry that our plugin caused a problem on your site. A bug report has been created internally and is under review by our product team.

    Workaround
    There is no workaround except resetting the Indexables tables, which you have already done. Be assured it will not cause any adverse impact on your site SEO.

    What’s next?
    Our product team has assessed the issue’s severity and assigned a priority level (highest) to the report. Our developers work on the highest priority issues first. We cannot give you an estimate of when they’ll start working on the issue.

    If you have any further information that may affect the prioritization or help our development team solve this bug, please feel invited to reply to this forum topic, and we’ll share the information with our product team.

    • This reply was modified 3 years, 6 months ago by Maybellyne.
    • This reply was modified 3 years, 6 months ago by Maybellyne.
    Thread Starter satperi

    (@satperi)

    3 years, 6 months ago

    OK thanks!

    Pericles

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

The topic ‘Many database error Duplicate entries’ is closed to new replies.