A Database Error Occurred

Error Number: 1055

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test_.psi.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by

SELECT `pa`.`ship_id`, `psi`.`id`, `psi`.`shipping_company_name`, `ps`.`ship_name`, `ps`.`voyage` FROM `gil_port_arrival` as `pa` JOIN `gil_port_shipping_company` as `psi` ON `psi`.`id` = `pa`.`company_id` JOIN `gil_port_ship` as `ps` ON `ps`.`id` = `pa`.`ship_id` JOIN `gil_port` as `p` ON `p`.`id` = `pa`.`port_id` WHERE pa.port_id IN('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15', '16', '17') AND pa.ship_id IN('1', '2') AND `pa`.`date` >= '1970-01-01' AND `pa`.`date` <= '2025-03-19' AND `pa`.`status` = '1' GROUP BY `ps`.`id`

Filename: models/Model_home.php

Line Number: 297