jQuery DataTables iTotalDisplayRecords is 0 when not using any filtering

SteveSmith

I'm following the DataTables + Oracle example at https://datatables.net/development/server-side/php_oracle.

My results look like:

{"sEcho":0,"iTotalRecords":"272364","iTotalDisplayRecords":0,"aaData":[]}

Why is my iTotalDisplayRecords 0 when I'm not using any filtering?

Thanks

Steve

SteveSmith

I've enabled PHP error reporting and I'm shown:

Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number in /var/www/portal/server_processing.php on line 223

Warning: oci_bind_by_name(): ORA-01036: illegal variable name/number in /var/www/portal/server_processing.php on line 224

Warning: oci_execute(): ORA-30485: missing ORDER BY expression in the window specification in /var/www/portal/server_processing.php on line 250

Warning: oci_fetch_array(): ORA-24374: define not done before fetch or execute and fetch in /var/www/portal/server_processing.php on line 252

Warning: oci_execute(): ORA-30485: missing ORDER BY expression in the window specification in /var/www/portal/server_processing.php on line 271

Warning: oci_fetch_array(): ORA-24374: define not done before fetch or execute and fetch in /var/www/portal/server_processing.php on line 274
{"sEcho":0,"iTotalRecords":"272440","iTotalDisplayRecords":0,"aaData":[]}

This is using the Oracle example at https://datatables.net/development/server-side/php_oracle. Why are there so many errors in it?

SteveSmith

Someone to help, no ?