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, 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.
Hello,
i often get the following error message, especially when i reopen the browser after a while with a page that contains a wpdatatable.
DataTables warning table_id=table_1 Invalid JSON resonse. For more information about this error, please see http://datatables.net/tn/1
Any idea how i could solve that?
Regards,
Michael
We get the same thing !!! Would love to know the reason/ answer as well.
Hello Michael and MJ
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, 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 | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia 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