Error dom_sort with ajax source
Error dom_sort with ajax source
I use dom sort (dom-text) & get error:
[quote]DataTables warning (table id = 'manage_table'): Requested unknown parameter '4' from the data source for row 0[/quote]
My code:
[code]
Name
Note
Status
Position
Id
oManageTable = $('#manage_table').dataTable({
"bProcessing": true,
"sAjaxSource": "<?php echo site_url($current_controller.'/entries'); ?>",
"bDeferRender": true,
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"aaSorting": [[5,'desc']],
"bStateSave": true,
"aoColumns": [
{"sClass": "center no_sort", "bSortable": false, "bSearchable": false,},
null,
null,
{"sClass": "center", "bSearchable": false,},
{"sClass": "center", "sType": "numeric", "sSortDataType": "dom-text"},
{"sClass": "center", "sType": "numeric"},
{"sClass": "center no_sort", "bSortable": false, "bSearchable": false,}
]
});
[/code]
[code]
{
"aaData": [
[
"",
"Content 709",
"Note 709",
"0",
"",
"3715",
"\r
\r
<\/a>\r
\r
\r
\r
<\/a>"
],
[
"",
"Content 710",
"Note 710",
"0",
"",
"3716",
"\r
\r
<\/a>\r
\r
\r
\r
<\/a>"
],
[
"",
"Content 718",
"Note 718",
"0",
"",
"3724",
"\r
\r
<\/a>\r
\r
\r
\r
<\/a>"
]
]
}
[/code]
It won't have error if I remove dom sort.
Edit:
The first load (sort id column by default or any column) still has no error.
Only error when I sort position column & refresh table.
[quote]DataTables warning (table id = 'manage_table'): Requested unknown parameter '4' from the data source for row 0[/quote]
My code:
[code]
Name
Note
Status
Position
Id
oManageTable = $('#manage_table').dataTable({
"bProcessing": true,
"sAjaxSource": "<?php echo site_url($current_controller.'/entries'); ?>",
"bDeferRender": true,
"bJQueryUI": true,
"sPaginationType": "full_numbers",
"aaSorting": [[5,'desc']],
"bStateSave": true,
"aoColumns": [
{"sClass": "center no_sort", "bSortable": false, "bSearchable": false,},
null,
null,
{"sClass": "center", "bSearchable": false,},
{"sClass": "center", "sType": "numeric", "sSortDataType": "dom-text"},
{"sClass": "center", "sType": "numeric"},
{"sClass": "center no_sort", "bSortable": false, "bSearchable": false,}
]
});
[/code]
[code]
{
"aaData": [
[
"",
"Content 709",
"Note 709",
"0",
"",
"3715",
"\r
\r
<\/a>\r
\r
\r
\r
<\/a>"
],
[
"",
"Content 710",
"Note 710",
"0",
"",
"3716",
"\r
\r
<\/a>\r
\r
\r
\r
<\/a>"
],
[
"",
"Content 718",
"Note 718",
"0",
"",
"3724",
"\r
\r
<\/a>\r
\r
\r
\r
<\/a>"
]
]
}
[/code]
It won't have error if I remove dom sort.
Edit:
The first load (sort id column by default or any column) still has no error.
Only error when I sort position column & refresh table.
This discussion has been closed.
Replies
I used mRender for input.