Okay
  Public Ticket #3685459
Clear Filters
Closed

Comments

  • Christopher Ross started the conversation

    Hello

    When I select Clear Filters, I get a spinning icon and it never refreshes. I have to exit the page.  I am on the latest updates.

    Thank you

  •  1,819
    Miloš replied


    Hi Christopher,

    Sorry for the waiting time.

    We don't work on weekends so it adds two days to the waiting time.

    we appreciate your patience.


    I am unable to find any table on your Page, so we can't see the issue.


    Can you please tell me what is the table type in question?

    if it is an SQL Table, please check does it have the server-side processing enabled?

    9437879834.png


     or if it is a Manual Table, for that table type, the server-side processing is always working in the background.


    If that is the case, I will advise :

    We currently have this issue which only happens for server-side processing tables when you have caching active on the page.

    Our developers are intensively working to resolve this issue, as soon as possible. I can't say an ETA on it, unfortunately.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    -

    For the time being, the only two possible solutions will be:

    1.  To disable caching only for pages where you have the tables, or perhaps disable caching entirely, if possible.

    Most caching Plugins have the option to add URL's that will be excluded, so if possible, see if you can add the Pages with tables there, and that should solve it for now.

    2. Or you can try disabling the server-side processing option in your Table.

    For the Manual Tables, it is not possible to disable server-side processing,

    but you can make a new SQL Query based table from the same data which is stored in a Manual Table.

    This is how that is done.

    First, check what is the MySQL Table name inside the Editing settings,

    7328050334.png

    then make an SQL Query like : 

     SELECT * FROM TableName  

    For any SQL Query based Table which has less than 2 thousand rows, you will be able to toggle server-side processing in the Data Source settings.

    5424981174.png

    Let me know if that helps and if you have any questions. 


    If this does not resolve the issue, then please send me the URL where you have this table or confirm the Table ID;

    and we also need remote Administrator access :


    Please provide me a temporary WP-admin (administrator) user for your website where this happens, 

    as well as FTP credentials and access to the database ( either link with credentials for PHPmyAdmin, or access to Hosting Panel),

    so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. 

    We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course, we do not provide login data to third parties. 

    You can write credentials here just check PRIVATE Reply so nobody can see them except us.


    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •   Christopher Ross replied privately
  •  1,819
    Miloš replied

    Hi Christopher,

    Thank you for the access.

    Yes, when we hit 'Clear filters', there is an Ajax error on the front-end for this Table.

    6835937173.png

    Or, if we try using a specific filter, like "best for" "Business", the table freezes with an invalid JSON response.

    5825585142.png


    This issue does not happen when filtering the Table on back-end in Wp-Admin.

    There it works fine.

    2127940484.png

    Now, if I clear all the cache on your Site, and try to filter again on front-end Table, the issue goes away in that moment.

    4489553714.png
    5692926793.png
    7761567030.png
    8673313698.png

    Now, I am not very familiar with the JetPack cache settings, so I did my best to Google how to exclude specific URL's from Caching in it, and here is their tutorial Page, the part called "Excluding Specific Parts of the site from Caching".

    This is the screen you need, in order to exclude any URL with a Manual table from caching to fix this issue.

    7532529745.png

    They say you need to go to JetPack, then to "Boost", but if I try that on your JetPack, it says you need to upgrade it to some premium version, I am not honestly sure, as JetPack is not our Plugin so we are not familiar with all the options for it.

    9396123577.png

    Can you please try to exclude the Page URL of this Table from caching in JetPack, also double-check if you use any additional caching on front-end, you can reach out to your Hosting Support to make sure.

    If you can't find the way how to exclude Pages from caching for JetPack, please reach out to JetPack Support and ask them to help you do this.

    Basically, this is going to resolve any issue with Manual tables.

    Let me know how it goes.

    Thank you.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables