Hi there,

I have an article calling a module. It works fine without server pagination. When I turn on server pagination (plugin Ajax dispatcher is enabled) I get the following message -

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

Any idea what might be causing this?
Thanks!

Btw, I'm testing locally with xampp.

Hello,

"Server side pagination" doesn't work with a complex SQL query (for example when calculated fields are used).

Regards,
ARI Soft

Well, those are really bad news

I'm filtering a table by a date range and the result could potentially have way too many records to be handled without pagination, so I thought pagination was the solution. However, I changed the query so it doesn't have calculated fields nor conditions and still got the same error.

Is there any other way I could handle a table with 20...30 thousand records?

Could you provide the SQL query which you use?

Regards,
ARI Soft

I simplified my query to just this -

SELECT PDATE, CCY, AMT
FROM trans

The table had formatted headers and columns. I removed all of it, leaving almost everything with default values and I still get the JSON warning.

But maybe there's no point in trying to solve this, as I won't be able to use pagination because I'm using calculated fields. I'd appreciate very much if you could point me in the direction of solving how to handle a big table that is the result of a query with variables. Thanks!

Only possible solution to work with large data is used server side pagination.

Regards,
ARI Soft