One of our user report an error after he changes his password (the
password changed successfully though):
Database error
Invalid SQL: SELECT egw_ea_accounts.,egw_ea_identities.,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_credentials ON egw_ea_credentials.acc_id=egw_ea_accounts.acc_id
AND cred_type=8 WHERE egw_ea_valid.account_id IN (-1,-10,24,0) GROUP BY
egw_ea_accounts.acc_id,egw_ea_identities.ident_id,egw_ea_valid.account_id,egw_ea_accounts.,egw_ea_identities.,acc_imap_admin_username
ORDER BY (ident_email=’’ OR ident_email=‘user@mydomain.com’)
DESC,ident_email LIKE ‘%@o’ 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.,acc_imap_admin_username ORDER BY
(ident_email=’‘
OR ident’ at line 1 (1064)
In the apache log I see this as well:
[Mon Jan 18 14:18:02.508166 2016] [:error] [pid 14854] [client 192.168.3.71:59554] Database error (egw_exception_db_invalid_sql): Invalid SQL: SELECT egw_ea_accounts.,egw_ea_identities.,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_credentials ON egw_ea_credentials.acc_id=egw_ea_accounts.acc_id AND cred_type=8 WHERE egw_ea_valid.account_id IN (-1,-10,24,0) GROUP BY egw_ea_accounts.acc_id,egw_ea_identities.ident_id,egw_ea_valid.account_id,egw_ea_accounts.,egw_ea_identities.,acc_imap_admin_username ORDER BY (ident_email=’’ OR ident_email=‘user@mydomain.com’) DESC,ident_email LIKE ‘%@o’ DESC,egw_ea_valid.account_id ASC,ident_org ASC,ident_realname ASC,acc_name ASC\nYou 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.,acc_imap_admin_username ORDER BY (ident_email=’’ OR ident’ at line 1 (1064), referer: http://egw2016.mydomain.com/egroupware/index.php?cd=yes
I can’t repeat this on my browser (chrome on Ubuntu). But on the user’s
PC he can repeat this error in his browser (Opera 9.80 on Ubuntu). All
he does is login then change password then wait few seconds. Then the
error window pop up.
I did some research and it seems MariaDB does not like “GROUP BY” with
wildcard.
I don’t know how the query build up in php, but some how when the query
reached MariaDB then it fails. (I enabled query log then I see this same
query reached on MariaDB)
Is this a bug? or not???
Please help.
Gao
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
eGroupWare-users mailing list
eGroupWare-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-users
