Okay
  Public Ticket #3041872
queries not working
Closed

Comments

  • Tracey Sisko started the conversation

    Search the Muster Roll queries are not working most of the time.  


    See error:  

    JQMIGRATE: Migrate is installed, version 3.3.2

    6jquery.dataTables.min.js?ver=3.6:6477

           

           Uncaught Error: DataTables warning: table id=table_1 - Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1

        at _fnLog (jquery.dataTables.min.js?ver=3.6:6477:11)

        at Object.error (jquery.dataTables.min.js?ver=3.6:3904:7)

        at c (jquery.min.js?ver=3.6.0:2:28327)

        at Object.fireWith [as rejectWith] (jquery.min.js?ver=3.6.0:2:29072)

        at l (jquery.min.js?ver=3.6.0:2:79926)

        at XMLHttpRequest.<anonymous> (jquery.min.js?ver=3.6.0:2:82355)

  •  2,572
    Aleksandar replied

    Hello Tracey

    Thank you for your purchase.

    These errors can happen for a few reasons, but they always happen for server-side tables (MySQL, manual, or imported tables).

    Check if you have any errors, notices, or warnings in your console. If there are, resolve them first because they are interrupting wpDataTables' admin-ajax calls and the errors returned are referring to either bad Ajax or bad JSON response.

    Another thing that could be causing this is cache. If the data is being cached on the page, the returned data is not the same, or not at least what wpDataTables is expecting to see, so the error occurs. Try clearing all cache from your website and browser, and then prevent the pages containing wpDataTables from being cached.

    Last, it could be the data in the table(s) - if the data is not the type that it should be (for example, a non-numerical value in an integer or a float column), or if the data has been changed for a formula column. Try creating a new table from the source table and see if it's going to cause errors. If it doesn't (after excluding cache as the cause), look for differences between data, filters, etc.

    I hope that helps.

    Kind Regards, 

    Aleksandar Vuković
    [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