WordPress database error Duplicate entry ‘2083-0’ for key ‘PRIMARY

  • Resolved mymediadigital

    (@mymediadigital)


    5 years, 3 months ago

    hi,

    i have many log errors in STDERR log file

    i am using OpenliteSpeed and Avada
    everything is up2date to the latest version (wordpress,yoast,…)

    i tried to install yoast helper plugin and to clear the indexes

    now as a first step to fix the issue i have deleted YOAST plugin

    whats the best recommendation to fix the yoast error?

    WordPress database error Duplicate entry '2083-0' for key 'PRIMARY' for query INSERT INTOwp_yoast_indexable_hierarchy(indexable_id,ancestor_id,depth,blog_id) VALUES ('2083', '0', '1', '1') made by require('wp-blog-header.php'), require_once('wp-includes/template-loader.php'), include('/themes/Avada/single.php'), get_header, locate_template, load_template, require_once('/themes/Avada/header.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\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\Builders\Indexable_Builder->build_for_id_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->save_indexable, do_action('wpseo_save_indexable'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Ancestor_Watcher->reset_children, array_walk, Yoast\WP\SEO\Integrations\Watchers\Indexable_Ancestor_Watcher->update_hierarchy_and_permalink, Yoast\WP\SEO\Builders\Indexable_Hierarchy_Builder->build, Yoast\WP\SEO\Builders\Indexable_Hierarchy_Builder->add_ancestors_for_post, Yoast\WP\SEO\Repositories\Indexable_Repository->find_by_id_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, Yoast\WP\SEO\Builders\Indexable_Builder->save_indexable, do_action('wpseo_save_indexable'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Ancestor_Watcher->reset_children, array_walk, Yoast\WP\SEO\Integrations\Watchers\Indexable_Ancestor_Watcher->update_hierarchy_and_permalink, 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 7 replies - 1 through 7 (of 7 total)
  • Suwash Kunwar

    (@suascat_wp)

    5 years, 3 months ago

    @mymediadigital

    We think that resetting the indexing tables on your site should solve this issue.

    Can you please follow these steps AGAIN and check if the errors are resolved?:

    – Make sure the Yoast SEO plugin is activated.
    – Install & activate the Yoast Test Helper plugin.
    – Go to Tools -> Yoast Test
    – Hit the “Reset indexables & migrations” button
    – Click the “Start processing and speed up your site now” button in SEO > Tools.

    Please note that, while the above instructions are safe, we always recommend having a current, full backup of your site for safety reasons.

    Thread Starter mymediadigital

    (@mymediadigital)

    5 years, 3 months ago

    yes i did all of that

    – Click the “Start processing and speed up your site now” button in SEO > Tools.

    but at this step it fails

    and in java script console i can find this error

    [Error] Failed to load resource: the server responded with a status of 524 () (posts, line 0)

    Suwash Kunwar

    (@suascat_wp)

    5 years, 3 months ago

    Given error indicates that when running the SEO Data Optimization analysis, Cloudflare returns a 524 time out error. Cloudflare has recommendations on how to configure their service to prevent these errors here. If you are unable to complete the process, you may want to temporarily disable Cloudflare to rule out the Cloudflare service.

    Thread Starter mymediadigital

    (@mymediadigital)

    5 years, 3 months ago

    hi thanks for the advice

    i changed cloudflare setting to deactivate the proxy mode
    but still the same issue

    cloudflare usually has 100 seconds timeout issue

    my issue appears after several minutes

    i can also see, as soon as i have YOAST plugin activated server load, memory usage goes from almost zero to almost maximum

    Plugin Support Michael Tiña

    (@mikes41720)

    5 years, 3 months ago

    Hi,

    There was this issue on GitHub that was already closed but it sounds similar to the concern you are having.

    Would it be possible for you to reset the indexables again using the Yoast Test Helper plugin and then trying to re-run it using WP-CLI?

    You can learn more about it here — https://developer.yoast.com/features/wp-cli/reindex-indexables/

    devnihil

    (@devnihil)

    5 years, 3 months ago

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

    Thread Starter mymediadigital

    (@mymediadigital)

    5 years, 3 months ago

    i didnt get this issue solved

    also the way it recommends on github url above didnt solve it

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

The topic ‘WordPress database error Duplicate entry ‘2083-0’ for key ‘PRIMARY’ is closed to new replies.

Tags