From: tarantir <rt...@ta...> - 2015-10-13 20:57:38
|
EGroupware version 14.3.20151012 Getting the following error on login. 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-tp4009494.html Sent from the egroupware-developers mailing list archive at Nabble.com. |