Email Admin SQL Error

[tarantir]

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=‘admin@example.com’) 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)

[Ralf_Becker_Stylite]

Hi,

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=‘admin@example.com’)
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)
That’s already fixed, but unfortunately after the package:

https://svn.stylite.de/egroupware/branches/14.2/phpgwapi/inc/class.egw_db.inc.php

Ralf

–
Ralf Becker
Director Software Development

Stylite AG

Isaac-Fulda-Allee 9 | Tel. +49 6131 32702-0
D-55124 Mainz | Fax. +49 6131 32702-70

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 46224 Mainz Germany

[tarantir]

What revision? I believe I have the latest.

class.egw_db.inc.php 53923 2015-10-12 18:35:11Z

[Ralf_Becker_Stylite]

Hi Tarantier,

What revision? I believe I have the latest.

class.egw_db.inc.php 53923 2015-10-12 18:35:11Z
r53923 is the latest, but it was not in the package.

You still have that error, or maybe an other one?

Ralf

–
Ralf Becker
Director Software Development

Stylite AG

Isaac-Fulda-Allee 9 | Tel. +49 6131 32702-0
D-55124 Mainz | Fax. +49 6131 32702-70

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 46224 Mainz Germany

[tarantir]

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=‘admin@example.com’) 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)

[Ralf_Becker_Stylite]

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.
Sure, and that’s what the updated egw_db class, I send you the link, fixes.

Ralf

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=‘admin@example.com’)
  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)

–
Ralf Becker
Director Software Development

Stylite AG

Isaac-Fulda-Allee 9 | Tel. +49 6131 32702-0
D-55124 Mainz | Fax. +49 6131 32702-70

Email: rb@stylite.de

www.stylite.de | www.egroupware.org

Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer

VAT DE214280951 | Registered HRB 46224 Mainz Germany

[tarantir]

I discovered this error is only reproducible when using the Site Manager Login module. When logging directly into eGroupware it doe not occur.