When I’m using
php egroupware/admin/admin-cli.php --delete-user
php egroupware/admin/admin-cli.php --edit-user
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 (-1000,-1877,2293,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=‘adminegw@sgen.cfdt.fr’)
DESC,ident_email LIKE ‘%@d’ 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)
Modified this it work but it’s not a good solution
— a/emailadmin/inc/class.emailadmin_account.inc.php
+++ b/emailadmin/inc/class.emailadmin_account.inc.php
@@ -1327,7 +1327,7 @@ class emailadmin_account implements ArrayAccess
if (!$only_current_user ||
!isset(self::$search_cache[$cache_key]))
{
$cols = array(self::TABLE.’.’,
self::IDENTITIES_TABLE.’.’);
‘.self::TABLE.’.acc_id,’.self::IDENTITIES_TABLE.’.ident_id,’.self::VALID_TABLE.’.account_id’;
+// $group_by = ‘GROUP BY
’.self::TABLE.’.acc_id,’.self::IDENTITIES_TABLE.’.ident_id,’.self::VALID_TABLE.’.account_id’;
$join = self::IDENTITY_JOIN.’ '.self::VALID_JOIN;
if (($valid_account_id_sql =
self::$db->group_concat(‘all_valid.account_id’)))
{
–
probeSys - spécialiste GNU/Linux
site web : http://www.probesys.com
eGroupWare-developers mailing list
eGroupWare-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-developers
