DataTable stuck on processing even if AJAX response is fine. It only shows the loading icon.

drev20

Link to test case:
Debugger code (debug.datatables.net): ulolit
Error messages shown:


Description of problem:
I'm having a problem. DataTable stuck on loading/processing but it has ajax response. No errors but my DT is not loading any data. I'll provide my scripts here. Thank you.

Javascript:

var period_management_DT = $('#tablePeriod').DataTable({
        'serverSide': true,
        'info' : true,
        'processing' : true,
        ajax : {
            url: "<?php echo base_url('cvs/Period_management/generateAllPeriods'); ?>",
            type: 'POST',
            data: function (d) {
                return {'_pmData' : d}
            },
            success : function (data) {
                console.log(data);  
                
            },
            error: function (err) {
                console.log(err);
                
            }
         },
        'columns' : [
            {data: 'name'},
            {data: 'code'},
            {data: 'months'},
            {data: 'cvs_encoding_status_id'}
        ],
        columnDefs: [
                {
                "defaultContent": "-",
                "targets": "_all"
                }
        ]
    });

Server-side:

public function generateAllPeriods () {
        $postData = $this->input->post('_pmData');
        $draw = intval($postData['draw']);
        $start = intval($postData['start']);
        $length = intval($postData['length']);
        $pm_model = new PeriodModel();
        $data = $pm_model->get_periods_with_months_2($start, $length);

        $resData = array(); 

        foreach ($data[0] as $d) {
            $resData[] = array (
                'name' => $d['name'], 
                'code' => $d['code'],
                'months' => $d['months'],
                'cvs_encoding_status_id' => $d['cvs_encoding_status_id']
            );
         }

        $output = array(
            'draw' => $draw,
            'recordsTotal' => $data[1],
            'recordsFiltered' => $data[1],
            'data' => $resData
        );
       // echo json_encode($output);
       echo json_encode($output);
    }

Edited by Allan - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

kthorngren

Possibly you need to remove the success function from the ajax option. The ajax docs state this:

success - Must not be overridden as it is used internally in DataTables. To manipulate / transform the data returned by the server use ajax.dataSrc (above), or use ajax as a function (below).

Let us know if removing the success function resolves the issue.

Kevin