Datatables - upgrade to 1.10.2 from 1.9.4 - unable to sort or search on table

Datatables - upgrade to 1.10.2 from 1.9.4 - unable to sort or search on table

bugbug Posts: 0Questions: 1Answers: 0

Hello, I have updated to datatables 1.10.2 from 1.9.4 in order to get new functionality. At the moment, I have kept everything to the Hungarian Style of reference and expect to change to the new camelcode? Anyways, I don't notice any major problems, except that I can no longer sort by clicking on the row header or use the search which worked fine before.

I have a live site available for viewing and testing at: http://bug.ddns.net:81/4threcess/sample-dynamics
login is "test" pword is "abc123"
click on the account tab to view a datatable that should be sortable. We have datatables throughout this site, so looking at admin and a few other places, none of the sorts work.

I am very new to datatables and most of this code was written before I got to this job. I am not sure where to start in resolving this issue and any help would be appreciated.

This is the code that draws the datatable:
var clienttable = $("#clienttable").dataTable({ aoColumns: [ {"sWidth":"40px", "bSortable":true}, //idclient {"sWidth": "120px", "bSortable":true}, //clientname {"sWidth": "85px", "bSortable":true}, //clientdottype {"sWidth": "120px", "bSortable":true}, //parent company {"sWidth": "100px", "bSortable":true}, //contact {"sWidth": "100px", "bSortable":false} // contact phone ], oLanguage: { sEmptyTable: "&nbsp" }, sDom: 'T<"clear">lfrtip', bProcessing: true, bAutoWidth: false, bServerSide: true, bJQueryUI: true, sScrollY: "465px", sScrollX: "100%", sServerMethod: 'POST', "fnServerData": function(sSource, aoData, fnCallback) { $.ajax( { "dataType": 'json', "type": "POST", "url": "getClients", "data": aoData, "success": fnCallback } ); }, "fnRowCallback": function( nRow, aData, iDisplayIndex ) { $('td:eq(5)', nRow).html( '<div style="text-align:right;padding:5px 40px 5px 5px;"><a class="cusmedit" data-cli-id="' + aData[0] + '" href="#"><img src="../../images/16x16_gear.png" alt="Edit" title="Edit Client" /></a>&nbsp&nbsp&nbsp<a class="cusmdeactivate" data-cli-id="' + aData[0] + '" href="#"><img src="../../images/16x16_delete.png" alt="Deactivate" title="Deactivate Client" /></a></div>' ); return nRow; }, "fnDrawCallback": function (oSettings) { $('.cusmedit').unbind(); $('.cusmedit').bind('click', function () { $.ajax({ url: 'getClientDetails', dataType: 'json', type: 'POST', data: { idclient:$(this).data('cli-id') }, success: function(j) { loadClientDetails(j); } }); }); $('.climdeactivate').unbind(); $('.climdeactivate').bind('click', function () { alert('deactivate clicked '+ $(this).data('cli-id')); }); } });

And here is where we get the data from "getClients":
``` $this->load->helper("Datatables");
$idaccount = $this->session->userdata('idaccount');
$table = 'client';
$this->datatables->select('idclient, clientname, dottype, idparent, contact, contactphone');
$this->datatables->where('idaccount', $idaccount);
$this->datatables->from('client');
$this->datatables->add_column('actions', 'html');
$this->datatables->edit_column('dottype', '$1', 'getDOTType(dottype)');
$this->datatables->edit_column('idparent', '$1', 'getClientParent('.$idaccount.', idparent)');

        echo $this->datatables->generate();```

Datatables debugger: idizek

This discussion has been closed.