DataTables warning ... Requested unknown parameter

azka2010

Hello,

datatable alert me with this message, every time i reload the webpage or go to next page (table paging).

DataTables warning (table id = 'smGrid11_1308053925_39'): Requested unknown parameter '5' from the data source for row 0

and i don't think there's something wrong with the table result. the table still load all data from server completely.

should i just ignore this warning or what ?

Thanks,
Regards,
Azkadina

azka2010

Ah, find it myself ... header table has more column than the data itself ...

diana888

I have a same problem: the error message is: DataTables warning: requested unknown parameter '0' from the data source for row 0. No idea.

Thanks a lot if someone give any clue.

allan

This message means that DataTables is looking at your data source for array position 0 and not finding it. Why that is depends on your usage of DataTables. You'll need to post your JSON data and your DataTables initialisation code - or even easier a link.

Allan

goodideadave

I'm developing on an intranet, and have been getting the same message as diana888 as well as the footer says, "showing 1 to 1 of NaN entries (filtered from NaN total entries)". The JSON data looks like this:
[code]
{
"aaData": [
{
"UserID": 671,
"DeleteColumn": "1377",
"EditColumn": "1377",
"ExplicitPermissions_UserReportRoleID": 0,
"ReportNameColumn": "ProviderTrend",
"ReportRoleColumn": "Impersonate",
"ImpersonateColumn": true,
"ProviderID": 0,
"UserName": "Cramer, Katherine",
"ExplicitPermissionCount": "1",
"DenyColumn": false,
"CommentsColumn": "Test record",
"ImpersonateMedicalGroupProviderID": "1-503",
"ImpersonateProviderName": "ABATE MD,LORRAINE E"
}
]
}
[/code]
The datatable definition looks like this:
[code]
$('#UserReportRole').dataTable({
"bProcessing": true,
"bServerSide": true,

"sAjaxSource": TargetUrl,
"sAjaxDataProp": "aaData",
"sScrollX": '100%',
//"sScrollXInner": "1000px",
"bScrollCollapse": true,
"bAutoWidth": false,
"sScrollY": "440px",
"bProcessing": true,
"bPaginate": false,
"bDestroy": true,
"aoColumns": [
{ /* UserID */"sWidth": "20px", "fnRender": function(obj) {
var str = obj.aData.UserID.toString();
return str;
}, "bUseRendered": false
},
{ /*DeleteColumn*/"sWidth": "56px", "fnRender": function(obj) {
var str = 'Delete';
return str;
}, "bUseRendered": false
},
{ /* EditColumn */"sWidth": "56px", "fnRender": function(obj) {
var ar = [];
ar[ar.length] = "

fbas

I think your server-side script is not outputting the expected values in JSON. here's a sample of my JSON

[code]
{"sEcho":2,"iTotalRecords":"24467","iTotalDisplayRecords":"24467",aaData: [[...],[...]]}

[/code]

this is where the number of records is specified (and without it you're getting NaN) and also in my case aaData is an array of arrays (set of rows). Your JSON looks like an array of objects.

so.. what's your server-side script look like?

goodideadave

My server-side script is an ASP.NET generic handler. My JSON is indeed an array of objects; I thought that was kosher. I create a generic List of objects and use the Newton-King dll to serialize it:
[code]
_jsonReturn = JsonConvert.SerializeObject(items);
_jsonReturn = "{\"aaData\":" + _jsonReturn + "}";
[/code]

It will show the data in the table, and the data passes JSON lint OK.

goodideadave

Found my problem.

Switched to using aoColumnDefs instead of aoColumns, which helped me figure out that the order of name-value pairs in the JSON was off.

goodideadave

Whoops, not so fast. The footer now shows "Showing 1 to 640 of NaN entries (filtered from NaN total entries)". What's that all about?

allan

That bit is almost certainly due to the return not including the JSON bits of information that DataTables needs. The parameters required are defined here: http://datatables.net/usage/server-side , and end up looking something like what fbas posted.

Allan

goodideadave

Yep, that was it. Thanks, all.

mathias

I have the same problem.

[quote]allan said:

This message means that DataTables is looking at your data source for array position 0 and not finding it. [/quote]

The message means wrong, as it displays the data in my data source correctly, ergo DataTables was able to find everything.

This is how I set it up:
the table:
[code]




Contact person
Title
Website
Description
B2B
B2C




<?php foreach ($services as $service): ?>


<?php echo Doctrine_Core::getTable('employee')->find($service->getContactPerson()); ?>
<?php echo $service->getTitle() ?>
<?php echo $service->getWebsite() ?>
<?php echo $service->getDescription() ?>
<?php echo $service->getB2b() ?>
<?php echo $service->getB2c() ?>

<?php endforeach; ?>


[/code]

the form:
[code]




<?php echo $form->renderHiddenFields(false) ?>
 Back to list
<?php if (!$form->getObject()->isNew()): ?>
 <?php echo link_to('Delete', 'service/delete?id='.$form->getObject()->getId(), array('method' => 'delete', 'confirm' => 'Are you sure?')) ?>
<?php endif; ?>





<?php echo $form->renderGlobalErrors() ?>


<?php echo $form['contactPerson']->renderLabel() ?>

<?php echo $form['contactPerson']->renderError() ?>
<?php echo $form['contactPerson']->render(array('rel'=>'0' )) ?>



<?php echo $form['title']->renderLabel() ?>

<?php echo $form['title']->renderError() ?>
<?php echo $form['title']->render(array('rel'=>'1' )) ?>



<?php echo $form['website']->renderLabel() ?>

<?php echo $form['website']->renderError() ?>
<?php echo $form['website']->render(array('rel'=>'2' )) ?>



<?php echo $form['description']->renderLabel() ?>

<?php echo $form['description']->renderError() ?>
<?php echo $form['description']->render(array('rel'=>'3' )) ?>



<?php echo $form['b2b']->renderLabel() ?>

<?php echo $form['b2b']->renderError() ?>
<?php echo $form['b2b']->render(array('rel'=>'4','value'=>'1' )) ?>



<?php echo $form['b2c']->renderLabel() ?>

<?php echo $form['b2c']->renderError() ?>
<?php echo $form['b2c']->render(array('rel'=>'5','value'=>'1' )) ?>





[/code]

the action:
[code]
public function executeAdd(sfWebRequest $request)
{
$service = new service();
$service->setContactPerson($_REQUEST['service']['contactPerson']);
$service->setTitle($_REQUEST['service']['title']);
$service->setWebsite($_REQUEST['service']['website']);
$service->setDescription($_REQUEST['service']['description']);
$service->setOrganization(sfContext::getInstance()->getUser()->getGuardUser()->getOrganization());
$service->setB2b($_REQUEST['service']['b2b']);
$service->setB2c($_REQUEST['service']['b2c']);
$service->save();

$this->id = $service->getId();
}
[/code]
the template that returns $id:
[code]
<?php

echo $id;

?>
[/code]

any idea?

mathias

the rows that are making trouble are b2b and b2c. in the form they are both checkboxes. if i change them to text input, warning is gone. why would checkboxes make trouble?

allan

No idea I'm afraid - did you run your page through the W3C validator? A link would help :-)

Allan

mathias

Two posts ago I wrote something wrong:
[quote]The message means wrong, as it displays the data in my data source correctly, ergo DataTables was able to find everything.[/quote]
I didn't look careful enough. The row gets added, but the trouble columns are empty until I refresh. So the message is right.

[quote]No idea I'm afraid - did you run your page through the W3C validator? A link would help :-)[/quote]
Thank you. Good idea, I'm doing that just now, 31 Errors, 2 warning(s).

Am I right in assuming that with DataTabels editable checkboxes work the same way like any other form element? Or is there something I have to adhere to?

mathias

this is how the form gets rendered in html:
[quote]




 Back to list







ContactPerson


Hans Meiser (Hans Meiser)



Title




Website




Description




B2b




B2c






[/quote]

mathias

I've read that jEditable doesn't support checkboxes by default. But jEditable is not involved in adding records, only in in updating, isn't it?

mathias

[quote]mathias said: Am I right in assuming that with DataTabels editable checkboxes work the same way like any other form element? Or is there something I have to adhere to?[/quote]

ha, that assumption was wrong. author of database-editable doesn't seem to like checkboxes.

to make it work you have to edit jquery.dataTables.editable.js on line 283 add
[code]input:checkbox[rel][/code]

mathias

hmmm, but now it always returns value=1 no mather the actual valua, until I refresh.

EDIT: Lol, I'm dumb.
[code]
else if ( ( this.nodeName.toLowerCase() == "input" && this.type=="checkbox" ) || (this.tagName.toLowerCase() == "input" && this.type=="checkbox"))
if (this.checked)
{sCellValue = '1';}
else {sCellValue = '';}
else
[/code]

smader12

I think you could have this issue for a number of reasons...just in case anyone else needs a quick work-around because their JSF data table renders a row with one cell when there's no data (e.g. ), I used this JS to get around it (you'd have to use your own variable names/element ID's/etc. of course):

[code]
function doMyPageReady()
{
x = document.getElementById("SourcingForm:parts"); // The table
if ( x && x.tBodies && x.tBodies.length>0 )
{
// This works for me, but you're match criteria may vary
if ( x.tBodies[0].innerHTML.length==20 && x.tBodies[0].rows.length ==1 )
{
x.tBodies[0].deleteRow(0);
}
}
oTable = jQuery("#SourcingForm\\:parts").dataTable({
"sScrollY": "200px",
"bScrollInfinite": true,
"iDisplayLength" : -1
});
.
.
.
[/code]

dvnandover

For me the same error message but some of my column the data value are null. So using if/else statement to assign a empty value when the column data is null would fix it for me.

pandutatikonda

Hello,

Data is not setting to the table?

[code] function getRows(){
xyzManager.getRows(... , function(data){
//how to set this response data to the table.
dataTable.fnAddData(data);
})
}

dataTable = jQuery("#list").dataTable({
"bJQueryUI": true,
"bAutoWidth":false,
"sPaginationType":"full_numbers",
"bProcessing":true,
"bPaginate":true,
"fnServerData":getRows(),
"aoColumns": getColumns()
});
[/code]

allan

Try:

[code]
"fnServerData":getRows,
[/code]

so passing the function, rather than the result of the function.

Allan

pandutatikonda

Hi allan,

Thanks for reply. It is fixed. Problem in JSON format.

heriquet

Hi,

I also got this error...

I was declaring a variable inside an "if" and used the variable in my fnAddData(). But the code were not inside the if.

So when dnAddData was called, I had the error.

=> when using an uninitialized variable, you got also the error.

Maybe this case should be managed by the plugin to tell that the parameter passed was not declared ? 'don't knof if it's possible...

Hope this helps! Thank you for this wonderfull plugin!

[code]

The initialization :

if(relation.origin == null)
{

var delRel = "Delete relation";
}

The fnAddData :

$('#tableRelations').dataTable().fnAddData( [
delRel,
radioB,
linkRel,
cdQual,
"pa",
"lieu",
relation.name,
dt,
refRel,
"cdQual"
] );


=> if relation.origin is not null, I get the error
[/code]

hackdracko

Este problema se refiere a que la tabla esta mal construida probablemente falta cerrar algun td o tr, o puede que este sobrando alguno de ellos deberian checar bien como esta construida su tabla.
SALUDOS

dvnandover

Can't seem to be able to get around this error. Here are my aaData:
"{\"sEcho\":1,\"iTotalRecords\":\"3\",\"iTotalDisplayRecords\":\"3\",\"aaData\":
[{\"UserName\":\"AAW0\",\"FirstName\":\"John\",\"LastName\":\"Doe\",\"Active\":1},
{\"UserName\":\"LM945\",\"FirstName\":\"John2\",\"LastName\":\"Doe2\",\"Active\":1},
{\"UserName\":\"tgm2\",\"FirstName\":\"Jane\",\"LastName\":\"Doe\",\"Active\":1}]}"
and here is my table initialization:
function LoadDataTables() {
//debugger;
oTable = $("#tblUserList").dataTable({
"bJQueryUI": true,
"iDisplayLength": 25,
"bProcessing": true,
"bServerSide": true,
"bDestroy": true,
"sAjaxSource": "DataBaseTable.ashx?table=IUsers&action=select&usergroup=" + $('#UserGroup').val(),
"sPaginationType": "full_numbers",
"aLengthMenu": [[25, 50, 100, -1], [25, 50, 100, "All"]]
})
.makeEditable({
sUpdateURL: "DataBaseTable.ashx?table=IUsers&action=update",
sUpdateHttpMethod: "POST",
sAddURL: "DataBaseTable.ashx?table=lUsers&action=new",
sAddHttpMethod: "POST",
sDeleteURL: "DataBaseTable.ashx?table=lUsers&action=delete",
sDeleteHttpMethod: "POST",
"aoColumns":
[
{
indicator: 'Saving...',
cancel: 'Cancel',
submit: 'OK',
tooltip: 'Click to edit UserName'
},
{
indicator: 'Saving...',
cancel: 'Cancel',
submit: 'OK',
tooltip: 'Click to edit First Name'
},
{
indicator: 'Saving...',
cancel: 'Cancel',
submit: 'OK',
tooltip: 'Click to edit Last Name'
},
{
indicator: 'Saving...',
cancel: 'Cancel',
submit: 'OK',
tooltip: 'Click to set User Active/InActive'
}
],
"aaSorting": [[1, "asc"]],
oAddNewRowButtonOptions: { label: "Add...",
icons: { primary: 'ui-icon-plus' }
},
oDeleteRowButtonOptions: { label: "Remove",
icons: { primary: 'ui-icon-trash' }
},
oAddNewRowFormOptions: {
title: 'Add a new User',
show: "blind",
hide: "explode",
modal: true
},
sAddDeleteToolbarSelector: ".dataTables_length"
});
}

allan

@dvnandover: You need to use mDataProp to tell DataTables where to get the data - see this blog post for more details: http://datatables.net/blog/Extended_data_source_options_with_DataTables

@heriquet: In future I'm going to look at having DataTables use the default content for a cell if the parameter is not available. The difficult point is that generally this warning behaviour is good since in most cases it is an error - but sometimes you actually that that. It might be a new init option to switch modes.

Allan

dvnandover

I got it thank you very much allan.

Edit: Just found out that tabletools export (clipboard, excel, pdf) with undefined data instead of actual data. Why? Has anyone encounter the same problem?

Edit: I found this thread: http://datatables.net/forums/discussion/5346/problems-with-1.8-mdataprop-and-tabletools-exporting-csv-excel.../p1
dp i replaced the line# 1414 of the TableTools.js version 2.0.1 with this line:
var mTypeData = dt.aoData[dt.aiDisplay[j]]._aData[dt.aoColumns[i].mDataProp];
and the export worked except the print button which print preview does not show anyrecords for the table eventhough there are 25 record being displayled at that moment.

dvnandover

For somereason the default setting of bShowAll set to true in the TablesTool.js file which caused my problem so i set bShowAll = false in the TablesTool initialization for the print button like this:
{
"sExtends": "print",
"bShowAll: false
}
Now the print button worked.

argentario84

hi all,
and hi allan, datatable is great :)

I have a problem.
I show with datatables the result of xslt trasformation. I have always the because in my xml i have always these values, but it's possible that I haven't tag, so i received the warning "Requested unknown parameter '1' from the data source for row 0".

The table is not well formed. Is there a way to show the datatable thead and "No results" like tbody in that case??

Ps. Thanks, and sorry for my poor English