JQuery Datatables Cannot read property aDataSort of undefined

Question

I created this fiddle to and it works well as per my requirements  Fiddle  However  when I use the same in my application I get an error in the browser console saying Cannot read property  aDataSort  of undefined  In my application  the javascript reads something like as below  I have checked the controller output   it works well and is printed on the console too     document  ready function            getJSON  three htm   function data                    console log  loadDataTable  gt  gt     JSON stringify data                                  fail function  jqxhr  textStatus  error                  var err   textStatus          error               alert err                console log   Request Failed      err                                 success function data                    loadDataTable data                         function loadDataTable data                recentSubscribers   dataTable   fnDestroy                 var oTable       recentSubscribers   dataTable                 aaData    JSON parse data subscribers                 processing   true               bPaginate   false               bFilter   false               bSort   false               bInfo   false               aoColumnDefs                   sTitle    Subscriber ID                aTargets    0                            sTitle    Install Location                aTargets    1                            sTitle    Subscriber Name                aTargets    2                            aTargets    0                 mRender   function  data  type  full                    return   lt a style  text-decoration none   href     class  abc  gt     data     lt  a gt                                           aoColumns                   mData    code                            mData    acctNum                            mData    name

User · Answer

You need to switch single quotes     to double quotes     because of parse  if you are using data-order attribute on the table then use it like this data-order    1   asc

User · Answer

It s important that your THEAD not be empty in table As dataTable requires you to specify the number of columns of the expected data   As per your data it should be   lt table id  datatable  gt       lt thead gt           lt tr gt               lt th gt Subscriber ID lt  th gt               lt th gt Install Location lt  th gt               lt th gt Subscriber Name lt  th gt               lt th gt some data lt  th gt           lt  tr gt       lt  thead gt   lt  table gt

User · Answer

In my case I solved the problem by establishing a valid column number when applying the order property inside the script where you configure the data table   var table       mytable   DataTable                             order     1   desc

User · Answer

I had this problem and it was because another script was deleting all of the tables and recreating them  but my table wasn t being recreated  I spent ages on this issue before I noticed that my table wasn t even visible on the page   Can you see your table before you initialize DataTables   Essentially  the other script was doing   let tables      table    for  let i   0  i  lt  tables length  i        const table   tables i     if    fn DataTable isDataTable table           table  DataTable   destroy remove         table  empty            And it should have been doing   let tables      table some-class-only        the rest

User · Answer

I faced the same problem  the following changes solved my problem     document  ready function              datatable   dataTable                bSort  false              aoColumns      sWidth   45        sWidth   45        sWidth   10    bSearchable  false  bSortable  false               scrollY           200px            scrollCollapse   true           info             true           paging           true                 the aoColumns array describes the width of each column and its sortable properties      Another thing to mention this error will also appear when you order by a column   number that does not exist

User · Answer

For me  the bug was in DataTables itself  The code for sorting in DataTables 1 10 9 will not check for bounds  thus if you use something like  order    1   asc      with an empty table  there is no row idx 1 -  this exception ensures  This happened as the data for the table was being fetched asynchronously  Initially  on page loading the dataTable gets initialized without data  It should be updated later as soon as the result data is fetched   My solution      add within function  fnStringToCss  s   in datatables js    directly after this line    srcCol   nestedSort i  0    if srcCol  gt   aoColumns length        continue        this line follows     aDataSort   aoColumns  srcCol   aDataSort

User · Answer

Also had this issue  This array was out of range   order   1   asc

User · Answer

I got the error by having multiple tables on the page and trying to initialize them all at once like this     table   DataTable     After a lot of trial and error  I initialized them separately and the error went away     quot  table1-id quot   DataTable       quot  table2-id quot   DataTable

User · Answer

In my case I had       my table   empty      Where it should have been       my table tbody   empty      Note  in my case I had to empty the table since i had data that I wanted gone before inserting new data   Just thought of sharing where it  might  help someone in the future

[javascript] JQuery Datatables : Cannot read property 'aDataSort' of undefined

Examples related to javascript

Examples related to jquery

Examples related to jquery-datatables