I keep getting this SQL error on multiple instances when I click add existing address to a student in the address/contacts screen. I am unsure what is happening, however, it happens on both servers we run. I've tried reinstalling the software too.
04/23/2024 12:04:43
Date
DB Execute Failed. 1055 Expression #4 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'trinitysis_production.students_join_people.custody' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Failure Notice
INSERT INTO students_join_people
(STUDENT_ID,PERSON_ID,ADDRESS_ID,CUSTODY,EMERGENCY,STUDENT_RELATION)
SELECT '99998',PERSON_ID,
ADDRESS_ID,CUSTODY,EMERGENCY,STUDENT_RELATION
FROM students_join_people
WHERE ADDRESS_ID='2'
GROUP BY PERSON_ID
SQL query