Database error after updating to 3.17.0

  • Resolved dariusv24

    (@dariusv24)


    1 year, 10 months ago

    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 ‘) AND i.user_id = 13 GROUP BY i.prod_id, l.ID ORDER BY i.position ASC, i.ID…’ at line 5]
    SELECT SQL_CALC_FOUND_ROWS i.* FROM sa_yith_wcwl AS i LEFT JOIN sa_yith_wcwl_lists AS l ON l.ID = i.wishlist_id INNER JOIN sa_posts AS p ON p.ID = i.prod_id WHERE 1 AND p.post_type IN ( 'product', 'product_variation' ) AND p.post_status = 'publish' AND p.ID NOT IN ( ) AND i.user_id = 13 GROUP BY i.prod_id, l.ID ORDER BY i.position ASC, i.ID DESC

Viewing 4 replies - 1 through 4 (of 4 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 tell us if it solve the issue, please:

    add_filter( 'yith_wcwl_remove_hidden_products_via_query', '__return_false' );

    We will be attentive to your response.

    Best regards.

    Yes, adding this code to functions.php resolves the issue thanks. please fix this in the next update.

    Thread Starter dariusv24

    (@dariusv24)

    Yes works great, thank you very much.

    Plugin Support Alexis Salazar

    (@asaldel)

    Hello there.

    Perfect. You are welcome!

    We’ll set this topic on solved.

    If you have any other problem, don’t hesitate to open a new one.

    Have a good day.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Database error after updating to 3.17.0’ is closed to new replies.