• Resolved RezaY

    (@mohammad983)


    I get this error. what should I do?

    [09-Nov-2020 16:05:26 UTC] خطای Commands out of sync; you can’t run this command now در پایگاه‌داده وردپرس برای دستور SELECT umeta_id FROM tc_usermeta WHERE meta_key = ‘wp_yoast_notifications’ AND user_id = 1 ساخته شده توسط 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

    [09-Nov-2020 16:05:26 UTC] خطای Commands out of sync; you can’t run this command now در پایگاه‌داده وردپرس برای دستور SHOW FULL COLUMNS FROM wp_usermeta ساخته شده توسط 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, add_metadata

Viewing 12 replies - 1 through 12 (of 12 total)
  • Plugin Support Michael Tiña

    (@mikes41720)

    Hi,

    We’re sorry to hear that you’re encountering issues with the Yoast SEO for WordPress plugin.

    Can you confirm you are using the latest version of WordPress 5.5.3, Yoast SEO for WordPress 15.2.1, and the latest version of your other plugins and themes? Could you also check if you are meeting the necessary plugin requirements?

    We understand you are getting this error from your database. Is the Yoast SEO plugin working just fine from your WordPress menu dashboard? Or are there also any visible error messages or notifications appearing from the dashboard?

    Thread Starter RezaY

    (@mohammad983)

    I used the last version of WordPress.
    and I have all the necessary plugin requirement.

    it works fine in WordPress menu dashboard but I have a lot of this bug in the debug’s file

    Thread Starter RezaY

    (@mohammad983)

    unfortunately this line added to bugs too

    
    [10-Nov-2020 11:33:59 UTC] PHP Notice:  تابع wpdb::prepare به طور<strong>نادرست</strong> فراخوانی شد. آرگومان کوئری wpdb::prepare() باید دارای نگهدارندهٔ مکان (placeholder) باشد. لطفاً برای اطلاعات بیشتر، <a href="https://wordpress.org/support/article/debugging-in-wordpress/">اشکال زدایی در وردپرس</a> را مشاهده کنید. (این پیام در نگارش 3.9.0 افزوده شده است.) in /public_html/wp-includes/functions.php on line 5229
    [10-Nov-2020 11:33:59 UTC] خطای You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 24 در پایگاه‌داده وردپرس برای دستور SELECT COUNT(ID)
    			FROM wp_posts
    			WHERE
    				(
    					ID NOT IN (
    						SELECT object_id
    						FROM wp_yoast_indexable
    						WHERE
    							link_count IS NOT NULL
    							AND object_type = 'post'
    					)
    					OR
    					ID IN (
    						SELECT DISTINCT post_id
    						FROM wp_yoast_seo_links
    						WHERE
    							target_indexable_id IS NULL
    							AND <code>type</code> = 'internal'
    							AND target_post_id IS NOT NULL
    							AND target_post_id != 0
    					)
    				)
    				AND post_status = 'publish'
    				AND post_type IN ()
    			
    			 ساخته شده توسط do_action('admin_init'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast\WP\SEO\Integrations\Admin\Background_Indexing_Integration->register_shutdown_indexing, Yoast\WP\SEO\Integrations\Admin\Background_Indexing_Integration->get_unindexed_count, Yoast\WP\SEO\Actions\Indexing\Abstract_Link_Indexing_Action->get_total_unindexed
    [10-Nov-2020 11:34:02 UTC] PHP Notice:  تابع wpdb::prepare به طور<strong>نادرست</strong> فراخوانی شد. آرگومان کوئری wpdb::prepare() باید دارای نگهدارندهٔ مکان (placeholder) باشد. لطفاً برای اطلاعات بیشتر، <a href="https://wordpress.org/support/article/debugging-in-wordpress/">اشکال زدایی در وردپرس</a> را مشاهده کنید. (این پیام در نگارش 3.9.0 افزوده شده است.) in /home/timecode/public_html/wp-includes/functions.php on line 5229
    [10-Nov-2020 11:34:02 UTC] خطای You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')' at line 24 در پایگاه‌داده وردپرس برای دستور SELECT COUNT(ID)
    			FROM wp_posts
    			WHERE
    				(
    					ID NOT IN (
    						SELECT object_id
    						FROM wp_yoast_indexable
    						WHERE
    							link_count IS NOT NULL
    							AND object_type = 'post'
    					)
    					OR
    					ID IN (
    						SELECT DISTINCT post_id
    						FROM wp_yoast_seo_links
    						WHERE
    							target_indexable_id IS NULL
    							AND <code>type</code> = 'internal'
    							AND target_post_id IS NOT NULL
    							AND target_post_id != 0
    					)
    				)
    				AND post_status = 'publish'
    				AND post_type IN ()
    • This reply was modified 5 years, 6 months ago by RezaY.

    @mohammad983 If you have already confirmed both Yoast SEO and WordPress are up to date and the issue is still occurring, can you please try the following:

      1. Install & activate the Yoast Test Helper plugin
      2. Go to Tools -> Yoast Test
      3. Hit the “Reset Indexables & Migrations” button
      4. Under SEO → Tools, click the “Start SEO Data Optimization” button.
    Thread Starter RezaY

    (@mohammad983)

    @devnihil I did it but again I get the bottom bugs, specially when I want to publish a post:

    
    [11-Nov-2020 14:43:11 UTC] خطای Commands out of sync; you can't run this command now در پایگاه‌داده وردپرس برای دستور SELECT umeta_id FROM wp_usermeta WHERE meta_key = 'tc_yoast_notifications' AND user_id = 1 ساخته شده توسط 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
    
    [11-Nov-2020 14:43:11 UTC] خطای Commands out of sync; you can't run this command now در پایگاه‌داده وردپرس برای دستور SHOW FULL COLUMNS FROM <code>wp_usermeta</code> ساخته شده توسط 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, add_metadata

    @mohammad983 We’re sorry to hear that you’re still experiencing this error.

    Can you please confirm you are using the most recent Yoast v15.2.1? You can learn more about updating here: https://kb.yoast.com/kb/how-can-i-update-my-free-plugin/

    Also, can you confirm you are using WordPress 5.5.3? You can check by clicking on the W in the top left and selecting About. If you need to update, please check with your host provider. Please know that if you are using an older version of WordPress Core you may experience unexpected behavior with Yoast. This guide explains more: https://yoast.com/why-we-dont-support-old-wordpress-versions/

    ​If you update to the most current version of WordPress, does this resolve the issue?

    If you have already confirmed that both Yoast SEO and WordPress are up to date and the issue is still occurring, we would next recommend performing a conflict check to determine whether another plugin or theme is interfering with the Yoast plugin. The fastest way to do this is to deactivate all non-Yoast plugins and switch to a standard theme like Twenty Nineteen. Test this on your development or staging site, if you have one. If not, we recommend using the Health Check & Troubleshooting plugin. This plugin allows you to run a conflict check without affecting normal visitors to your site.

    If you’re unfamiliar with checking for conflicts, we’d like to point you to a step-by-step guide that will walk you through the process: How to check for plugin conflicts.

    Thread Starter RezaY

    (@mohammad983)

    I did all your suggestions.
    it related to Yoast plugin.
    If you google my bug, you will see a lot of users have this problem! and there is not any solution for it!

    this error appears when I want to publish posts. I get this message in the post page.

    Connection lost. Saving has been disabled until you’re reconnected. We’re backing up this post in your browser, just in case.

    after that when I check the debug file these line added to it

    [11-Nov-2020 16:32:07 UTC] خطای Commands out of sync; you can't run this command now در پایگاه‌داده وردپرس برای دستور SELECT umeta_id FROM tc_usermeta WHERE meta_key = 'tc_yoast_notifications' AND user_id = 1 ساخته شده توسط 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
    [11-Nov-2020 16:32:07 UTC] خطای Commands out of sync; you can't run this command now در پایگاه‌داده وردپرس برای دستور SHOW FULL COLUMNS FROM <code>tc_usermeta</code> ساخته شده توسط 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, add_metadata

    Hi @mohammad983,

    We’re sorry to hear that this is happening with the latest version of Yoast SEO. Can you confirm that your server still meets the plugin minimum requirements? You can find your server details under Tools > Site Health > Info in the WordPress admin menu.

    If this only began happening after you updated, does rolling back to the previous version of Yoast SEO still produce the errors? We strongly recommend testing this on a staging site or making a complete backup before installing a different version.

    You can re-install Yoast SEO manually or downgrade the plugin using SFTP / FTP by following the steps found here: https://kb.yoast.com/kb/how-can-i-update-my-free-plugin/.

    Thread Starter RezaY

    (@mohammad983)

    It does not work again.
    I have this problem with this version and older verions.
    I have 3 websites. with different them. All of them has this error. please google this error you will see lots of people have the same problem.
    please consider it!

    [16-Nov-2020 11:49:18 UTC] خطای Commands out of sync; you can't run this command now در پایگاه‌داده وردپرس برای دستور SELECT * FROM hvylq_users WHERE user_login = 'fathi' LIMIT 1 ساخته شده توسط shutdown_action_hook, do_action('shutdown'), WP_Hook->do_action, WP_Hook->apply_filters, Yoast_Notification_Center->update_storage, Yoast_Notification_Center->remove_storage, Yoast_Notification_Center->has_stored_notifications, Yoast_Notification_Center->get_stored_notifications, get_current_user_id, wp_get_current_user, _wp_get_current_user, apply_filters('determine_current_user'), WP_Hook->apply_filters, wp_validate_logged_in_cookie, wp_validate_auth_cookie, get_user_by, WP_User::get_data_by

    • This reply was modified 5 years, 5 months ago by RezaY.

    Hi,

    We had an open issue report here https://github.com/Yoast/wordpress-seo/issues/16027 which appears to match up to your issue. Our developers indicate a fix for it will be ready in v15.4 of Yoast. We are not sure when that will be released only that a fix for the issue will be included in it. We recommend updating to v15.4 when it comes out and see if the issue resolves.

    In the meantime, we suggest signing up for our newsletter as that is where we will announce product changes and updates. You may sign-up for it here https://yoast.com/ by scrolling towards the bottom to complete the sign-up field.

    Thread Starter RezaY

    (@mohammad983)

    One of my websites has about 48000 posts on other website have 11000 posts(one author). maybe my problem related to the post that you mentioned. So I will wait for publishing the new version.

    • This reply was modified 5 years, 5 months ago by RezaY.
    Thread Starter RezaY

    (@mohammad983)

    @pcosta88 I downloaded the new version of toast (15.3)
    but the problem not solved.
    Do you have any plan to support websites which have more than 40000 posts?!

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘error in Database’ is closed to new replies.