DataTables warning: JSON data from server could not be parsed.

baset

Hi Allan ,
I have a problem with DataTable. I am trying server side datatables using JSON Array then it does every thing correctly Paging ,sorting ..Etc but when i 'm trying to search then i get this error
BTW : i debugged and find that the jason array is formatted correctly (i checked it )
Could you help me with that ??

GregP

If the JSON is passing a test (like jsonlint.com) it may still not be suitable for DataTables to process. DataTables is expecting certain variables to be part of the JSON, and the JSON to be nested in a certain way. Check the server-side documentation for an example, and compare it to the JSON that's being sent back.

baset

I think that the jason format is correct because it shows the data from database correctly in paging and sorting in the JSP but when it came to searching this error comes out
i did some thing like changing versions of datatable , do you think that may cause that error ??

allan

> but when it came to searching this error comes out

Almost certainly the error is in your SQL (assuming you are using an SQL database) that is adding the WHERE condition for your filter then. Have a look at the JSON return in Firebug, there will likely be an error message there indicating what the error is.

Allan