Debug log showing database error

  • Resolved Matija

    (@kasareviews)


    5 years, 10 months ago

    Hi,

    I keep seeing in my debug.log below mentioned 2 WordPress database errors:

    WordPress database error Duplicate entry ‘7083-6’ for key ‘PRIMARY’ for query INSERT INTO klt3_yoast_indexable_hierarchy (indexable_id, ancestor_id, depth, blog_id) VALUES (‘7083’, ‘6’, ‘2’, ‘1’) made by do_action(‘wp_ajax_save-attachment’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_save_attachment, wp_update_post, wp_insert_attachment, wp_insert_post, do_action(‘edit_attachment’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->build_indexable, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, 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

    and also:

    WordPress database error Duplicate entry ‘7083-6838’ for key ‘PRIMARY’ for query INSERT INTO klt3_yoast_indexable_hierarchy (indexable_id, ancestor_id, depth, blog_id) VALUES (‘7083’, ‘6838’, ‘1’, ‘1’) made by do_action(‘wp_ajax_save-attachment’), WP_Hook->do_action, WP_Hook->apply_filters, wp_ajax_save_attachment, wp_update_post, wp_insert_attachment, wp_insert_post, do_action(‘edit_attachment’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Watchers\Indexable_Post_Watcher->build_indexable, Yoast\WP\SEO\Builders\Indexable_Builder->build_for_id_and_type, 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

    Could you tell me why this occurs and how to fix?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Md Mazedul Islam Khan

    (@mazedulislamkhan)

    5 years, 10 months ago

    We are sorry to hear that you’re having trouble. Can you please try resetting the indexables tables & migrations by using the Yoast Test Helper plugin to check whether this resolves the issue for you?

    • Go to Tools → Yoast Test → Yoast SEO → Reset indexables tables & migrations options to reset it.
    • Rerun the indexables analysis from the Yoast SEO → Tools → SEO Data → Start processing and speed up your site now option.
    Thread Starter Matija

    (@kasareviews)

    5 years, 10 months ago

    Hi,

    Thanks for your answer. It seems that fixed mentioned error.

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

The topic ‘Debug log showing database error’ is closed to new replies.