Hi !
I’m trying to migrate eGroupware on ubuntu 16.04 with mysql 5.7.12 and i get this error :
Invalid SQL: SELECT egw_ea_accounts.,egw_ea_identities.,GROUP_CONCAT(all_valid.account_id) AS account_id,cred_username AS acc_imap_admin_username FROM egw_ea_accounts JOIN egw_ea_identities ON egw_ea_identities.ident_id=egw_ea_accounts.ident_id JOIN egw_ea_valid ON egw_ea_valid.acc_id=egw_ea_accounts.acc_id LEFT JOIN egw_ea_valid all_valid ON all_valid.acc_id=egw_ea_accounts.acc_id LEFT JOIN egw_ea_credentials ON egw_ea_credentials.acc_id=egw_ea_accounts.acc_id AND cred_type=8 WHERE egw_ea_valid.account_id IN (-2,-1,-6,5,0) GROUP BY egw_ea_accounts.acc_id,egw_ea_identities.ident_id,egw_ea_valid.account_id ORDER BY (ident_email=’’ OR ident_email=‘admin@some.where’) DESC,ident_email LIKE ‘%@’ DESC,egw_ea_valid.account_id ASC,ident_org ASC,ident_realname ASC,acc_name ASC
Expression #39 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘egroupware.egw_ea_credentials.cred_username’ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055)
After some researches, I found that the problem is caused by the ONLY_FULL_GROUP_BY option from sql_mode.
Indeed, since MySQL 5.7.5+ changed the way GROUP BY behaved.
So, as a temporary solution, I disabled this option but i’m not completly satisfed.
As I didn’t found another post on this, i wondering if the community had experienced this.
Regards,
