Title: Continuous error in Error Log
Last modified: January 7, 2024

---

# Continuous error in Error Log

 *  Resolved [ignitionmedia](https://wordpress.org/support/users/ignitionmedia/)
 * (@ignitionmedia)
 * [2 years, 5 months ago](https://wordpress.org/support/topic/continuous-error-in-error-log/)
 * This is a continuation of [https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-deadlock-found/](https://wordpress.org/support/topic/wordpress-database-error-duplicate-entry-deadlock-found/)
   as it has not been resolved.
 * [24-Dec-2023 14:06:35 UTC] WordPress database error Duplicate entry ‘2-0’ for
   key ‘PRIMARY’ for query INSERT INTO `w4pw_yoast_indexable_hierarchy` (`indexable_id`,`
   ancestor_id`, `depth`, `blog_id`) VALUES (‘2’, ‘0’, ‘0’, ‘1’) made by require(‘
   wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’),
   require_once(‘wp-settings.php’), do_action(‘init’), WP_Hook->do_action, WP_Hook-
   >apply_filters, capitalize_tag_names, wp_update_term, do_action(‘edited_term’),
   WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\
   Indexable_Term_Watcher->build_indexable, Yoast\WP\SEO\Builders\Indexable_Builder-
   >build_for_id_and_type, 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
 * My error log is spitting out the above error in mass amounts, which I believe
   could be leading to the slowness of my website.
 * I have already tried the following instructions, but they did not help at all:
 * — start previously provided instructions—
 * Can you retry resetting SEO data once again and retrying the optimization via
   the WP CLI approach? This has helped some users in the past. To reset the data,
   please follow these steps:
    - Install & activate the [Yoast Test Helper](https://wordpress.org/plugins/yoast-test-helper/)
      plugin
    - Go to your WordPress admin dashboard > Tools (sidebar) > Yoast Test
    - 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.
 * Now that we have removed any previously stored data, **use the [WP-CLI commands](https://developer.yoast.com/blog/yoast-seo-wp-cli-index-command/).**
   This requires access to your server through a terminal service. Your web host
   may be able to help. If you have a large site, we highly recommend this method.
 * — end previously provided instructions—
 * Can you please offer further assistance?
    -  This topic was modified 2 years, 5 months ago by [ignitionmedia](https://wordpress.org/support/users/ignitionmedia/).
 * The page I need help with: _[[log in](https://login.wordpress.org/?redirect_to=https%3A%2F%2Fwordpress.org%2Fsupport%2Ftopic%2Fcontinuous-error-in-error-log%2F%3Foutput_format%3Dmd&locale=en_US)
   to see the link]_

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

 *  Plugin Support [Maybellyne](https://wordpress.org/support/users/maybellyne/)
 * (@maybellyne)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/continuous-error-in-error-log/#post-17336802)
 * Hello [@ignitionmedia](https://wordpress.org/support/users/ignitionmedia/),
 * I’m sorry that the issue persists. Due to the nature of the issue, we’ll need
   to take a look at your setup. However, we cannot do it here as this is a public
   forum. So, if you could consider purchasing a Yoast SEO Premium subscription 
   since it comes with email support, we can investigate the issue further directly
   on your setup privately.
 *  Thread Starter [ignitionmedia](https://wordpress.org/support/users/ignitionmedia/)
 * (@ignitionmedia)
 * [2 years, 4 months ago](https://wordpress.org/support/topic/continuous-error-in-error-log/#post-17336807)
 * I ended up switching to rankmath, so problem solved.

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

The topic ‘Continuous error in Error Log’ is closed to new replies.

 * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908)
 * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/)
 * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/)

 * 2 replies
 * 2 participants
 * Last reply from: [ignitionmedia](https://wordpress.org/support/users/ignitionmedia/)
 * Last activity: [2 years, 4 months ago](https://wordpress.org/support/topic/continuous-error-in-error-log/#post-17336807)
 * Status: resolved