Hey everyone!

With the holiday season upon us, we want to share our upcoming working hours:

After that, we’ll return to our regular schedule and assist you as quickly as possible.

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find tons of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel), which might just have the answers you need while we’re away.

Thanks a bunch for your understanding and support!

Warm regards and happy holidays!

TMS

Okay
  Public Ticket #2934075
Invalid JSON response
Closed

Comments

  • Kevin Elphick started the conversation
    December 8, 2021 at 3:32pm

    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
    December 8, 2021 at 9:15pm

    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
    December 8, 2021 at 10:20pm

    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
    December 9, 2021 at 2:37pm

    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!