[eGroupWare-tracker] Bugs #2958: cannot add e-mail profile for user/group

[<tr...@eg...>]

Ticket modified by Klaus Leithoff at 2011/05/09 11:52
Tracking System: Bugs
Category: EmailAdmin
Version: Version 1.8.001
> Status: Pending
> Resolution: Fixed
> Completed: 90%
Priority: 5 - medium
Created By: Viktor Matys
Created on: 2011/05/07 13:35
Assigned to: Klaus Leithoff
Cc: v....@gr...
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.

----------------------------------------------------------------
> Comment by Klaus Leithoff at 2011/05/09 11:52:
this one should be fixed:
# 2011-05-02 Klaus Leithoff (leithoff)
# r34813: adapt values to yes/no while saving ea_imap_tsl_auth / imapTLSAuthentication emailadminprofiles 
http://svn.stylite.de/viewvc/egroupware/branches/1.8/emailadmin/inc/class.emailadmin_ui.inc.php?view=markup&pathrev=34813

If not with svn , follow the link and download and replace the file in question.

If the error persists please report back.

linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2958&no_popup=1