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
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)
Seems you are not up to date, that bug was fixed some time ago.
Please update to recent version 14.1.20140923
Ralf
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
Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer
Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports
Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper
Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk