Data too long for column 'from_name' at row 1

[cwoodward]

My users regularly get the following error when Checking Mail. I have included a snippet of the error message below.



, from_name='-�2�轩ݕ�2r*�uا�Ʈ', to_addrs='xxx@xxxxxxx.com', cc_addrs=null, bcc_addrs=null, type='inbound', status='unread', message_id='954d61a7-c5e7-df7c-8d53-45c651ff379c', reply_to_name='-�2�轩ݕ�2r*�uا�Ʈ', intent='pick', mailbox_id='954d61a7-c5e7-df7c-8d53-45c651ff379c', raw_source=null, deleted='0'::MySQL error 1406: Data too long for column 'from_name' at row 1


I have increased the width of from_name in our DB to VARCHAR(255) but still see the error. Anybody have any thoughts?

[chinwoei]

Is it the from_name is the chinese character word?
Will it because of the chinese character set problem?

[cwoodward]

Thanks for the reply. We are using an English character set. I am unsure why the from_name looks like binary characters.

[conradt]

Retrieving emails is also a hassle for me. I get the same errors occassionally on different fields, sometimes it's the body field, sometimes the subject fields, etc.
The funny thing is, when I get this error, I copy/paste the exact sql statement and try to execute it in my MySql manager directly, and there the statement gets executed without a problem and the mail inserted into the email table.
I'm using SugarCRM4.5.1e, PHP5, MySql5 on Windows.
I didn't notice any "Chinese" characters in my mails as you describe below.

I also noticed: sometimes after clicking the 'check mail' button, Sugar ends up with a white screen, although when I go back then and to my inbox, some emails have actually been retrieved.

Nevertheless, I notice that some (unread) emails in my IMAP account are still there and haven't been retrieved by Sugar.

All in all, I always have to check with my regular email client if I missed any email. The Sugar email client is currently hardly usuable if you can't be sure which email has been missed.
Also, in case a problem such as 'field too long' occurs, it should at least skip that mail (but leave it unread, which is obviously not the case at the moment) and proceed with all other mails.

My users regularly get the following error when Checking Mail. I have included a snippet of the error message below.

, from_name='-�2�轩ݕ�2r*�uا�Ʈ', to_addrs='xxx@xxxxxxx.com', cc_addrs=null, bcc_addrs=null, type='inbound', status='unread', message_id='954d61a7-c5e7-df7c-8d53-45c651ff379c', reply_to_name='-�2�轩ݕ�2r*�uا�Ʈ', intent='pick', mailbox_id='954d61a7-c5e7-df7c-8d53-45c651ff379c', raw_source=null, deleted='0'::MySQL error 1406: Data too long for column 'from_name' at row 1


I have increased the width of from_name in our DB to VARCHAR(255) but still see the error. Anybody have any thoughts?