AnsweredAssumed Answered

MySQL error 1406: Data too long for column 'fromaddr' when trying to delete emails

Question asked by Old El Paso on Mar 7, 2014
I have successfully installed SugarCRM 6.5 on a Windows server.
Once installed, I have configured my inbound email account so I can see all my personal emails thorugh IMAP.
So everything works fine, except when I want to delete multiple emails in my personal inboud email account folder.
When I click the delete button, the dialog box "Deleting message..." appears but never disappears.
When I close it, only one email has been deleted.
When I look to sugarcrm log file, I found "data too long" mysql errors like these:

03/07/14 14:20:37 [5720][1][FATAL] INSERT INTO email_cache (ie_id,mbox,subject,fromaddr,toaddr,senddate,message_id,mailsize,imap_uid,msgno,recent,flagged,answered,deleted,seen,draft) VALUES ('8c17f405-4736-33a7-9f41-5318fd6a1b00', 'INBOX.INBOX.Trash', '=?iso-8859-1?B?anVzcXUnYSBtb2lucyAzNSBw?= =?iso-8859-1?B?b3VyY2VudCBzdXIgdm90cmUgbm91dmVsbGUgdm9pdHVyZQ==?=', '=?iso-8859-1?B?QXJhbWlzQXV0byBwYXIgYm9u?= =?iso-8859-1?B?bmVzLWFmZmFpcmVzLWF1dG8=?= <service-clients@jou31.com>', '=?iso-8859-1?B?ZXJpYy5tYWxhbGVsQGx5bnhv?= =?iso-8859-1?B?bmxpbmUuY29t?= <contact@mywebsite.com>', '2013-02-02 16:40:16', '<20130202-17401620-f059f276-0@TRT-93>', 21855, '3', '3', '0', '0', '0', '0', '1', '0') Query Failed: INSERT INTO email_cache (ie_id,mbox,subject,fromaddr,toaddr,senddate,message_id,mailsize,imap_uid,msgno,recent,flagged,answered,deleted,seen,draft) VALUES ('8c17f405-4736-33a7-9f41-5318fd6a1b00', 'INBOX.INBOX.Trash', '=?iso-8859-1?B?anVzcXUnYSBtb2lucyAzNSBw?= =?iso-8859-1?B?b3VyY2VudCBzdXIgdm90cmUgbm91dmVsbGUgdm9pdHVyZQ==?=', '=?iso-8859-1?B?QXJhbWlzQXV0byBwYXIgYm9u?= =?iso-8859-1?B?bmVzLWFmZmFpcmVzLWF1dG8=?= <service-clients@jou31.com>', '=?iso-8859-1?B?ZXJpYy5tYWxhbGVsQGx5bnhv?= =?iso-8859-1?B?bmxpbmUuY29t?= <contact@mywebsite.com>', '2013-02-02 16:40:16', '<20130202-17401620-f059f276-0@TRT-93>', 21855, '3', '3', '0', '0', '0', '0', '1', '0'): MySQL error 1406: Data too long for column 'fromaddr' at row 1
03/07/14 14:35:28 [5660][1][FATAL] INSERT INTO email_cache (ie_id,mbox,subject,fromaddr,toaddr,senddate,message_id,mailsize,imap_uid,msgno,recent,flagged,answered,deleted,seen,draft) VALUES ('8c17f405-4736-33a7-9f41-5318fd6a1b00', 'INBOX.INBOX.Trash', '=?iso-8859-1?B?anVzcXUnYSBtb2lucyAzNSBw?= =?iso-8859-1?B?b3VyY2VudCBzdXIgdm90cmUgbm91dmVsbGUgdm9pdHVyZQ==?=', '=?iso-8859-1?B?QXJhbWlzQXV0byBwYXIgYm9u?= =?iso-8859-1?B?bmVzLWFmZmFpcmVzLWF1dG8=?= <service-clients@jou31.com>', '=?iso-8859-1?B?ZXJpYy5tYWxhbGVsQGx5bnhv?= =?iso-8859-1?B?bmxpbmUuY29t?= <contact@mywebsite.com>', '2013-02-02 16:40:16', '<20130202-17401620-f059f276-0@TRT-93>', 21855, '3', '3', '0', '0', '0', '0', '1', '0') Query Failed: INSERT INTO email_cache (ie_id,mbox,subject,fromaddr,toaddr,senddate,message_id,mailsize,imap_uid,msgno,recent,flagged,answered,deleted,seen,draft) VALUES ('8c17f405-4736-33a7-9f41-5318fd6a1b00', 'INBOX.INBOX.Trash', '=?iso-8859-1?B?anVzcXUnYSBtb2lucyAzNSBw?= =?iso-8859-1?B?b3VyY2VudCBzdXIgdm90cmUgbm91dmVsbGUgdm9pdHVyZQ==?=', '=?iso-8859-1?B?QXJhbWlzQXV0byBwYXIgYm9u?= =?iso-8859-1?B?bmVzLWFmZmFpcmVzLWF1dG8=?= <service-clients@jou31.com>', '=?iso-8859-1?B?ZXJpYy5tYWxhbGVsQGx5bnhv?= =?iso-8859-1?B?bmxpbmUuY29t?= <contact@mywebsite.com>', '2013-02-02 16:40:16', '<20130202-17401620-f059f276-0@TRT-93>', 21855, '3', '3', '0', '0', '0', '0', '1', '0'): MySQL error 1406: Data too long for column 'fromaddr' at row 1

Outcomes