Database Error

  • Resolved sophiacst

    (@sophiacst)


    1 year, 7 months 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 6 replies - 1 through 6 (of 6 total)
  • Plugin Support Maybellyne

    (@maybellyne)

    1 year, 6 months ago

    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)

    1 year, 6 months ago

    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)

    1 year, 6 months ago

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

    Thread Starter sophiacst

    (@sophiacst)

    1 year, 6 months ago

    Hi Maybellyne,

    Can I send it in private?

    It contains our site’s important information.

    Thanks,

    Sophia

    Plugin Support Maybellyne

    (@maybellyne)

    1 year, 6 months ago

    Please use Pastebin.

    Thread Starter sophiacst

    (@sophiacst)

    1 year, 6 months ago

    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

    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.