Data too long for column

💬 General Discussion
1

Since upgrading to v7.7 I have run into a couple of problems that manifest with the SQL error ‘Data too long’ in the sugarcrm.log file. I documented some of the problems previously here.

I have noticed that these issues are still occurring, and have a load of instances like this:

Unexpected failure, please check PHP logs andWarning [2]: imap_open(): Couldn\'t open stream {imap.gmail.com:993/service=imap/ssl}INBOX in /var/www/crm2015/modules/InboundEmail/InboundEmail.php on line 4815\nUnexpected failure, please check PHP logs and suitecrm.log\n',`target`='function::pollMonitoredInboxesForBouncedCampaignEmails',`data`=NULL,`requeue`=0,`retry_count`=NULL,`failure_count`=128,`job_delay`=0,`client`='CRON593daed96c22447fa072b05bd765a1d0:23083',`percent_complete`=NULL
					 WHERE  job_queue.id = 'c4e8b620-602b-977e-d7af-578e7bba7dd0' AND deleted=0: MySQL error 1406: Data too long for column 'message' at row 1

As far as I can tell, the problem seems to be caused by email updates sent by Google Apps - can someone advise how to fix this? Do I need to increase the size of the ‘message’ column in the database? Or is this a bug of some kind that needs to be raised on GitHub?

Thanks in advance for your assistance.

Ben

2

why don’t you try to upgrade to 7.7.4? I’ve seen many MySQL <-> MSSQL updates, maybe this is fixed (can’t find any specific in the release notes thought)

best regards

3

I’m currently using 7.7.4 mikebeck. And I’m not using MSSQL either (nor have I ever done so).

4

I’ve just tried changing my IMAP server address for the affected account - hopefully this will have some effect.