Length limit on CiviMail content?

[Larry Gordon]

I just discovered that one of my rather lengthy newsletters had the end cut off by CiviMail. I uploaded an html file for the content. The last section was cut off.

Is there a word limit on content for CiviMail? Or is this some peculiarity with uploading?

[petednz]

Don't know if there was a limit. How long was yours? We haven't sent huge ones from memory but not had that problem - circa 500 words 4000 characters

[Larry Gordon]

It was very very long - 8200 words.

[Donald Lobo]

what version of civicrm? earlier versions stored the content in a text field, the later version use longtext which has significatly more space

check the mysql docs and do an alter table of the body_text and body_html from 'text' to 'longtext'

lobo

[Piotr Szotkowski]

I just discovered that one of my rather lengthy newsletters had the end cut off by CiviMail. I uploaded an html file for the content. The last section was cut off.

Is there a word limit on content for CiviMail? Or is this some peculiarity with uploading?

There shouldn’t be.

Can you please check:

1. What does the report say.
2. What does the database store.
3. If you have a copy as a recipient, what do the headers look like (do they say anything about truncating the contents).

[adixon]

Thanks, it was version 1.9, so it was the database type issue. For anyone else:

Code: [Select]

ALTER TABLE `civicrm_mailing`
    MODIFY `body_text` longtext NULL DEFAULT NULL,
    MODIFY `body_html` longtext NULL DEFAULT NULL;
was the solution.