Optimizing SEO data… This may take a year…

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.

Hi @cool_recep,

It sounds like there’s something preventing Yoast SEO from scanning your pages and SEO data. We have a few questions and steps below to help us troubleshoot:

1. Can you confirm that your server meets minimum server requirements and all your other plugins and themes are updated?

2. We’d like you to reset the Yoast database tables and allow Yoast SEO to reindex the SEO data on the site.

You can use the steps below by either testing this on a staging site or by making a new backup if you haven’t done so already:

1. Install and activate the Yoast Test Helper plugin
2. Go to Tools > Yoast Test
3. Click the “Reset indexables and migrations” button
4. Go to SEO > Tools and under “Optimize SEO Data” click the “Start SEO data optimization” button.

For sites with more than 10,000 posts, we’d advise using the WP CLI command to do the indexation on the server instead of going to SEO > Tools. You can read more about this here: WP CLI – Reindex Indexables command

Does the error still appear?

Yes, my server meets all the reqs.

PHP 7.4
Litespeed 5.4.11
OpenSSL/1.1.1h
cURL version 7.73.0
MariaDB 10.3
cPanel 92
PHP memory_limit 256M

OK, did the Yoast database tables reset and the CLI command works now. Will post the results.

Installed Yoast Test Helper and clicked on Reset indexables tables & migrations
ran wp yoast index command via SSH.
This time, the process completed. But after coming back to SEO > Tools, there is still Start SEO data optimization and when I click on it, it starts optimizing, AGAIN!

Hello @cool_recep,

If the “Start SEO data optimization” button reappears even when the analysis completed successfully, there may be an item (i.e. a post or term) on your website that hasn’t been or couldn’t be processed.

Also, does this happen when all non-Yoast plugins were deactivated? If yes, it’s something specific to your WordPress database.

For instance, a table may contain an entry for a value that doesn’t exist in the table, probably, because it was manually deleted from the table directly instead of from the WordPress admin panel.

If you do not feel comfortable to do this yourself or if this does not solve your issue, our Yoast SEO Premium plugin comes with one year of (technical) support.

I did not try it with all the other plugins disabled. We’ll contact technical support.

Thanks.

@cool_recep Thanks for your reply. We’re setting this thread to resolved it you are going to be contacting us via premium support.