Problems with DataTables - 20,000 rows

Resurgent

Hello,

I'm having a problem with DataTables which I am utilising to display roughly 20,000 rows from a table that contains care home data.

I am getting the following errors:

Datatables warning (table id ='all_issued'): Requested unknown paramater '0' from the data source for row 15646

Uncaught TypeError: Cannot read property 'className' of undefined

Also, when I do try to load more than 5000 rows into datatables, I get a memory exceeded problem and datatables fails to initialize correctly.

I'm really stumped as to what the problem is. Any help would be appreciated. Its running on a LAN so I cannot provide a link.

allan

That error usually means that `rows * columns != cells` - which has to be true for DataTables.

Regarding the memory exceeded - I presume it is the server-side script giving the error?

Allan

Resurgent

No, its a javascript error within the browser that I am picking up using Google Chrome debugger.

As for rows * columns != cells, what could possibly be the cause of that then? The data is being spewed out server side.