A Database Error Occurred

Error Number: 1055

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

SELECT * FROM xel_service_price WHERE service_id='1' AND no_of_vacancy = '1' GROUP BY no_of_days order by CAST(SUBSTRING_INDEX(no_of_days, '-', -1) AS UNSIGNED)

Filename: /var/www/jobaxle.com/modules/services/models/admin_services.php

Line Number: 231