Title: Database Error Last modified: November 11, 2024 --- # Database Error * Resolved [sophiacst](https://wordpress.org/support/users/sophiacst/) * (@sophiacst) * [1 year, 7 months ago](https://wordpress.org/support/topic/database-error-413/) * ```wp-block-code Hi,There are staging and production servers for our website.We update content on staging through wordpress and sync the data to production server.After sync, our homepage broke this afternoon.I found there was a database error from our log.[11-Nov-2024 12:38:56 UTC] WordPress database error 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':7087,post_parent:7027,post_parent:7064,post_parent:7039,post_parent:7043,pos...' at line 3 for querySELECT object_idFROM wp_yoast_seo_metaWHERE object_id IN ( post_parent:7087,post_parent:7027,post_4parent:7064,post_parent:7039,post_parent:7043,post_parent:27583,post_parent:10457,post_parent:29405,post_parent:7059,post_parent:7058,post_parent:7041,post_parent:10430,post_parent:27603,post_parent:7098,post_parent:7094,post_parent:7063,post_parent:7090,post_parent:7060,post_parent:7065,post_parent:10465,post_parent:26955,post_parent:10473,post_parent:10433,post_parent:7068,post_parent:8890,post_parent:7046,post_parent:10437,post_parent:7045,post_parent:10481,post_parent:7092,post_parent:10444,post_parent:10448,post_parent:7095,post_parent:10453,post_parent:7040,post_parent:7085,post_parent:10485,post_parent:10489,post_parent:7042,post_parent:7083,post_parent:19135,post_parent:7038,post_parent:10496,post_parent:18508,post_parent:10501,post_parent:7066,post_parent:7084,post_parent:7082,post_parent:7069,post_parent:23012,post_parent:25298,post_parent:7061,post_parent:10506,post_parent:7091,post_parent:7089,post_parent:10407,post_parent:7097,post_parent:7062,post_parent:7034,post_parent:7088,post_parent:33837 )made by WP_List_Table->display, WP_List_Table->display_tablenav, WP_Posts_List_Table->extra_tablenav, do_action('manage_posts_extra_tablenav'), WP_Hook->do_action, WP_Hook->apply_filters, WPSEO_Link_Columns->count_objects, WPSEO_Link_Columns->set_count_objects, WPSEO_Link_Query::filter_unprocessed_postsCan you please advise?Thank you,Sophia ``` Viewing 6 replies - 1 through 6 (of 6 total) * Plugin Support [Maybellyne](https://wordpress.org/support/users/maybellyne/) * (@maybellyne) * [1 year, 6 months ago](https://wordpress.org/support/topic/database-error-413/#post-18133258) * Hello [@sophiacst](https://wordpress.org/support/users/sophiacst/), * I’m sorry about the WordPress database errors. 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. 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 the specific reset was successful. 4. Go to SEO > Tools, and under SEO data, click the “Start SEO data optimization” button to allow Yoast to rescan your content. * Do let us know how it goes. * Thread Starter [sophiacst](https://wordpress.org/support/users/sophiacst/) * (@sophiacst) * [1 year, 6 months ago](https://wordpress.org/support/topic/database-error-413/#post-18134676) * Hi Maybellyne, * Thanks for getting back to me. * I just tried to run Reset Indexables tables & migrations, but got errors as below. * [14-Nov-2024 09:41:41 UTC] WordPress database error Table ‘wp_yoast_indexable’ doesn’t exist for query UPDATE wp_yoast_indexable SET prominent_words_version = NULL 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 [14-Nov-2024 09:41:41 UTC] WordPress database error Table ‘wp_yoast_prominent_words’ doesn’t exist for query TRUNCATE TABLE wp_yoast_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[14-Nov-2024 09:41:41 UTC] PHP Fatal error: Uncaught Error: Call to undefined function YoastSEO() in /xxx/wp-content/ plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php:279Stack trace: 0 /xxx/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast-seo.php( 180): Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO->reset_indexing_notification(‘ indexables-rese…’) 1 /xxx/wp-content/plugins/yoast-test-helper/src/wordpress- plugins/yoast-seo.php(236): Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO- >reset_prominent_words_calculation() 2 /xxx/wp-content/plugins/yoast-test-helper/ src/wordpress-plugins/yoast-seo.php(106): Yoast\WP\Test_Helper\WordPress_Plugins\ Yoast_SEO->reset_indexables() 3 /xxx/wp-content/plugins/yoast-test-helper/src/ wordpress-plugin-features.php(142): Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO- >reset_feature(‘reset_indexable…’) 4 /xxx/wp-content/plugins/yoast-test-helper/ src/wordpress-plugin-features.php(104): Yoast\WP\Test_Helper\WordPress_Plugin_Features- >reset_feature(Object(Yoast\WP\Test_Helper\WordPress_Plugins\Yoast_SEO)) 5 /xxx/ wp-includes/class-wp-hook.php(324): Yoast\WP\Test_Helper\WordPress_Plugin_Features- >handle_reset_feature(”) 6 /xxx/wp-includes/class-wp-hook.php(348): WP_Hook-> apply_filters(”, Array) 7 /xxx/wp-includes/plugin.php(517): WP_Hook->do_action( Array) 8 xxx/wp-admin/admin-post.php(85): do_action(‘admin_post_word…’) 9 {main} * thrown in /xxx/wp-content/plugins/yoast-test-helper/src/wordpress-plugins/yoast- seo.php on line 279 * Did I miss anything? * Thank you, * Sophia * Plugin Support [Maybellyne](https://wordpress.org/support/users/maybellyne/) * (@maybellyne) * [1 year, 6 months ago](https://wordpress.org/support/topic/database-error-413/#post-18136455) * Can you share your site info via Pastebin? _WordPress > Tools > Site Health > Info > Copy site info to clipboard _ * Thread Starter [sophiacst](https://wordpress.org/support/users/sophiacst/) * (@sophiacst) * [1 year, 6 months ago](https://wordpress.org/support/topic/database-error-413/#post-18137721) * Hi Maybellyne, * Can I send it in private? * It contains our site’s important information. * Thanks, * Sophia * Plugin Support [Maybellyne](https://wordpress.org/support/users/maybellyne/) * (@maybellyne) * [1 year, 6 months ago](https://wordpress.org/support/topic/database-error-413/#post-18147302) * Please use [Pastebin](https://pastebin.com/). * Thread Starter [sophiacst](https://wordpress.org/support/users/sophiacst/) * (@sophiacst) * [1 year, 6 months ago](https://wordpress.org/support/topic/database-error-413/#post-18169796) * Sorry not sure how to past the password to you so just left it. * However, the error occurs again and there is no way for me to fix it. * here is the site health info * [https://pastebin.com/P11b33uf](https://pastebin.com/P11b33uf) * Please let me know how I can pass the password to you. * Thank you, * Sophia Viewing 6 replies - 1 through 6 (of 6 total) The topic ‘Database Error’ 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/) ## Tags * [database](https://wordpress.org/support/topic-tag/database/) * [fatal](https://wordpress.org/support/topic-tag/fatal/) * 6 replies * 2 participants * Last reply from: [sophiacst](https://wordpress.org/support/users/sophiacst/) * Last activity: [1 year, 6 months ago](https://wordpress.org/support/topic/database-error-413/#post-18169796) * Status: resolved