Wishlist Page + Memcached SG Optimizer

  • Hello, the plugin is great and it help our website do the wishlist feature awesome. However, we’re having issues with the Wishlist page and the Memcached of SG Optimizer.

    There are times that products added when clicking the heart icon on the product catalog and individual product page are not displaying on our Wishlist Page.

    We used the Query Monitor plugin to detect the issue, and we’ve found this error:

    Query:

    SELECT i.*
    FROM wp_3_yith_wcwl as i
    INNER JOIN wp_3_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

    Caller:

    “YITH_WCWL_Wishlist_Data_Store->read_items()“

    Component:

    Plugin: yith-woocommerce-wishlist

    Error Message:

    “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 ‘) ORDER BY position ASC, ID DESC’ at line 1”

    And so in able to bring back the products in display, we have to manually toggle on/off the Memcached feature of the SG Optimizer which is not ideal for us because we won’t know if the product is displaying on the Wishlist page 24/7.?Is the plugin fully compatible with SG Optimizer’s Memcached? Thanks.

    Regards,

    Leemel

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

    (@juaancmendez)

    Hello Leemel,
    we hope you’re doing well!

    First, could you check if adding this code in the functions.php file of your active child theme solves the problem:

    add_filter( 'yith_wcwl_remove_hidden_products_via_query', '__return_false' );

    Then, tell you that our plugin is not compatible with any caching plugin, so if you have problems with them, we offer you the following solutions:

    Could you please add the following URL to the exception list?

    • [ add the url of the page wishlist ]
    • [ add the url of the page wishlist ]/* (for all wishlist page endpoints)
    • Besides, YITH WooCommerce Wishlist plugin uses cookies in order to correctly store user’s wishlists; can you please add?yith_wcwl_session_*?cookies to your exceptions?

    We will be attentive to any news.

    Best regards.

Viewing 1 replies (of 1 total)
  • The topic ‘Wishlist Page + Memcached SG Optimizer’ is closed to new replies.