Okay
  Public Ticket #2934075
Invalid JSON response
Closed

Comments

  • Kevin Elphick started the conversation

    My data tables are not working, in the console I see the following errors:

    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 K (wdt.frontend.min.js?ver=3.4.4:8)
        at Object.error (wdt.frontend.min.js?ver=3.4.4:7)
        at c (jquery.min.js?ver=3.6.0:2)
        at Object.fireWith [as rejectWith] (jquery.min.js?ver=3.6.0:2)
        at l (jquery.min.js?ver=3.6.0:2)
        at XMLHttpRequest.<anonymous> (jquery.min.js?ver=3.6.0:2)
    mrktinsights.com/:1 Uncaught SyntaxError: Unexpected token < in JSON at position 0
        at JSON.parse (<anonymous>)
        at Object.success (main.js?ver=4.5.10:2)
        at c (jquery.min.js?ver=3.6.0:2)
        at Object.fireWith [as resolveWith] (jquery.min.js?ver=3.6.0:2)
        at l (jquery.min.js?ver=3.6.0:2)
        at XMLHttpRequest.<anonymous> (jquery.min.js?ver=3.6.0:2)


    Also when trying to create a new table using an SQL query, the following error pops up:

    There was an error while trying to save the table! parsererror {"allColumns":

    Any help is much appreciated,

    Thanks

  • [deleted] replied

    Hi Kevin

    Thank you for reaching out to us.

    JSON errors usually occur if you have a security plugin installed, or there's a security measure blocking admin-ajax calls. Also, if the pages are cached, it can occur. Try excluding pages where you have our tables loaded from being cached, and try again.

    If there's a notice, warning or fatal error WordPress that manifests through responses. Our table requires a valid JSON in the response, so if there are these notices, the JSON is not valid, and the data is not being loaded.

  • Kevin Elphick replied

    Thank you for the quick response. I have resolved it now and it looks like it was caused by a website error. Not sure whether it was the theme and/or plugin causing an issue. But resetting things and activating each plugin one by one has fixed the issues. Thanks again

  • [deleted] replied

    You are most welcome I am glad to hear everything is good nowsmile.png

    If there is anything else we can assist you with please don't hesitate to open a new ticket.

    Have a wonderful day!