DataTable cannot show more than 15 columns or search filter not working if more than 15 columns show.

Question

Hi all,

I am currently using DataTables to show some columns from a View stored in a MySQL server. Right now, I want to show 16 columns. However, for some reason, the DataTables plugin will always show that "no records were found" after adding a 16th column, and will work normally if 15 or less columns are shown.

I know this is not a syntax problem, since I have tried "removing" different columns from the Datatable, and every column can be shown as long as they all add up to 15.

Answer 1

That is, column 16 is not shown if columns 1-15 are added; however, I can remove column, say, 9, and then show 1-8, 10-16 (they add up to 15), so it's not a syntax problem on a column name or anything.

Any ideas on how I can debug this? It's driving me nuts.

Many thanks