• Resolved operathing

    (@operathing)


    Hi,
    I find your plugin is fantastic and simple. I didn’t any problem until update the plugin last week. Now in frontend I can’t select the category in the first filter, and in the third filter with checkbox (under the price filter) is not visible.
    Can you help me to resolve?
    Thanks a lot.

    The page I need help with: [log in to see the link]

Viewing 15 replies - 1 through 15 (of 15 total)
  • Thread Starter operathing

    (@operathing)

    I’m doing some test and i think there are some problem with WPML compatibility.
    The plugin can run together?
    Tanks!

    Plugin Author RazyRx

    (@razyrx)

    Hi @operathing,

    Please try Purge cache in plugin settings -> Advanced tab.

    Regards,
    Oleg

    Thread Starter operathing

    (@operathing)

    Hi @razyrx,
    I did the purge cache after your indication but the problem persist.
    When i deactivate the WPML plugin the filters turn to work correctly.

    Plugin Author Dmytro Holovnia

    (@dholovnia)

    Hi @operathing,

    When you turn WPML back on issue with filters came back?

    Regards,
    Dima

    Thread Starter operathing

    (@operathing)

    Hi @dholovnia,
    Yes.. When I reactivate WPML plugin the problem return on the filters.
    Regards,
    Operathing

    Hi! Thanks for plugin.
    But after update from 1.3.3.2 version to 1.3.4.1 filter does not work. And site stucks on pages where is filter.
    There is this error in log:
    PHP Warning: mysqli_query(): MySQL server has gone away in /home/public_html/wp-includes/wp-db.php on line 2007
    PHP Warning: mysqli_query(): Error reading result set’s header in /home/public_html/wp-includes/wp-db.php on line 2007
    I backed to old version 1.3.3.2 and now all work.

    Plugin Author RazyRx

    (@razyrx)

    Hi @operathing @kizikeli,

    Please try to update plugin to latest version 1.3.4.2 and check the issues.

    Regards,
    Oleg

    Thread Starter operathing

    (@operathing)

    With the latest version 1.3.4.2 the filters run perfectly.
    Thank you so much,
    Best regards

    Unfortunately not. After update i have the same error.
    I back again to old version and it works.

    Plugin Author Dmytro Holovnia

    (@dholovnia)

    Hi @kizikeli,

    We need more info about your issue. Original issue was found and fixed.

    Check mysql error log. On what query mysql is dying?

    Regards,
    Dima

    I am not sure but i think this mysql query:
    SELECT COUNT( DISTINCT **_posts.ID ) as term_count, term_relationships.term_taxonomy_id as term_cou

    And error log:
    [10-Sep-2019 12:02:53 UTC] WordPress database error Server shutdown in progress for query SELECT COUNT( DISTINCT ***_posts.ID ) as term_count, term_relationships.term_taxonomy_id as term_count_id FROM ***_posts INNER JOIN ***_term_relationships AS term_relationships ON ***_posts.ID = term_relationships.object_id LEFT JOIN ***_term_relationships ON (***_posts.ID = ***_term_relationships.object_id) INNER JOIN ***_postmeta ON ( ***_posts.ID = ***_postmeta.post_id ) INNER JOIN ***_postmeta AS mt1 ON ( ***_posts.ID = mt1.post_id ) INNER JOIN ***_postmeta AS mt2 ON ( ***_posts.ID = mt2.post_id ) INNER JOIN ***_postmeta AS mt3 ON ( ***_posts.ID = mt3.post_id ) INNER JOIN ***_postmeta AS mt4 ON ( ***_posts.ID = mt4.post_id ) INNER JOIN ***_postmeta AS mt5 ON ( ***_posts.ID = mt5.post_id ) INNER JOIN ***_postmeta AS mt6 ON ( ***_posts.ID = mt6.post_id ) INNER JOIN ***_postmeta AS mt7 ON ( ***_posts.ID = mt7.post_id ) INNER JOIN ***_postmeta AS mt8 ON ( ***_posts.ID = mt8.post_id ) INNER JOIN ***_postmeta AS mt9 ON ( ***_posts.ID = mt9.post_id ) INNER JOIN ***_postmeta AS mt10 ON ( ***_posts.ID = mt10.post_id ) INNER JOIN ***_postmeta AS mt11 ON ( ***_posts.ID = mt11.post_id ) INNER JOIN ***_postmeta AS mt12 ON ( ***_posts.ID = mt12.post_id ) INNER JOIN ***_postmeta AS mt13 ON ( ***_posts.ID = mt13.post_id ) WHERE ***_posts.post_type IN ( ‘product’ ) AND ***_posts.post_status = ‘publish’ AND (
    ***_posts.ID NOT IN (
    SELECT object_id
    FROM ***_term_relationships
    WHERE term_taxonomy_id IN (7,9)
    )
    AND
    ***_term_relationships.term_taxonomy_id IN (80)
    ) AND (
    ( ***_postmeta.meta_key = ‘_price’ AND ***_postmeta.meta_value > ‘0’ )
    AND
    ( mt1.meta_key = ‘_price’ AND mt1.meta_value > ‘0’ )
    AND
    ( mt2.meta_key = ‘_price’ AND mt2.meta_value > ‘0’ )
    AND
    ( mt3.meta_key = ‘_price’ AND mt3.meta_value > ‘0’ )
    AND
    ( mt4.meta_key = ‘_price’ AND mt4.meta_value > ‘0’ )
    AND
    ( mt5.meta_key = ‘_price’ AND mt5.meta_value > ‘0’ )
    AND
    ( mt6.meta_key = ‘_price’ AND mt6.meta_value > ‘0’ )
    AND
    ( mt7.meta_key = ‘_price’ AND mt7.meta_value > ‘0’ )
    AND
    ( mt8.meta_key = ‘_price’ AND mt8.meta_value > ‘0’ )
    AND
    ( mt9.meta_key = ‘_price’ AND mt9.meta_value > ‘0’ )
    AND
    ( mt10.meta_key = ‘_price’ AND mt10.meta_value > ‘0’ )
    AND
    ( mt11.meta_key = ‘_price’ AND mt11.meta_value > ‘0’ )
    AND
    ( mt12.meta_key = ‘_price’ AND mt12.meta_value > ‘0’ )
    AND
    ( mt13.meta_key = ‘_price’ AND mt13.meta_value > ‘0’ )
    ) AND term_relationships.term_taxonomy_id IN (855,854) GROUP BY term_relationships.term_taxonomy_id made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/woocommerce/templates/taxonomy-product_cat.php’), wc_get_template, include(‘/plugins/woocommerce/templates/archive-product.php’), do_action(‘woocommerce_sidebar’), WP_Hook->do_action, WP_Hook->apply_filters, Avada_Woocommerce->add_sidebar, do_action(‘avada_after_content’), WP_Hook->do_action, WP_Hook->apply_filters, Avada_Layout->append_sidebar_single, get_template_part, locate_template, load_template, require(‘/themes/Avadanew/templates/sidebar-1.php’), generated_dynamic_sidebar, Sidebar_Generator::get_sidebar, dynamic_sidebar, WP_Widget->display_callback, BeRocket_new_AAPF_Widget->widget, the_widget, BeRocket_new_AAPF_Widget_single->widget, the_widget, BeRocket_AAPF_Widget->widget, BeRocket_AAPF_Widget::get_attribute_values, apply_filters(‘berocket_aapf_recount_terms_apply’), WP_Hook->apply_filters, BeRocket_AAPF_faster_attribute_recount->recount_terms
    [10-Sep-2019 12:02:53 UTC] WordPress database error Server shutdown in progress for query SELECT COUNT( DISTINCT ***_posts.ID ) as term_count, term_relationships.term_taxonomy_id as term_count_id FROM ***_posts INNER JOIN ***_term_relationships AS term_relationships ON ***_posts.ID = term_relationships.object_id LEFT JOIN ***_term_relationships ON (***_posts.ID = ***_term_relationships.object_id) INNER JOIN ***_postmeta ON ( ***_posts.ID = ***_postmeta.post_id ) INNER JOIN ***_postmeta AS mt1 ON ( ***_posts.ID = mt1.post_id ) INNER JOIN ***_postmeta AS mt2 ON ( ***_posts.ID = mt2.post_id ) INNER JOIN ***_postmeta AS mt3 ON ( ***_posts.ID = mt3.post_id ) INNER JOIN ***_postmeta AS mt4 ON ( ***_posts.ID = mt4.post_id ) INNER JOIN ***_postmeta AS mt5 ON ( ***_posts.ID = mt5.post_id ) INNER JOIN ***_postmeta AS mt6 ON ( ***_posts.ID = mt6.post_id ) INNER JOIN ***_postmeta AS mt7 ON ( ***_posts.ID = mt7.post_id ) INNER JOIN ***_postmeta AS mt8 ON ( ***_posts.ID = mt8.post_id ) INNER JOIN ***_postmeta AS mt9 ON ( ***_posts.ID = mt9.post_id ) WHERE ***_posts.post_type IN ( ‘product’ ) AND ***_posts.post_status = ‘publish’ AND (
    ***_posts.ID NOT IN (
    SELECT object_id
    FROM ***_term_relationships
    WHERE term_taxonomy_id IN (7,9)
    )
    AND
    ***_term_relationships.term_taxonomy_id IN (108)
    ) AND (
    ( ***_postmeta.meta_key = ‘_price’ AND ***_postmeta.meta_value > ‘0’ )
    AND
    ( mt1.meta_key = ‘_price’ AND mt1.meta_value > ‘0’ )
    AND
    ( mt2.meta_key = ‘_price’ AND mt2.meta_value > ‘0’ )
    AND
    ( mt3.meta_key = ‘_price’ AND mt3.meta_value > ‘0’ )
    AND
    ( mt4.meta_key = ‘_price’ AND mt4.meta_value > ‘0’ )
    AND
    ( mt5.meta_key = ‘_price’ AND mt5.meta_value > ‘0’ )
    AND
    ( mt6.meta_key = ‘_price’ AND mt6.meta_value > ‘0’ )
    AND
    ( mt7.meta_key = ‘_price’ AND mt7.meta_value > ‘0’ )
    AND
    ( mt8.meta_key = ‘_price’ AND mt8.meta_value > ‘0’ )
    AND
    ( mt9.meta_key = ‘_price’ AND mt9.meta_value > ‘0’ )
    ) AND term_relationships.term_taxonomy_id IN (849,851) GROUP BY term_relationships.term_taxonomy_id made by require(‘wp-blog-header.php’), require_once(‘wp-includes/template-loader.php’), include(‘/plugins/woocommerce/templates/taxonomy-product_cat.php’), wc_get_template, include(‘/plugins/woocommerce/templates/archive-product.php’), do_action(‘woocommerce_sidebar’), WP_Hook->do_action, WP_Hook->apply_filters, Avada_Woocommerce->add_sidebar, do_action(‘avada_after_content’), WP_Hook->do_action, WP_Hook->apply_filters, Avada_Layout->append_sidebar_single, get_template_part, locate_template, load_template, require(‘/themes/Avadanew/templates/sidebar-1.php’), generated_dynamic_sidebar, Sidebar_Generator::get_sidebar, dynamic_sidebar, WP_Widget->display_callback, BeRocket_new_AAPF_Widget->widget, the_widget, BeRocket_new_AAPF_Widget_single->widget, the_widget, BeRocket_AAPF_Widget->widget, BeRocket_AAPF_Widget::get_attribute_values, apply_filters(‘berocket_aapf_recount_terms_apply’), WP_Hook->apply_filters, BeRocket_AAPF_faster_attribute_recount->recount_terms
    [10-Sep-2019 12:02:53 UTC] PHP Warning: Error while sending QUERY packet. PID=12638 in /home/***gevps/public_html/wp-includes/wp-db.php on line 2007
    [10-Sep-2019 12:02:53 UTC] PHP Warning: Error while sending QUERY packet. PID=16396 in /home/***gevps/public_html/wp-includes/wp-db.php on line 2007
    [10-Sep-2019 12:04:44 UTC] PHP Warning: mysqli_query(): MySQL server has gone away in /home/***gevps/public_html/wp-includes/wp-db.php on line 2007
    [10-Sep-2019 12:04:44 UTC] PHP Warning: mysqli_query(): Error reading result set’s header in /home/***gevps/public_html/wp-includes/wp-db.php on line 2007
    [10-Sep-2019 12:04:44 UTC] PHP Warning: mysqli_query(): MySQL server has gone away in /home/***gevps/public_html/wp-includes/wp-db.php on line 2007
    [10-Sep-2019 12:04:44 UTC] PHP Warning: mysqli_query(): Error reading result set’s header in /home/***gevps/public_html/wp-includes/wp-db.php on line 2007

    Plugin Author RazyRx

    (@razyrx)

    Hi @kizikeli,

    Do you have any SEO plugin on your site?

    Regards,
    Oleg

    Yes, I have YOAST plugin.

    Plugin Author RazyRx

    (@razyrx)

    Hi @kizikeli,

    Please try update plugin to latest version, disable Yoast SEO and check how it work.

    Regards,
    Oleg

    After update to version 1.4.0.1 it works. Thanks!

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

The topic ‘Filters doesn’t show’ is closed to new replies.