kejadian di SLiMS 9.61
Error :
mysqli_sql_exception
Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘mayshitohv2.s.serial_id’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in C:\laragon\www\pwna2025\admin\modules\bibliography\index.php on line 565
Traces

mysqli_sql_exception Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mayshitohv2.s.serial_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in C:\laragon\www\pwna2025\admin\modules\bibliography\index.php on line 565 Traces

Cara memperbaiki :

  1. Buka file index.php yang berada di folder admin/modules/bibliography
  2. Edit bagian “delete serial data”, beri atribut MAX pada code. Berikut kodennya:

Sebelum

$_sql_serial_kardex_q = sprintf('SELECT b.title, COUNT(kardex_id),s.serial_id FROM biblio AS b
          LEFT JOIN `serial` AS s ON b.biblio_id=s.biblio_id
          LEFT JOIN kardex AS k ON s.serial_id=k.serial_id
          WHERE b.biblio_id=%d GROUP BY title', $itemID);

Sesudah

 $_sql_serial_kardex_q = sprintf('SELECT b.title, COUNT(kardex_id), MAX(s.serial_id) AS serial_id 
                FROM biblio AS b
                LEFT JOIN `serial` AS s ON b.biblio_id=s.biblio_id
                LEFT JOIN kardex AS k ON s.serial_id=k.serial_id
                WHERE b.biblio_id=%d 
                GROUP BY b.title', $itemID);

Selesai

Penyebab : Kesalahan terjadi karena kueri SQL dalam kode tidak mematuhi mode SQL ONLY_FULL_GROUP_BY. Mode ini memberlakukan bahwa semua kolom dalam daftar SELECT harus digabungkan (misalnya, COUNT, MAX) atau disertakan dalam klausa GROUP BY untuk memastikan hasil kueri bersifat deterministik.