I’ve got 14.1 installed on a CentOS_6 server and running with a
postgresql 6.2 DB, finally connecting to it! I’m able to set up my email
account OK, but when I open the email app I get an sql 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)
The mail app sits there with a little spinning arrow.
Any suggestions appreciated.
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/
