Shop Ajax Filter issue

  • Resolved Dhruv Ls

    (@devdmnv)


    2 days, 4 hours ago

    I’m using the Filter Everything plugin filter on the shop page, and when I click on the filter, I get a database error in the AJAX response. Currently, AJAX filtering is enabled, but the error still appears even when AJAX is disabled.

    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 ((wp_posts.post_type = ‘product’ AND (wp_posts.post_status = ‘publish’ …’ at line 7]
    SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (24) ) ) AND ((wp_posts.post_type = 'product' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled' OR wp_posts.post_status = 'wfob-disabled' OR wp_posts.post_status = 'wfocu-disabled' OR wp_posts.post_status = 'private'))) GROUP BY wp_posts.ID ORDER BY wp_posts.menu_order ASC, wp_posts.post_title ASC LIMIT 0, 12 /* Current SQL Query is filtered by Filter Everything plugin */
    https://prnt.sc/KHbHHa1JHPqF

    • This topic was modified 2 days, 4 hours ago by Dhruv Ls.
    • This topic was modified 2 days, 4 hours ago by Dhruv Ls.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support fesupportteam

    (@fesupportteam)

    2 days, 4 hours ago

    Hi @devdmnv

    Can you please send the link to the page with the filters that are not working so that we can check it?

    Best Regards,
    Victor

    Thread Starter Dhruv Ls

    (@devdmnv)

    2 days, 4 hours ago

    https://vj.hosejoy.net/shop/

    Plugin Support fesupportteam

    (@fesupportteam)

    2 days, 3 hours ago

    @devdmnv Thank you for the link to the page.

    From what we can see, the query is being modified by other plugins or custom code, which are extending it with additional symbols. This is likely causing the error.

    Additionally, the page is using Elementor, which is most likely responsible for displaying the products as well.

    Please try switching to the default WordPress theme (e.g., Twenty Twenty-Five) and use the default archive pages templates with the main query. This will help you test the filtering without any custom code or query modifications affecting the results.

    After that, you can re-enable plugins one by one, as well as your current theme and Elementor templates, to identify exactly where the issue is coming from.

    Best Regards,
    Victor

    Thread Starter Dhruv Ls

    (@devdmnv)

    2 days, 3 hours ago

    Yes, that issue was caused by a plugin conflict, which I have now fixed. Thanks!

    Plugin Support fesupportteam

    (@fesupportteam)

    2 days, 3 hours ago

    @devdmnv Thank you for the update. We are glad to hear that the issue has been resolved.

    Best Regards,
    Victor

Viewing 5 replies - 1 through 5 (of 5 total)

You must be logged in to reply to this topic.