database error Duplicate entry

  • Resolved TedandTom

    (@tedandtom)


    4 years, 5 months ago

    Hi, I got this error yesterday. I have the latest version of Yoast and everything else is up-to-date. Is this something to worry about?

    21-Nov-2021 19:36:27 UTC] WordPress database error Duplicate entry '826-0' for key 'PRIMARY' for query INSERT INTOccbh_yoast_indexable_hierarchy(indexable_id,ancestor_id,depth,blog_id) VALUES ('826', '0', '0', '1') made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/responz/single.php'), get_header, locate_template, load_template, require_once('/themes/responz/header.php'), wp_head, do_action('wp_head'), WP_Hook->do_action, WP_Hook->apply_filters, wp_robots, apply_filters('wp_robots'), WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Front_End\WP_Robots_Integration->add_robots, Yoast\WP\SEO\Integrations\Front_End\WP_Robots_Integration->get_robots_value, Yoast\WP\SEO\Memoizers\Meta_Tags_Context_Memoizer->for_current_page, Yoast\WP\SEO\Repositories\Indexable_Repository->for_current_page, Yoast\WP\SEO\Repositories\Indexable_Repository->find_by_id_and_type, Yoast\WP\SEO\Repositories\Indexable_Repository->upgrade_indexable, Yoast\WP\SEO\Builders\Indexable_Builder->build, 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 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Michael Tiña

    (@mikes41720)

    4 years, 5 months ago

    Hi @tedandtom

    We’re sorry to hear that you’re encountering this issue with the Yoast SEO plugin.

    Could you check if you have the latest version of Yoast SEO v17.6, WordPress 5.8.2, the latest versions of your other plugins and theme, and are meeting the necessary plugin requirements?

    Can you 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.

    For your site’s health and safety, we recommend creating regular backups of your site and database. This is especially important before installing, updating, or removing plugins. Learn more about the benefits of regular backups.

    After resetting the data and redoing the SEO data optimization process, could you check if you are still getting these errors in your database?

    Plugin Support Michael Tiña

    (@mikes41720)

    4 years, 5 months ago

    Hey,

    This thread has been marked as resolved due to lack of activity by original poster.

    If you are not the original poster but have a similar issue, please open a new request.

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

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

Tags