JSON problem with Server Side Processing when moving from 1.9.0 to 1.9.1

jvdijk

I've been using a table with server side processing for a while, without any issues. Now when moving from 1.9.0 to 1.9.1 it suddenly gives me the error:

DataTables warning (table id = 'results_list'): DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.

The JSON is correct according to JSONLint.

DataTables debugger reference: uneris

Any ideas what change between 1.9.0 and 1.9.1 could be causing this?

Thanks,

Jack

allan

Thanks very much for using the debugger on this :-)

This is what your server is replying to for the data request:

> Unknown column 'sort_date' in 'order clause'

There is nothing in DataTables itself what would refer specifically to that columns, so perhaps the server-side processing script you are using has changes, or the database itself?

Allan

jvdijk

Strange that this now shows up, because nothing has changed with this recently. But the reason for this is that I'm showing a table with some items that have occured on a certain date. Because of the way I wanted to display dates in the table I used a second (hidden) column to sort on if the date header was clicked and that's the sort_date. Now with the server side processing this shouldn't be needed anymore.

Thanks for the help!