Hallo Hansa,
auf die Schnelle kann ich Dir da keine Lösung bieten, außer den Default
zu Ändern.
Für PostgreSQL listen wir zwar alle Spalten, allerdings passiert das im
Moment an diversen Stellen im Code und auch teilweise automatisch in
etemplate/inc/class.so_sql.inc.php in der Methode fix_group_by_columns().
Die Methode verwendet dann allerdings eine Syntax die MySQL nicht
versteht …
Sprich alles nicht so einfach, werde ich mir bei Gelegenheit ansehen müssen.
Ralf
Hier ist noch ein kleines Problem:
Im neuen Mysql Server (5.7.11-0ubuntu6) ist der sql-mode
’ONLY_FULL_GROUP_BY’ enabled by default.
SELECT @@sql_mode;
±------------------------------------------------------------------------------------------------------------------------------------------+
@@sql_mode
±------------------------------------------------------------------------------------------------------------------------------------------+
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
±------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0,00 sec)
Das mag die EGW nicht:
Database error (egw_exception_db_invalid_sql): 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,-20,-1,-40,-34,-45,-46,-24,6,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=‘egal@somewhere.de’)
DESC,ident_email LIKE ‘%@r’ DESC,egw_ea_valid.account_id ASC,ident_org
ASC,ident_realname ASC,acc_name ASC\nExpression #40 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), referer:
https://server/egroupware/index.php?cd=yes
Schaltet man den aus, ist die Fehlermeldung weg.
Gruß
Hansa
–
View this message in context: http://egroupware.219119.n3.nabble.com/egroupware-epl-auf-Ubuntu-16-04-tp4012498p4012499.html
Sent from the egroupware-german mailing list archive at Nabble.com.
Find and fix application performance issues faster with Applications Manager
Applications Manager provides deep performance insights into multiple tiers of
your business applications. It resolves application problems quickly and
reduces your MTTR. Get your free trial!
https://ad.doubleclick.net/ddm/clk/302982198;130105516;z
egroupware-german mailing list
egroupware-german@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-german
–
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
