Re: [eGroupWare-developers] Email Admin SQL Error

[tarantir <rt...@ta...>]

Same Error. I highlighted the problem in the SQL Code. DB does not know what
to do with the asterisk in the select and group by.

Invalid SQL: SELECT *egw_ea_accounts.*,egw_ea_identities.** 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  WHERE egw_ea_valid.account_id IN
(-2,-70,-84,-73,-68,-66,-67,-1,-34,-51,-52,-69,-37,-50,-48,-41,-53,14,0)
GROUP BY
egw_ea_accounts.acc_id,egw_ea_identities.ident_id,egw_ea_valid.account_id,*egw_ea_accounts.*,egw_ea_identities.*
* ORDER BY (ident_email='' OR ident_email='ad...@ex...')
DESC,ident_email LIKE '%@a' DESC,egw_ea_valid.account_id ASC,ident_org
ASC,ident_realname ASC,acc_name ASC
You have an error in your SQL syntax; check the manual that corresponds to
your MariaDB server version for the right syntax to use near
'*,egw_ea_identities.*  ORDER BY (ident_email='' OR ident_email='admin' at
line 1 (1064)



--
View this message in context: http://egroupware.219119.n3.nabble.com/Email-Admin-SQL-Error-tp4009494p4009500.html
Sent from the egroupware-developers mailing list archive at Nabble.com.