A Database Error Occurred

Error Number: 3065

Expression #1 of ORDER BY clause is not in SELECT list, references column 'icsemaths_db.c.orders' which is not in SELECT list; this is incompatible with DISTINCT

SELECT DISTINCT(c.id) as id, `c`.`name`, `c`.`color_code`, `c`.`slug`, `c`.`test_type` FROM `chapter_wise` as `c` WHERE `c`.`delete_flag` = 0 AND `c`.`status` = 1 AND `c`.`course_id` = '2' AND `c`.`unit_id` = '18' AND `c`.`chapter_id` = '55' ORDER BY `c`.`orders` ASC

Filename: controllers/Test_series.php

Line Number: 191