Indexing broken after last update

Hi @jdelgadoesteban,

We apologize for any issues you’re having with Yoast SEO and your site.

Resetting the Yoast database tables and re-installing Yoast SEO 14.1 might solve the problem.

To reset the tables, install the Yoast Test Helper, then go to Tools > Yoast Test. Click “Reset indexables & migrations” to delete the tables.

You can find the steps to install or update the plugin manually here: https://yoast.com/help/how-can-i-update-my-free-plugin/#ftp

Be sure to click the “Speed up your site now” button to re-index your pages. If you have a large site or prefer to do this from the command line, you can run the Yoast SEO WP CLI command here: https://developer.yoast.com/customization/yoast-seo/indexables-cli/

Hope this helps!

Request Timeout

This request takes too long to process, it is timed out by the server. If it should not be timed out, please contact administrator of this web site to increase ‘Connection Timeout’.

Our server company has actually now disabled both plugins as they have observed a massive amount of requests to the database.

For extremely large sites or sites that time out, we recommend doing nothing. I know it might sound strange but hear me out.

Yoast SEO will “lazy load” the new indexables feature as you, your authors, and your visitors read, write, and update content. In a few weeks, try running the site wide scan again. If it still times out, you can continue to lazy load the content on your site until the process is low enough for your server resources or ask your server admin or web host to temporarily increase the timeout length while the process completes. Once it’s done, you should not need to do it again.

Hello and thanks for the reply, as mentioned our AWS cloud server has actually crashed due to the plugin. Our site is not even that big and we can see online that there are many people having the same issues. We have now uninstalled the plugins until you fix it.

This process keeps on going on in a loop even if we dont index the site

DELETE wyi FROM wp_yoast_indexable wyi INNER JOIN wp_yoast_indexable wyi2 WHERE wyi2.object_id = wyi

In theory, we completed the indexation that the plugin is failing at using WP-CLI, however the site is still riddled with time out errors. Deleting the plugins has fixed everything. I am glad we did not go for the paid version of the plugin.

[spacewha@carbon public_html]$ wp yoast index
Indexing posts 100% [=================================================================================================================] 0:00 / 0:00
Indexing terms 100% [=================================================================================================================] 2:57 / 4:17

Hi,

We apologize for the difficulties the plugin is causing for you. In v14.1 of Yoast we included some code which would help delete duplicate indexables. It was set to run that query:

DELETE wyi FROM wp_yoast_indexable wyi INNER JOIN wp_yoast_indexable wyi2 WHERE wyi2.object_id = wyi

See: https://github.com/Yoast/wordpress-seo/issues/15065

It appears there may be an issue with how it performs. Based on the information you provided, we expect this to be a bug. We’re actively using the bug tracking on our GitHub repository so your best next step would be to create a new issue for our developers at https://github.com/Yoast/wordpress-seo/issues/new. You will need an account to create a new issue. If this is your first bug report, please check out: https://kb.yoast.com/kb/how-to-write-a-good-bug-report/.

We’re marking this issue as resolved due to inactivity. If you’d like further assistance, please create a new issue.

Thanks, as mentioned we have now migrated to RankMath.