Database Error

  • 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 query
    SELECT object_id
    FROM wp_yoast_seo_meta
    WHERE 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_posts




    Can you please advise?


    Thank you,
    Sophia
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    Hello @sophiacst,

    I’m sorry about the WordPress database errors. Please try the following:

    1. Install & activate the?Yoast Test Helper plugin
    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

    (@sophiacst)

    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:279
    Stack 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

    (@maybellyne)

    Can you share your site info via Pastebin? WordPress > Tools > Site Health > Info > Copy site info to clipboard

    Thread Starter sophiacst

    (@sophiacst)

    Hi Maybellyne,

    Can I send it in private?

    It contains our site’s important information.

    Thanks,

    Sophia

    Plugin Support Maybellyne

    (@maybellyne)

    Please use Pastebin.

Viewing 5 replies - 1 through 5 (of 5 total)
  • You must be logged in to reply to this topic.