| Database Error | |
|---|---|
| Message: | MySQL Error has occured |
| MySQL Error: | Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'aimstorm_icjrdb.w.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
| Query: | SELECT w.*, st.name as city_name, GROUP_CONCAT(m.id) as id, GROUP_CONCAT(m.title) as title, GROUP_CONCAT(m.query_string) as query_string, GROUP_CONCAT(m.is_appear) as is_appear, m.status, m.email_id, m.city_id, m.profile_pic, GROUP_CONCAT(m.full_name) as `doctor_name`, GROUP_CONCAT(m.work_location_preference) as work_location_preference, CONCAT(w.work_latitude,' ', w.work_longitude) as latlang, GROUP_CONCAT(w.practice_work_name) as practice_work_name FROM members as m LEFT JOIN work_location w ON m.id=w.user_id LEFT JOIN states st ON st.id=w.work_city_id WHERE m.status='1' GROUP BY latlang |
| Trace: | /home/aimstormsolution/public_html/icjr/find-member/index.php at line 24 /home/aimstormsolution/public_html/icjr/find-member/view/find-member.php at line 126 /home/aimstormsolution/public_html/icjr/classes/search.php at line 116 /home/aimstormsolution/public_html/icjr/classes/database.php at line 539 /home/aimstormsolution/public_html/icjr/classes/database.php at line 520 |