Hello,
I sent this in earlier but had a typo, I’m running postgresql 9.2 on
CentOS_6. I’ve got 14.1 installed and most things seem to be functioning
except when opening mail I get the following error:
Invalid SQL: SELECT egw_ea_identities.ident_id AS
ident_id,ident_name,ident_realname,ident_org,ident_email,egw_ea_identities.acc_id
AS acc_id,egw_ea_credentials.cred_username AS
acc_imap_username,acc_imap_logintype,acc_domain FROM egw_ea_identities
JOIN egw_ea_accounts ON egw_ea_accounts.acc_id=egw_ea_identities.acc_id
LEFT JOIN egw_ea_credentials ON
egw_ea_accounts.acc_id=egw_ea_credentials.acc_id AND
egw_ea_credentials.account_id=5 AND cred_type&1 WHERE
egw_ea_identities.account_id IN (-2,-1,5,0) AND
egw_ea_identities.acc_id=1 ORDER BY
egw_ea_identities.account_id,ident_realname,ident_org,ident_email
ERROR: argument of AND must be type boolean, not type integer
LINE 1: …ls.acc_id AND egw_ea_credentials.account_id=5 AND cred_type&…
^ (-1)
(egw_exception_db_invalid_sql: 100)
I click OK, the app keeps spinning but no email displayed. Configuring
the email account completed successfully as far as I can tell.
Any help is appreciated!
Thanks!
myEMAILsignature Thomas Plancon
CAD/IT Manager
B K A Architects, Inc.
142 Crescent Street
Brockton, MA 02302
tel: 508 . 583 . 5603 ext 313
fax: 508 . 584 . 2914
www.bkaarchitects.com http://www.bkaarchs.com/
