Database Error

A Database Error Occurred

Error Number: 1140

In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'eezyclin_master_live.clinic_tbl_holidays_list.holiday_type'; this is incompatible with sql_mode=only_full_group_by

SELECT holiday_type,count(*) AS cnt FROM `clinic_tbl_holidays_list` WHERE ( FIND_IN_SET('219',doctorId) or doctorId='all') AND (FIND_IN_SET('5',branchId) or branchId='all') AND clinicId='5' and (CASE WHEN holiday_type = 1 THEN DATE_FORMAT(from_date,'%Y-%m-%d') = '2024-03-29' WHEN holiday_type = 2 THEN '2024-03-29' between DATE_FORMAT(from_date,'%Y-%m-%d') and DATE_FORMAT(to_date,'%Y-%m-%d') WHEN holiday_type = 3 THEN '2024-03-29 09:15' between DATE_FORMAT(from_date,'%Y-%m-%d %H:%i') and DATE_FORMAT(to_date,'%Y-%m-%d %H:%i') end)

Filename: models/Clinicmodel.php

Line Number: 272