Cannot download email after clearing drafts folder

English Language - Forum SuiteCRM Feedback
1

This morning I deleted several Draft emails that had been created automatically some time back when generating, and abandoning, invoices. Since doing that, SuiteCRM cannot collect any new incoming email. I have checked the sugarcrm.log and discovered the following:

Thu Aug 11 11:01:49 2016 [13125][44bc535b-103d-dc6e-00c6-54a3d594bf4d][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.
Thu Aug 11 11:10:15 2016 [19734][44bc535b-103d-dc6e-00c6-54a3d594bf4d][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 ('e8398365-d505-b74a-d41a-54a67d686ca2', 'Trash', '2015-07-16-No-One-Off-Fixes', '\"James Kimbley (Google Docs)\" <d+MTAxMjE3MjQyOTExMDAwMTA4MjQ0-MTEzMzgwODc0NjcwOTcxMTQ3ODY2@docs.google.com>', 'ben.lloyd1@gmail.com', '2015-07-29 07:28:24', '<-kZwKxsdZWSMDATg24gyCw@notifications.google.com>', 46731, '1891', '34', '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 ('e8398365-d505-b74a-d41a-54a67d686ca2', 'Trash', '2015-07-16-No-One-Off-Fixes', '\"James Kimbley (Google Docs)\" <d+MTAxMjE3MjQyOTExMDAwMTA4MjQ0-MTEzMzgwODc0NjcwOTcxMTQ3ODY2@docs.google.com>', 'ben.lloyd1@gmail.com', '2015-07-29 07:28:24', '<-kZwKxsdZWSMDATg24gyCw@notifications.google.com>', 46731, '1891', '34', '0', '0', '0', '0', '1', '0'): MySQL error 1406: Data too long for column 'fromaddr' at row 1
Thu Aug 11 11:10:15 2016 [19734][44bc535b-103d-dc6e-00c6-54a3d594bf4d][FATAL] Exception in Controller: Database failure. Please refer to suitecrm.log for details.

There are dozens of entries like the above.

Two things to note:

  1. The database is running, the rest of SuiteCRM seems to be running normally, and I can browse the emails table via phpMyAdmin
  2. I cannot find the suitecrm.log file mentioned in the error message.

Please help - email is critical to my operations here.

2

I have just restored the entire virtual machine from a backup this morning, and the problem persists.

Any ideas please?

3

OK, for some reason SuiteCRM has decided to take exception with a handful of specific emails (typically those sent with links to Google Docs). I have deleted the problematic messages from my Inbox and everything seems to be working again.

What I don’t understand is how many of these emails have been in my Inbox for 2-3 months without a problem before. I haven’t applied any new code changes since the v7.7 upgrade, so I have no idea what has changed.

Is this a bug?