Author Topic: Is there a character limit to mailings? (Read 1527 times)

moondancerjen · August 01, 2008, 01:09:09 pm

I'm trying to send a very LONG mailing out. It's something like 33,000 characters. And its getting cut off towards the end. I've searched around and I know there could be a problem with the SMTP server, but I looked in the civicrm database at the civicrm_mailing table and it is cut off in there too, and it cuts it off in the preview before I send it. I'm not using a header or a footer, in case you are wondering. I'm also using CiviCRM 2.0.2 and MySQL 4 in case that helps.

Can you please shed some light on what can be done to stop this from cutting off?

Thanks,
Jen

Chris Burgess · August 01, 2008, 03:36:18 pm

Sounds like the TEXT column for body_text or body_html is cutting you off at 32K. (I thought MySQL's TEXT field was 64K, but I could be wrong, or your DB could be a different config / platform to mine).

From my reading of the MySQL docs, it's possible for the 64K limit to be platform specific - so perhaps on your server this becomes 32K.

We did have some similar issues with truncated emails a while back, and I believe we fixed them by changing the column type for the body field.

See "Are there any file size limits to CiviMail" and the subsequent issue which is fixed for 2.1

You could do the following, and see if the issue persists:

Code: [Select]

ALTER TABLE civicrm_mailing CHANGE COLUMN body_html body_html LONGTEXT ;
ALTER TABLE civicrm_mailing CHANGE COLUMN body_text body_text LONGTEXT ;

I'm not sure if the associated patch from r14132 to CRM/Utils/Type.php is required - I suspect it's not - but maybe one of the CiviCRM team can clarify that point.

Donald Lobo · August 01, 2008, 08:59:44 pm

The patch for Type.php is not essential in this case

lobo

Chris Burgess · August 03, 2008, 08:51:21 pm

moondancerjen, would you have a moment to confirm whether or not the suggested fix above resolved the truncation issue for you?

also, if it does resolve the issue, i'd be very interested to know what civicrm version and mysql server platform you're on, with truncation at 32K for a TEXT field

cheers

moondancerjen · August 04, 2008, 08:31:12 am

I looked at the size of the file I was uploading and it was 103K!!!!!!!!!! So I think we have 64K limit, its just my client was using Microsoft Word and it was adding a ton of extra formatting. I'm looking forward to the integration of TinyMCE with the mailings so they can use something they are already familiar with the send out the mailings without all the additional formatting from Word.

I redid the formatting in Dreamweaver and reduced the mailing to half its size, and had no truncating when I sent it. I'm just going to have to move my clients from Microsoft Word to a free WYSIWYG Editor until the next version of CiviCRM comes out.

Thank you for all your help!

CiviCRM Community Forums (archive)

News:

Author Topic: Is there a character limit to mailings? (Read 1527 times)

moondancerjen

Is there a character limit to mailings?

Chris Burgess

Re: Is there a character limit to mailings?

Donald Lobo

Re: Is there a character limit to mailings?

Chris Burgess

Re: Is there a character limit to mailings?

moondancerjen

Re: Is there a character limit to mailings?