WordPress database error Commands out of sync

  • Resolved Valdinia

    (@valdinia)


    2 years, 11 months ago

    How could we fix this?

    WordPress database error Commands out of sync; you can’t run this command now for query SELECT umeta_id FROM wp_usermeta WHERE meta_key = ‘wp_yoast_notifications’ AND user_id = 1 made by shutdown_action_hook, do_action(‘shutdown’), WP_Hook->do_action, WP_Hook->apply_filters, Yoast_Notification_Center->update_storage, array_walk, Yoast_Notification_Center->store_notifications_for_user, update_user_option, update_user_meta, update_metadata

    Thank you!

Viewing 10 replies - 1 through 10 (of 10 total)
  • Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    2 years, 11 months ago

    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.

    Thread Starter Valdinia

    (@valdinia)

    2 years, 11 months ago

    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.

    Thread Starter Valdinia

    (@valdinia)

    2 years, 11 months ago

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

    Plugin Support Md Mazedul Islam Khan

    (@mazedulislamkhan)

    2 years, 11 months ago

    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.

    Thread Starter Valdinia

    (@valdinia)

    2 years, 11 months ago

    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.

    Plugin Support Michael Tiña

    (@mikes41720)

    2 years, 11 months ago

    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?

    Thread Starter Valdinia

    (@valdinia)

    2 years, 11 months ago

    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}}

    Thread Starter Valdinia

    (@valdinia)

    2 years, 11 months ago

    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 = 'myaddr@example.com' 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!

    Plugin Support devnihil

    (@devnihil)

    2 years, 11 months ago

    @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

    Plugin Support devnihil

    (@devnihil)

    2 years, 11 months ago

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

Viewing 10 replies - 1 through 10 (of 10 total)
  • The topic ‘WordPress database error Commands out of sync’ is closed to new replies.