• Resolved ns66

    (@ns66)


    Hello,

    I am getting errors like these. Any idea what could be causing it or what I could do about it?

    Thanks..

    FastCGI sent in stderr: "PHP message: 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 ') ORDER BY position ASC, ID DESC' at line 1 for query SELECT i.* FROM wp_yith_wcwl as i INNER JOIN wp_posts as p on i.prod_id = p.ID WHERE wishlist_id = 1 AND p.post_type IN ( 'product', 'product_variation' ) AND p.post_status = 'publish' AND prod_id NOT IN ( ) ORDER BY position ASC, ID DESC made by do_action('wp_ajax_add_to_wishlist'), WP_Hook->do_action, WP_Hook->apply_filters, YITH_WCWL_Ajax_Handler::add_to_wishlist, YITH_WCWL->add, YITH_WCWL_Wishlist->has_product, YITH_WCWL_Wishlist->get_items, WC_Data_Store->__call, YITH_WCWL_Wishlist_Data_Store->read_itemsPHP message: 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 ') ORDER BY position ASC, ID DESC' at line 1 for query SELECT i.* FROM wp_yith_wcwl as i INNER JOIN wp_posts as p on i.prod_id = p.ID WHERE wishlist_id = 1 AND p.post_type IN ( 'product', 'product_variation' ) AND p.post_status = 'publish' AND prod_id NOT IN ( ) ORDER BY position ASC, ID DESC made by do_action('wp_ajax_add_to_wishlist'), WP_Hook->do_action, WP_Hook->apply_filters, YITH_WCWL_Ajax_Handler::add_to_wishlist, YITH_WCWL->add, YITH_WCWL_Wishlist->save, YITH_WCWL_Wishlist->save_items, WC_Data->save, WC_Data_Store->create, YITH_WCWL_Wishlist_Item_Data_Store->create, YITH_WCWL_Wishlist_Factory::get_wishlist_item_by_product_id, YITH_WCWL_Wishlist->get_product, YITH_WCWL_Wishlist->has_product, YITH_WCWL_Wishlist->get_items, WC_Data_Store->__call, YITH_WCWL_Wishlist_Data_Store->read_itemsPHP message: 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 ') ORDER BY position ASC, ID DESC' at line 1 for query SELECT i.* FROM wp_yi

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Support Juan Coronel

    (@juaancmendez)

    Hello there,
    we hope you’re doing well!

    Try adding the following code in the functions.php file of your active child theme and check if the problem persists please:

    add_filter( 'yith_wcwl_remove_hidden_products_via_query', '__return_false' );

    Let us know any news.

    Have a nice day!

    Thread Starter ns66

    (@ns66)

    Hi,

    Yes, that solved the problem. Thanks!

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