MySQL Error

  • Resolved TCR

    (@theconnectedrider)


    7 years, 7 months ago

    SELECT term_id, term_group, term_level
    FROM wppx_psu_terms
    WHERE term_id IN ()

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1

    I tried rolling back to a previous version and just earned myself a slow database query on top of that.

    apply_filters(‘get_the_terms’)
    get_the_terms()
    wp-includes/category-template.php:1218
    WC_Data_Store_WP->get_term_ids()
    wp-content/plugins/woocommerce/includes/data-stores/class-wc-data-store-wp.php:54
    WC_Product_Data_Store_CPT->read_product_data()
    wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php:309
    WC_Product_Data_Store_CPT->read()
    wp-content/plugins/woocommerce/includes/data-stores/class-wc-product-data-store-cpt.php:155
    WC_Data_Store->read()
    wp-content/plugins/woocommerce/includes/class-wc-data-store.php:147
    WC_Product->__construct()
    wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-product.php:126
    WC_Product_Simple->__construct()
    wp-content/plugins/woocommerce/includes/class-wc-product-simple.php:26
    WC_Data->__wakeup()
    wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-data.php:127
    unserialize()
    wp-content/plugins/woocommerce/includes/abstracts/abstract-wc-data.php:127
    maybe_unserialize()
    wp-includes/functions.php:325
    get_option()
    wp-includes/option.php:141
    _get_cron_array()
    wp-includes/cron.php:455
    wp_next_scheduled()
    wp-includes/cron.php:234
    WPSEO_Link_Notifier->register_hooks()
    wp-content/plugins/wordpress-seo/admin/links/class-link-notifier.php:21
    WPSEO_Admin->__construct()
    wp-content/plugins/wordpress-seo/admin/class-admin.php:107
    WPSEO_Admin_Init->__construct()
    wp-content/plugins/wordpress-seo/admin/class-admin-init.php:38
    wpseo_admin_init()
    wp-content/plugins/wordpress-seo/wp-seo-main.php:338
    do_action(‘plugins_loaded’)
    wp-includes/plugin.php:453
    Plugin: wordpress-seo You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘)’ at line 1

Viewing 2 replies - 1 through 2 (of 2 total)

  • Hi @theconnectedrider,

    That sounds like a plugin or theme conflict. Can you try and gather as much information for us? Please perform the following:

    1.Make sure you’re using the latest version of Yoast SEO and WordPress
    2.Make sure the issue doesn’t persist when Yoast SEO is disabled.
    3. Check for conflicts.

    If you find any errors related to Yoast SEO or if there is a conflict with a plugin or a theme, you can create a new issue on GitHub for our developers. Please report the issue to a third party developer as well.

    If you didn’t find any conflicts or errors, we think the issue is specific to your site. We’d need to investigate further but are unable to do so on these forums. You can purchase Yoast SEO Premium and receive our Premium email support and we can help you further.

    Closed due to inactivity.

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘MySQL Error’ is closed to new replies.