When using the jQuery datatables plugin, why am I getting this error?
"k is undefined" -style typeof e.saved_aaSorting=="undefined")
The cells must all either be “locked” or “unlocked”. Attempting to run the Data Table tool when all the cells in the table are not consistent will result in an error. To check or change the “locked” settings of a cell, select the cell, go to the Format Cells menu (CTRL + 1), and choose the Protection tab.
The maximum number of rows that a DataTable can store is 16,777,216.
jQuery DataTable is a powerful and smart HTML table enhancing plugin provided by jQuery JavaScript library. It is a highly flexible tool that is basically created to display information in tables as well as adding interactions to them, hence, enhancing data accessibility in HTML tables.
A. DataTables is free, open source software that you can download and use for whatever purpose you wish, on any and as many sites you want.
I posted this answer to document something for future reference for myself, I hope it will help someone else on down the line.
From the usage page (a little RTFM):
In order for DataTables to be able to function correctly, the HTML for the target table must be laid out in a well formed manner with the 'thead' and 'tbody' sections declared.
In my case, the <thead>
and <tbody>
sections were missing. Oops.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With