Title: error in Database Last modified: November 9, 2020 --- # error in Database * Resolved [RezaY](https://wordpress.org/support/users/mohammad983/) * (@mohammad983) * [5 years, 6 months ago](https://wordpress.org/support/topic/error-in-database-5/) * 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](https://wordpress.org/support/users/mikes41720/) * (@mikes41720) * [5 years, 6 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13641776) * 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](https://yoast.com/help/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](https://wordpress.org/support/users/mohammad983/) * (@mohammad983) * [5 years, 6 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13642837) * 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](https://wordpress.org/support/users/mohammad983/) * (@mohammad983) * [5 years, 6 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13643745) * unfortunately this line added to bugs too * ``` [10-Nov-2020 11:33:59 UTC] PHP Notice: تابع wpdb::prepare به طورنادرست فراخوانی شد. آرگومان کوئری wpdb::prepare() باید دارای نگهدارندهٔ مکان (placeholder) باشد. لطفاً برای اطلاعات بیشتر، اشکال زدایی در وردپرس را مشاهده کنید. (این پیام در نگارش 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 type = '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 به طورنادرست فراخوانی شد. آرگومان کوئری wpdb::prepare() باید دارای نگهدارندهٔ مکان (placeholder) باشد. لطفاً برای اطلاعات بیشتر، اشکال زدایی در وردپرس را مشاهده کنید. (این پیام در نگارش 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 type = '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](https://wordpress.org/support/users/mohammad983/). * [devnihil](https://wordpress.org/support/users/devnihil/) * (@devnihil) * [5 years, 6 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13646184) * [@mohammad983](https://wordpress.org/support/users/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](https://wordpress.org/plugins/yoast-test-helper/) ** 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](https://wordpress.org/support/users/mohammad983/) * (@mohammad983) * [5 years, 6 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13649544) * [@devnihil](https://wordpress.org/support/users/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 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 ``` * [devnihil](https://wordpress.org/support/users/devnihil/) * (@devnihil) * [5 years, 6 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13649974) * [@mohammad983](https://wordpress.org/support/users/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/](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/](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](https://wordpress.org/themes/twentynineteen/). Test this on your development or staging site, if you have one. If not, we recommend using the [Health Check & Troubleshooting](https://wordpress.org/plugins/health-check/) 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](https://kb.yoast.com/kb/how-to-check-for-plugin-conflicts/). * Thread Starter [RezaY](https://wordpress.org/support/users/mohammad983/) * (@mohammad983) * [5 years, 6 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13650052) * 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 tc_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 ``` * [Priscilla Chapman](https://wordpress.org/support/users/priscillamc/) * (@priscillamc) * [5 years, 6 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13651755) * Hi [@mohammad983](https://wordpress.org/support/users/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](https://yoast.com/help/plugin-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/](https://kb.yoast.com/kb/how-can-i-update-my-free-plugin/). * Thread Starter [RezaY](https://wordpress.org/support/users/mohammad983/) * (@mohammad983) * [5 years, 5 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13667806) * 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](https://wordpress.org/support/users/mohammad983/). * [Pcosta88](https://wordpress.org/support/users/pcosta88/) * (@pcosta88) * [5 years, 5 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13668210) * Hi, * We had an open issue report here [https://github.com/Yoast/wordpress-seo/issues/16027](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/](https://yoast.com/) by scrolling towards the bottom to complete the sign-up field. * Thread Starter [RezaY](https://wordpress.org/support/users/mohammad983/) * (@mohammad983) * [5 years, 5 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13668247) * 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](https://wordpress.org/support/users/mohammad983/). * Thread Starter [RezaY](https://wordpress.org/support/users/mohammad983/) * (@mohammad983) * [5 years, 5 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13692148) * [@pcosta88](https://wordpress.org/support/users/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. * ![](https://ps.w.org/wordpress-seo/assets/icon-256x256.gif?rev=3419908) * [Yoast SEO - Advanced SEO with real-time guidance and built-in AI](https://wordpress.org/plugins/wordpress-seo/) * [Frequently Asked Questions](https://wordpress.org/plugins/wordpress-seo/#faq) * [Support Threads](https://wordpress.org/support/plugin/wordpress-seo/) * [Active Topics](https://wordpress.org/support/plugin/wordpress-seo/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/wordpress-seo/unresolved/) * [Reviews](https://wordpress.org/support/plugin/wordpress-seo/reviews/) * 12 replies * 5 participants * Last reply from: [RezaY](https://wordpress.org/support/users/mohammad983/) * Last activity: [5 years, 5 months ago](https://wordpress.org/support/topic/error-in-database-5/#post-13692148) * Status: resolved