public
Created

JQuery Datatables warning: Requested unknow parameter...

  • Download Gist
gistfile1.txt
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
Versions: Datatables 1.8.x
 
If get error such as:
 
DataTables warning (table id = 'myTable'): Requested unknown parameter '2'
from the data source for row 0
 
Means num of columns in table heading and in data as specified in
aoColumns do not match. Making sure are same number should fix this.
 
If using server side processing, make sure each col in aoColumns has an
mDataProp prop, else you will get the error above. mDataProp can be null
if you plan to overwrite in fnRowCallback. For example:
 
venuesTable = $("#venuesTable").dataTable
"bServerSide": true,
"sAjaxSource": "/venues",
"aoColumns":[
{"sWidth": '200px', "mDataProp": "venue.name"},
{"sWidth": '300px', "mDataProp": "venue.address"}
{"sWidth": '260px', "mDataProp": null, bSearchable: false, bSortable: false}
],
"fnServerData": ( sSource, aoData, fnCallback ) ->
$.getJSON sSource, aoData, (json) ->
#Do whatever additional processing you want on the callback
#, then tell DataTables
#e.g. json.aaData = [['1','1','1','1'],['2','2','2','2']]
fnCallback(json)
"fnRowCallback": (nRow, aData, iDisplayIndex) ->
venue = aData.venue
$('td:eq(2)', nRow).html "<a href='/venues/#{venue.id}'>Show</a>"
nRow

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.