New ticket submitted by Viktor Matys at 2011/05/07 13:35
Tracking System: Bugs
Category: EmailAdmin
Version: Version 1.8.001
Status: Open
Completed: 0%
Priority: 5 - medium
Created By: Viktor Matys
Created on: 2011/05/07 13:35
Assigned to: Klaus Leithoff
Summary: #2958 - cannot add e-mail profile for user/group
I get error message:
=== error message begin ===
Database error
Invalid SQL: INSERT INTO egw_emailadmin (ea_smtp_server,ea_smtp_port,ea_smtp_auth,ea_smtp_auth_username,ea_smtp_auth_password,ea_smtp_type,ea_description,ea_default_domain,ea_organisation_name,ea_user_defined_accounts,ea_user_defined_identities,ea_active,ea_user_defined_signatures,ea_default_signature,ea_appname,ea_group,ea_user,ea_stationery_active_templates,ea_order,ea_imap_server,ea_imap_port,ea_imap_type,ea_imap_login_type,ea_imap_tsl_encryption,ea_imap_tsl_auth,ea_imapoldcclient,ea_imap_auth_username,ea_imap_auth_password) VALUES (’’,25,NULL,’’,’’,1,’’,’’,’’,‘no’,‘no’,1,‘no’,NULL,’’,‘0’,‘0’,NULL,2,’’,143,2,‘vmailmgr’,NULL,true,NULL,NULL,NULL):
ERROR: value too long for type character varying(3)
=== error message end ===
The problem is in trying to insert value ‘true’ into field ‘ea_imap_tsl_auth’ which is varchar(3) type.
I guess it should be value ‘yes’, not ‘true’.
I use postgresql dabase version 8.4 on Debian Squeeze.
linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2958&no_popup=1