medic error

[kielerboy]

hello i have this error
�[31m[ERROR] [MySQL] [jsfour-computer] An error happens on MySQL for query "SELECT DISTINCT CONCAT(firstname, " ", lastname) as name, dob, COUNT(dob) as countFROMjsfour_medicalrecordsWHEREfirstname= 'test' ORlastname= 'test' ORdob= 'test' GROUP BYfirstname`": ER_WRONG_FIELD_WITH_GROUP: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'test.jsfour_medicalrecords.lastname' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by�[0m

`

[jonassvensson4]

I'm afraid that's a you issue. By the looks of it, you're using a different SQL mode.

https://stackoverflow.com/questions/41887460/select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-inc

If that doesn't work you'll have to google that error to find another solution.