sAjaxSource in datatable returns error

Question

I keep on receiving this error alert = "DataTables warning (table id = 'msnc_table'): Requested unknown parameter '1' from the data source for row 0"

Here's a snippet of my code:

HTML:

  <table id="msnc_table" class="dataTable">
  <thead>
    <tr>
        <th>Doc#</th>
        <th>Date</th>
        <th>Code</th>
        <th>Customer Name</th>
        <th>S/m</th>
        <th>Gross</th>
        <th>Disc</th>
        <th>Net</th>
        <th>S.Disct</th>
        <th>Invc</th>
    </tr>
 </thead>
 <tbody>
     <tr>
         <td class="dataTables_empty">Loading data from server</td>
     </tr>
 </tbody>
 </table>

JS

var msnc_table = $('#msnc_table').dataTable({
   "bProcessing": true,
   "bServerSide": true,
   "iDisplayStart": 0,
   "iDisplayLength": 11,
   "sAjaxSource": base_url+"raw/raw_ajax/get_mnsc",
   "bRetrieve": true
});

PHP function

function get_mnsc()
{
   echo '{"sEcho":"2","iTotalRecords":20,"iTotalDisplayRecords":20,"aaData":   [["232412","12\/8\/2012","DSDA2312","Alfonso supermarket","213","231213","21312","2313","2313","2312432\r\n"],["232412","12\/8\/2012","ADS332","MCL Store","213","231213","21312","2313","2313","2312432\r\n"]]}'
}

score 0 · Answer 1 · edited May 23 '17 at 11:45

This kind of error from Datatables.net usually means there is a mismatch between the headers / columns you specify and the JSON returned from the server.

However, in your case there seem to correctly be 10 ths and 10 items in each 'row' of JSON.

This makes me think that the JSON is incorrectly formatted, or that DataTables can't process some part of it.

I'd suggest you whip open fiddler and inspect the response as it actually is on client, I don't know much php, so not certain how that echo will actually appear on the client. But certainly think you should encode and set the headers e.g.

Returning JSON from a PHP Script

You can copy that fiddler output to http://jsonformatter.curiousconcept.com/ or http://jsonlint.com/ to validate it.

It may be your dates, with what look like escape characters before the slashes?, are messing it up. N.B. my dates are returned e.g.

"31/07/2005",

It may be that the line breaks which look to be in wrong place in your JSON are messing it up?

"2312432\r\n"]

Suggest you remove them entirely and see if it works, or place the break after the quotes, or after the square bracket closes?

"2312432"\r\n]

"2312432"]\r\n

Not sure, but certainly mod the php as per link, and use fiddler to inspect actual response if you're still having problems.

If you still have issues, then check the answer here.. may help https://stackoverflow.com/a/11475749/661584

Good Luck ! Worth it to get Datatables.net working - its great !

sAjaxSource in datatable returns error

1 Answers1

Linked