Error message in log folder

@anand15 We’re sorry to hear you are experiencing this issue on your site.

To resolve this, can you please try the following?:

1. Install & activate the?Yoast Test Helper plugin
2. Go to Tools -> Yoast Test
3. Hit the “Reset Indexables & Migrations” button
4. Under SEO → Tools, click the “Start SEO Data Optimization” button.

Hi! Thanks your quick answer, I did it to the 3. point. I received this message: “Yoast SEO feature Indexables tables & migrations has been reset.”

But I don’t understand the 4. point and I can’t find this button. It is important, that the meta description, title, any other settings remain.

@anand15

You should see the button “Start SEO Data Optimization” under SEO → Tools.

See attachment: https://prnt.sc/10kj1rp

Ok, thank You, I found it and did it: “SEO data optimization complete” and I will watch the error messages.

@anand15 Thanks for your reply and for confirming you were able to reset the indexables and re-run the SEO data optimization successfully. If you should need any further assistance, please do not hesitate to let us know.

Hi! Thank You. I receive the error message but now from my another website:

[14-Mar-2021 06:00:03 UTC] WordPress database error Duplicate entry ‘(number)’ for key ‘PRIMARY’ (asking) INSERT INTO (my prefix)_yoast_indexable_hierarchy (indexable_id, ancestor_id, depth, blog_id) VALUES (‘(number)’, ‘0’, ‘0’, ‘1’) (make it) require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/themes/jupiter (the name of theme)/single.php’), get_header, locate_template, load_template, require_once(‘/themes/jupiter/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->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

@anand15 ?Thanks for your reply and we’re sorry that you’re also encountering these errors on a different site of yours.

Can you please also try resetting the indexables and re-running the SEO data optimization on this site as well using the steps below?:

1. Install & activate the?Yoast Test Helper plugin
2. Go to Tools -> Yoast Test
3. Hit the “Reset Indexables & Migrations” button
4. Under SEO → Tools, click the “Start SEO Data Optimization” button.

I’m doing it… In the meantime, I see that I receive a new error messages about the other website (where I did this procedure yesterday for Your helping):

[14-Mar-2021 09:51:37 UTC] WordPress database error Duplicate entry ‘(number) for key ‘PRIMARY’ for query INSERT INTO (my prefix)_yoast_indexable_hierarchy (indexable_id, ancestor_id, depth, blog_id) VALUES (‘umber) made by Yoast\WP\SEO\Integrations\Admin\Background_Indexing_Integration->index, Yoast\WP\SEO\Actions\Indexing\Indexable_Post_Indexation_Action->index, 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

@anand15 Thanks for your reply.

We are sorry to hear the issue remains after resetting the indexables & migrations tables on your site; thank you for the efforts you’ve made to troubleshoot this issue. We have received a similar report about this issue before.

The error indicates that the primary key is being reused which should not happen if the table has the correct permissions. Can you please check that the table ‘(my prefix)_yoast_indexable_hierarchy’ has a primary key set for the ID column and is set to auto-increment? If you are not familiar with checking your database settings, your web hosting provider can surely help.

• This reply was modified 3 years, 8 months ago by devnihil.

Hi! Thanks for Your helping and quick answer. I sent this error message to the hosting provider. I’m waiting for his answer.

Beside this yesterday the whole day I did the SEO data optimization, but in about 60-70% stoping. There is about 800 posts and 200 subpages (this is a big webpage).

So, I stop it and I continuos for click to the button. After that on the evening it did just only a little part of it. On night I switched off. Now I started again, and after 1 hour I receive this error message: “Oops, something has gone wrong and we couldn’t complete the optimization of your SEO data. Please click the button again to re-start the process.” And appear a 404 page with my logo.

Despite I tried to start again more than one times, the error message remain on here. Besides this of course I receive the WordPress database error Duplicate entry error messages.

Hi @anand15,

1. Duplicate entry error messages.
The duplicate entry error messages are an issue. Thank you for bringing this issue to our attention. We apologize for the trouble you are experiencing with our plugin. An issue report is currently open with our development team for this issue.

No workarounds are known.

In the meantime, we suggest signing up for our newsletter as that is where we will announce product changes and updates. You may sign-up for it here https://yoast.com/ by scrolling towards the bottom to complete the sign-up field.

2. Oops, something has gone wrong and we couldn’t complete the optimization of your SEO data. Please click the button again to re-start the process
This might be related to the above. We would like some more information.

1. Are all your non-Yoast plugins updated?

2. If you run the SEO data button and then?check for JavaScript errors do any appear on that page in the backend? They would appear in red in the console. Can you describe them or take a screenshot? If you are not sure how to look for JavaScript errors please use this guide?https://yoast.com/help/how-to-find-javascript-errors-with-your-browsers-console/.

Depending on what errors you see you may be able to resolve them by contacting your host provider or adjusting any security plugins.?This guide explains more:?https://yoast.com/help/seo-data-optimization-not-complete-successfully/#error.

Hi!

Yes, I refreshed every plugins of course. I clicked on this button a several times if it can starting (sometimes it doesn’t start the optimization).

I started the optimization again, I need 1-2 hour that I can reproduce this issue?again. I will take a photo of it and I try to find red error message in source code in via Chrome.?

Hi,

OK! A screenshot would be helpful. You can use a tool like: https://imgbb.com/ to share the image.

Hi!

I try to reproduce the error message since yesterday while I make the Yoast optimization, but it just doing the process which never ended. There is currently no error message on this page now.

Another site, where always born new error message:

Currently this is my table schema. First two fields is primary key, but no autoincrement.

+————–+——————+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+————–+——————+——+—–+———+——-+
| indexable_id | int(11) unsigned | NO | PRI | NULL | |
| ancestor_id | int(11) unsigned | NO | PRI | NULL | |
| depth | int(11) unsigned | YES | MUL | NULL | |
| blog_id | bigint(20) | NO | | 1 | |
+————–+——————+——+—–+———+——-+

CREATE TABLE (myprefix)_yoast_indexable_hierarchy (
indexable_id int(11) unsigned NOT NULL,
ancestor_id int(11) unsigned NOT NULL,
depth int(11) unsigned DEFAULT NULL,
blog_id bigint(20) NOT NULL DEFAULT 1,
PRIMARY KEY (indexable_id,ancestor_id),
KEY indexable_id (indexable_id),
KEY ancestor_id (ancestor_id),
KEY depth (depth)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

Please send me the correct table create sql command for all prefix. Thank You!

Thanks for sharing the relevant information with us. We are sorry to hear that you’re still having trouble with our plugin. Due to the nature of the issue, we’ll need to take a look at your setup. However, we are unable to do it here as this is a public forum.

So, if you have an active Yoast SEO Premium subscription or if you can consider buying one, we can investigate the issue further directly on your setup privately through email.

However, if you don’t wish to get the Yoast SEO Premium subscription, that’s completely fine. In this case, you’ll need to troubleshoot the issue further on your setup as we are literally out of any clue at this moment without taking a look at the setup. So, someone from the community might step forward as well who has experienced the issue.

Thanks for your understanding!