DataTables Cannot read property length of undefined

Question

I understand this a popular issue  and I have read all the similar questions here on Stack Overflow and other sites  including the datatables website    To clarify  I am using   PHP Codeigniter Materliazecss   I have also made sure that I received the JSON array correctly      name en   hello   phone   55555555     name en   hi   phone   00000000      My HTML table looks like this    lt table id  customer table  gt        lt thead gt            lt tr gt               lt th gt Name lt  th gt               lt th gt Phone lt  th gt            lt  tr gt        lt  thead gt   lt  table gt    And here is my document ready function       document  ready function                      customer table   DataTable                    customer table   DataTable                     ajax    json                    dataSrc                         columns                            data    email                            data    name en                                              The error I am getting is     Uncaught TypeError  Cannot read property  length  of undefined

User · Answer

It s even simpler  just use dataSrc    option in the ajax defintion so dataTable knows to expect an array instead of an object           pos-table2   DataTable                     processing  true                    serverSide  true                    ajax  url  pos json  dataSrc                            See ajax options

User · Answer

When you have JSON data then the following error appears   A better solution is to assign a var data for the local json array object  details see  https   datatables net manual tech-notes 4  This is helps you to display table contents       document  ready function                    customer table   DataTable              aaData   data               aoColumns                                   mDataProp    name en                                                            mDataProp    phone                                                            mDataProp    email                                                            mDataProp    facebook

User · Answer

you can try checking out your fields as you are rendering email field which is not available in your ajax   x000D   x000D    ajax   x000D    url   url   x000D    type   GET   x000D    success  function data    x000D      var new data     x000D         data   data x000D         x000D      console log new data   x000D      x000D      x000D   x000D   x000D

User · Answer

It can happen when your view property name and name inside column section of data table is not matching   Make sure that property name and column data name are matching

User · Answer

If you are using ajax as a function remember it expects JSON data to be returned to it  with the parameters set       example   dataTable        ajax    function  data  callback  settings            callback               data                     recordsTotal  40              recordsFiltered  40

User · Answer

OK  thanks all for the help   However the problem was much easier than that   All I need to do is to fix my JSON to assign the array  to an attribute called data  as following        data           name en    hello        phone    55555555        email    a shouman        facebook    https     www facebook com

User · Answer

CAUSE  This errors TypeError  Cannot read property  length  of undefined usually means that jQuery DataTables cannot find the data in the response to the Ajax request   By default jQuery DataTables expects the data to be in one of the formats shown below  Error occurs because data is returned in the format other than default   Array of arrays         data                       Tiger Nixon             System Architect              320 800             2011 04 25             Edinburgh             5421                   Array of objects         data                       name    Tiger Nixon             position    System Architect             salary     320 800             start date    2011 04 25             office    Edinburgh             extn    5421                   SOLUTION  Use default format or use ajax dataSrc option to define data property containing table data in Ajax response  data by default    See Data array location for more information   LINKS  See jQuery DataTables  Common JavaScript console errors for more details

User · Answer

In my case  i had to assign my json to an attribute called aaData just like in Datatables  ajax example which data looked like  this

User · Answer

While the above answers describe the situation well  while troubleshooting the issue check also that browser really gets the format DataTables expects  There maybe other reasons not to get the data  For example  if the user does not have access to the data URL and gets some HTML instead  Or the remote system has some unfortunate  fix-ups  in place  Network tab in the browser s Debug tools helps

User · Answer

This is really late to the party  but none of the solutions above worked for me  I didn t want the  quot Found total xxx records quot  so I added info false to the config  When I removed that everything worked  I should note that the first page loaded fine  When I hit next  the second page loaded  but immediately threw the above console error

User · Answer

Try as follows the return must be d  not d data   ajax           url    xx xxx xxx          type    GET          error   function  e                    dataSrc   function  d             return d

[jquery] DataTables: Cannot read property 'length' of undefined

Examples related to jquery

Examples related to json

Examples related to codeigniter

Examples related to datatables

Examples related to html-table