Error Composing Emails with Attachments

[austvader]

I cannot compose emails with attchements.The attachment is about 800k. The funny thing is the email is sent but the record is not inserted into the DB and I get an onscreen error as follows.

Each time I send an email to a Contact using Sugar I get The error:

Query Failed: Insert into emails.........Data to Long for Column 'row_source' at row 1

I am using
- Sugar CRM v4.5.0f
- PHP version 5.1.9
- MySQL 5.0.24a
- Windows 2003 Server
- IIS6

Help would be apprecisted as this problem did not used to be there when we were runing 4.2

[austvader]

desperate for Help.....Any ideas?
Still have not been able to solve this....can anyone help as it makes the email tracking system unusable...

[austvader]

Still no replies..I am desperate to solve this....can anyone help.....

[ruchida]

What is the charset setting of the database?
There is a chance that the emails table is not configured to store UTF-8 strings.

How long is your email? Is it relatively long?

[rwb]

I'm getting the same error when attempting to send e-mail /w attachments:

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

The attachment is relatively small, 316KB.

I'm running: Sugar OS 4.5.0g, PHP 5.1.4, Windows 2003, IIS 6, MySQL 5.0.27

I added 'max_allowed_packet=32M' to the my.ini... same result.

ruchida - I'm relatively new to MySQL. How do I verify that the email table is configured to store UTF-8 strings? PHPmyadmin shows the 'raw_source' column as type: text, collation: utf8_general_ci

austvader - were you able to figure out what your problem was?

Thanks,

Ross

[sflores]

Hi all.

I am newby on Sugar, almost near to an end user. Anyway, I hope you can help me.

After looking the above messages, I decided to post a similar problem. The difference is that I do not receive any error messages. I am running Version 4.5.0f (Build 1202) with the following
Installation Summary
------------------------
Installation directory: C:\Archivos de programa\sugarcrm-4.5.0f/
Apache HTTP port: 801 (I have another web service in port 80)
Apache HTTPS port: 443
MySQL port: 3306
Windows XP Proffesional Service Pack 1
Pentium 2.66 GHZ 496 RAM
SMTP settingsPort 25

My problem is that e-mails without attachments are sent OK. Even when I enclose one or two small gif files there is no problem. The issue is when sending more attachments not being longer than 1.5 MB they are never gone, besides this, Sugar CRM delivers a blank page and I have to close or go back with the Explorer... Sorry if posting in this place, but I thought this problem could add more information. Anyway, can you please help me? My users are getting dissapointed with this and they have to send e-mails through Outlook with the information, of course, being left without any registration into the SugarCRM

One other thing. I had to stop the firewall running on the server in order to allow SugarCRM to send these e-mails...

Thanks

Salvador

I'm getting the same error when attempting to send e-mail /w attachments:



The attachment is relatively small, 316KB.

I'm running: Sugar OS 4.5.0g, PHP 5.1.4, Windows 2003, IIS 6, MySQL 5.0.27

I added 'max_allowed_packet=32M' to the my.ini... same result.

ruchida - I'm relatively new to MySQL. How do I verify that the email table is configured to store UTF-8 strings? PHPmyadmin shows the 'raw_source' column as type: text, collation: utf8_general_ci

austvader - were you able to figure out what your problem was?

Thanks,

Ross

[austvader]

Hi ruchida,

Sorry for the long delay in reply. I have been overseas for the past month so just picked up your reply.

I checked the char set for both the table and column and both are set to utf8 with collation of utf8_general_ci which I think is correct.

I just applied the latest patch_h to my 4.5.0 system to see if that helped. But this did not solve the problem.

Have you any other ideas as to what it is. Email are still sent ok with attachements but are not stored in the DB.

Has anyone else on this thread solved the problem?

regards
Geoff

[ruchida]

Hi ruchida,

Sorry for the long delay in reply. I have been overseas for the past month so just picked up your reply.

I checked the char set for both the table and column and both are set to utf8 with collation of utf8_general_ci which I think is correct.

I just applied the latest patch_h to my 4.5.0 system to see if that helped. But this did not solve the problem.

Have you any other ideas as to what it is. Email are still sent ok with attachements but are not stored in the DB.

Has anyone else on this thread solved the problem?

regards
Geoff

Hi

It seems your attachment exceeds the size of the raw_source column in the emails table. If you have access to the emails table via phpMyAdmin or other MySQL tools, you need to change the type of the raw_source column from "text" to "mediumtext". The "text" field can store only 64K data, but "mediumtext" can store 16MB.

[austvader]

Thanks for the response.

The suggestion worked great to change the type of the raw_source column in the "email" table from "text" to "mediumtext". ..all seems to be functioning correctly now.

Much appreciated.