Database error after updating to 3.17.0

  • Resolved dariusv24

    (@dariusv24)


    1 year, 3 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)

    1 year, 3 months ago

    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.

    urshobhit

    (@urshobhit)

    1 year, 3 months ago

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

    Thread Starter dariusv24

    (@dariusv24)

    1 year, 3 months ago

    Yes works great, thank you very much.

    Plugin Support Alexis Salazar

    (@asaldel)

    1 year, 2 months ago

    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.