Database Error

  • Resolved sophiacst

    (@sophiacst)


    2 weeks ago

    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.