WordPress database error

Hello Manikandan2021

We are sorry about the database error. Can you please try resetting our indexables in the database tables by following the steps below?

1. Install & activate the?Yoast Test Helper plugin
2. Go to Tools > Yoast Test
3. Locate the Yoast SEO section and click on the ‘Reset indexables tables & migrations’, ‘Reset Prominent words calculation’, and ‘Reset Internal link counter’ buttons. After each click, the page will reload to confirm that each reset was successful. Note: Resetting the optimization doesn’t undo any of the hard work you’ve put into the plugin as the SEO data is also stored in WordPress’ default tables. It’ll just reset the custom Yoast tables that contain the combined data pulled from those default tables.
4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your?content.

For your site’s health and safety, we recommend creating regular backups of your site and database. This is especially important before making important changes on your website.

Maybellyne,

Once Start SEO data optimization button is triggered it keeps on loading, It is been running for more than 3 to 4 hours now but still it is processing, please advise.

Thanks,
Mani

Hi @manikandan2021

Depending on the size of your website, the SEO data optimization process will take a while to complete. If you check the progress bar underneath the SEO data optimization process, it should continue to show the progress over time.

If you open your browser’s console and check the network tab, you can check if it continues to process requests as well. Once the process has completed, could you check if the errors still appear?

Maybellyne,

We have left the optimization to run for a while and we get and issue as 502 gateway error. Please find attached screenshot. Please advise
https://ibb.co/0Dn8fF6

Thanks,
Mani

@manikandan2021 Thanks for your reply and we’re sorry to hear about the continued difficulties.

Can you please let us know whether your site is particularly large?

For sites with more than 10,000 posts, we’d advise using the WP CLI command to do the indexation on the server. You can read more about this here:?https://yoa.st/wp-cli-index

Can you please let us know if this resolves the problems?

Hi,

This thread has been marked as resolved due to a lack of activity.

You’re always welcome to re-open this topic. Please read this post before opening a new request.

Thanks for understanding!