Keterangan Error

ERROR
MySQL Server said : Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘.index.biblio_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

Solusi :

ubah di filenya yang terdapat di ……admin/modules/bibliography/printed_card.php

cek dibagian : datagrid

yang sebelumnya seperti ini:

$datagrid->setSQLColumn(‘index.biblio_id, index.title as ‘.__(‘Title’).’, index.author as ‘.__(‘Author’));

Ubah menjadi seperti ini :

$datagrid->setSQLColumn(‘max(index.biblio_id), max(index.title) as ‘.(‘Title’).’, max(index.author) as ‘.(‘Author’));