Memcached + Yith Wishlist Issue

  • Resolved leemeldavid

    (@leemeldavid)


    2 years ago

    First of all, thanks for this plugin it helped our website speed dramatically. Though we’re having issues with our Yith Wishlist and Memcached feature of SG Optimizer.

    The Wishlist page is not display any product added on it, when I checked it using the Query Monitor plugin, the errors occured:

    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”

    But whenever I turn off the Memcached feature of SG optimizer, it displays the products on the wishlist. Is there a way to resolve this or exclude the wishlist from memcached? Thanks.

    Regards,

    Leemel

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Dimo Dimov

    (@dimodi)

    Hello Leemel,

    I’ve tried to recreate the issue on a test WordPress website. I installed the “YITH WooCommerce Wishlist” plugin and added a product to my wishlist with Memcached enabled (both through the plugin interface and in SiteGround’s Site Tools). The product appeared immediately on the “Wishlist” page. I also monitored the queries through the Query Monitor plugin but no errors were reported.

    This leads me to believe that the reported behavior might be specific to the setup of your website. If your site is hosted with SiteGround I would suggest opening a support request through your Client Area. This will allow us to investigate the case further while having the necessary access to your site and its configuration.

    Best regards,
    Dimo

    Thread Starter leemeldavid

    (@leemeldavid)

    Hi Dimo,

    Thanks for the information. I appreciate it.

    Yup, at first it is working, but eventually, like we check it after 24 hrs, the display of the products on the Wishlist page disappeared and the error occurs. So what we’re doing is we’re toggling the Memcached feature for time to time. Just to bring back the Wishlist products.

    After toggling the Memcached, the products is displaying again and the error is gone. So I’m not sure that this should happening. Yes, our site is hosted by SiteGround and we’ll ask for help from them also.

    Thanks.

    Regards,

    Leemel

    Plugin Support Pavel Dosev

    (@pdosev)

    Hello Leemel,

    We will close the thread and mark it as resolved, as there has been no update in the last 3 days.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Memcached + Yith Wishlist Issue’ is closed to new replies.