WordPress database error Commands out of sync

We are sorry to hear that you’re having trouble with our plugin. Can you please confirm when exactly do you see the relevant error? Is it when you visit the Yoast SEO dashboard? Are you running the most recent version of everything including WordPress on your website?

We look forward to hearing from you.

Everything is up to date.
This error appears while on the back-end, using the dashboard of the GridBuilder plugin (https://wpgridbuilder.com/) for re-indexing the products after an import (using AllImport plugin). The error appears hundreds of times during re-indexing.
No, it is not happening while visiting your plugin’s dashboard.

People from GridBuilder analyzed the errors and their conclusion is:
These errors don’t have any relation with WP Grid Builder but Yoast plugin.

Thanks for your confirmation. After you import all the products using the WP All Import plugin, we recommend you please run the SEO data optimization (if you haven’t done so) from the SEO → Tools page.

However, if you have already performed the SEO data optimization, we’d like you to please reset the Yoast SEO Indexables tables and migrations after you import the products by following the steps given below:

• Install and activate Yoast Test Helper plugin;
• Go to Tools → Yoast Test → Yoast SEO → Reset indexables tables & migrations options to reset it;
• Run SEO data optimization from the SEO → Tools page.

Let us know whether the issue persists after performing the above steps.

1 – SEO data optimization – done, but the problem is still there.
2 – Yoast Test Helper plugin installed. Indexables tables & migrations reset
3 – SEO data optimization- started, but after a while it reported: “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”, so I had to restart the process, but the error appears again and again.

We have 4,398 active products right now.

Hi @valdinia

We’re sorry to hear that you encountered the ‘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’ message.

Please do refer to this article for further troubleshooting – https://yoast.com/help/seo-data-optimization-not-complete-successfully/

After you are able to troubleshoot further and complete the SEO data optimization, do the relevant errors from your initial message then resolve?

I deleted all products(we had more than 4000 published products).
Now we only have a test post and a few pages.
The “Optimize SEO Data” process went up to almost 100% then it gave the same error:
“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.”

The errors in the console are:
/wp-json/yoast/v1/link-indexing/posts:1 Failed to load resource: the server responded with a status of 500 ()
/wp-json/yoast/v1/link-indexing/posts:1 Failed to load resource: the server responded with a status of 500 ()

—
{“code”:”rest_no_route”,”message”:”No routes were found to match the URL and request method.”,”data”:{“status”:404}}

I also added the “yoast” namespace to Cerber Security plugin settings, in “Access To WordPress REST API” settings. What other settings must be done here, other than this, to allow YOAST to access the REST API? I discussed with our hosting support agent and they impose no restrictions to YOAST on accessing the REST API.

Then I deactivated Cerber Security plugin. Now it works: “SEO data optimization complete”

But even now we find these errors in the debug.log:

[21-May-2021 10:59:58 UTC] WordPress database error Table 'test_rsrc.wp_resyoast_prominent_words' doesn't exist for query TRUNCATE TABLE wp_resyoast_prominent_words made by do_action('admin_post_wordpress-seo-feature-reset'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\Test_Helper\WordPress_Plugin_Features->handle_reset_feature, Yoast\WP\Test_Helper\WordPress_Plugin_Features->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_feature, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_indexables, Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_prominent_words_calculation

[21-May-2021 11:19:01 UTC] WordPress database error Table 'test_rsrc.wp_resgdpr_consent' doesn't exist for the query SELECT * FROM wp_resgdpr_consent WHERE email = '[email protected]' and status = 1; efectuat? de require('wp-blog-header.php'), wp, WP->main, WP->parse_request, do_action_ref_array('parse_request'), WP_Hook->do_action, WP_Hook->apply_filters, rest_api_loaded, WP_REST_Server->serve_request, WP_REST_Server->dispatch, WP_REST_Server->respond_to_request, Yoast\WP\SEO\Routes\Indexing_Route->index_post_links, Yoast\WP\SEO\Routes\Indexing_Route->run_indexation_action, Yoast\WP\SEO\Routes\Abstract_Indexation_Route->run_indexation_action, Yoast\WP\SEO\Actions\Indexing\Abstract_Link_Indexing_Action->index, Yoast\WP\SEO\Builders\Indexable_Link_Builder->build, apply_filters('the_content'), WP_Hook->apply_filters, do_shortcode, preg_replace_callback, do_shortcode_tag, Codelight\GDPR\Components\PrivacyToolsPage\PrivacyToolsPageShortcode->renderPage, Codelight\GDPR\Components\PrivacyToolsPage\PrivacyToolsPageController->render, Codelight\GDPR\DataSubject\DataSubjectAuthenticator->authenticate, Codelight\GDPR\DataSubject\DataSubjectManager->getByLoggedInUser, Codelight\GDPR\DataSubject\DataSubjectManager->getById, Illuminate\Container\Container->makeWith, Illuminate\Container\Container->make, Illuminate\Container\Container->resolve, Illuminate\Container\Container->build, ReflectionClass->newInstanceArgs, Codelight\GDPR\DataSubject\DataSubject->__construct, Codelight\GDPR\Components\Consent\ConsentManager->getAllConsents, Codelight\GDPR\Components\Consent\UserConsentModel->getAll

Now we must reactivate Cerber Security, so what other settings should we make there to allow your plugin to function smoothly?

Thank you!

@valdinia Thanks for your reply.

Regarding the database error you are receiving when attempting to perform the SEO data optimization, instead of using the ‘Start SEO data optimization’ button, can you please try using the WP-CLI command wp yoast index --reindex to do the indexation on the server and let us know whether that allows you to complete it successfully?

You can also read more about this here:?https://yoa.st/wp-cli-index

We are going ahead and marking this issue as resolved due to inactivity. If you require any further assistance please create a new issue.