IMAP E-mail Appears Frozen or Stuck on Check or Delete

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

There appears to be a fairly nasty bug with e-mail that should be fairly easy to fix. Any message in one of your mailboxes that has a from address (possibly others) that is too long will generate a MySQL error. SuiteCRM neither recovers from, or reports the nature of the error.

MySQL error 1406: Data too long for column 'fromaddr' at row 1

Although it would be preferable for SuiteCRM to handle such errors gracefully, an easy patch may simply be increasing the field size in MySQL, or cropping the from text. One I know how to do, one I don’t.

Do you think I should risk changing the database field size?

#2

How long was the email addr?

#3

Sun May 24 11:39:35 2015 [34752][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 (‘7e3a349a-7349-a1ed-fd1d-54ee0699fe5e’, ‘INBOX.Trash’, ‘Registration Successful’, ‘“a_domain_name.ca - Official Site - Canada’s one-stop-shop for 12345678p” <noreply@a_domain_name.ca>’, ‘user@suitecrm.ca’, ‘2015-05-21 00:51:49’, ‘<b910fcc7666bc1e0a1ae6ee989e8b33e@a_domain_name.ca>’, 2938, ‘341’, ‘287’, ‘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 (‘7e3a349a-7349-a1ed-fd1d-54ee0699fe5e’, ‘INBOX.Trash’, ‘Registration Successful’, ‘“a_domain_name.ca - Official Site - Canada’s one-stop-shop for 123456789” <a_domain_name.ca>’, ‘user@suitecrm.ca’, ‘2015-05-21 00:51:49’, ‘<b910fcc7666bc1e0a1ae6ee989e8b33e@a_domain_name.ca>’, 2938, ‘341’, ‘287’, ‘0’, ‘0’, ‘0’, ‘0’, ‘1’, ‘0’): MySQL error 1406: Data too long for column ‘fromaddr’ at row 1

This is the exact error with the addresses removed (same length).