Problems with DataTables - 20,000 rows

Problems with DataTables - 20,000 rows

ResurgentResurgent Posts: 2Questions: 0Answers: 0
edited May 2013 in General
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.

Replies

  • allanallan Posts: 63,692Questions: 1Answers: 10,500 Site admin
    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
  • ResurgentResurgent Posts: 2Questions: 0Answers: 0
    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.
This discussion has been closed.