An exception occurred while executing 'SELECT * FROM ( SELECT tl_lead_data.field_id AS id, IFNULL(tl_form_field.name, tl_lead_data.name) AS name, IF(tl_form_field.label IS NULL OR tl_form_field.label='', tl_lead_data.name, tl_form_field.label) AS label, tl_form_field.type, tl_form_field.options, tl_lead_data.field_id, tl_lead_data.master_id, tl_lead_data.sorting FROM tl_lead_data LEFT JOIN tl_form_field ON tl_form_field.id=tl_lead_data.field_id LEFT JOIN tl_lead ON tl_lead_data.pid=tl_lead.id WHERE tl_lead.master_id=7 AND tl_lead_data.field_id IN (0,65,64,66,67,69,70,68,71) ORDER BY tl_lead.master_id!=tl_lead.form_id ) result_set GROUP BY field_id ORDER BY FIND_IN_SET(`field_id`, '0,65,64,66,67,69,70,68,71')': SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'result_set.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Lesezeichen