search

cnizzardini / cakephp-datatable

CakePHP Component for interoperability between CakePHP 2.x and jQuery DataTables plugin.
62 stars 49 forks source link

Searching on queries with COUNT produce error #14

Closed cnizzardini closed 10 years ago

cnizzardini commented 10 years ago

Error: SQLSTATE[HY000]: General error: 1111 Invalid use of group function

cnizzardini commented 10 years ago

Workaround: Set the column to bSearchable: false in dataTables.

cnizzardini commented 10 years ago

Duplicate see https://github.com/cnizzdotcom/cakephp-datatable/issues/3