Change Long Text to more than 400 Chars

Nickjansen

Recently I tried to send out a newsletter but it kept cutting off the limit of words I could have after pasting in the HTML code.

I found that the Recordset for Campaign manager - email message is using
Long text.

Here is the document that explains that long text only hold 400 characters not including the HTML code. https://www.epesi.org/devtutorial/helloworld/rbofields#long-text

Long text
Holds note (long string value). HTML entities are escaped. It has support for the bbcode feature. Due to the fact that attachments are added to nearly all RecordSets - we limit the length of that field to 400 characters (not counting bbcodes tags).

How can I increase the character count so my HTML Newsletters are not getting limited?

praski

Are you shure about it?
I remember there was limitations in very old EPESI versions.

Actually you can insert tons of chars in long text field without problems.
Try it yourself.

Best regards
Praski

Nickjansen

I have tried many different things, but it just cuts off the email campaign. it isn't until I start removing characters that are not code. For example product descriptions. When I start removing out product descriptions, it shows more of the campaign. Otherwise I cannot get the full email campaign in there. It previews it ok, but after I have saved and then go back to view it, it cuts off.

Nickjansen

Or perhaps there is a limit on the block size?

Nickjansen

It is definitely the amount of text that isn't code. The more text in product descriptions I remove, the more of the email campaign I can fit in. Could the external picture URL's be taking up too much limit?

Nickjansen

So far the HTML code I want to display is 98,182 chars, 1,154 lines.

We are using MailStyler2 to design our news letters.

Hopefully someone can help, I think the issue here is that the length of the code is just too long for EPESI Campaign manager to handle.

jasiek

Nickjansen
Sorry for the late answer.
I really can not tell you what happens behind the scene if you are using MailStyler to create templates.
Campaign Manager has a field that holds the e-mail subject and a field that holds the body of an e-mail message:

This field TEXT data type represents a text column with a maximum length of 65,535. You can change it via phpMyAdmin panel to a different type:

Please note that I did not test the behavior of the module with a different field type.

TINYTEXT − This data type represents a text column with a maximum length of 255 (28 - 1) characters. In storage, each uses a one-byte length prefix indicating the byte quantity in the value.

TEXT − This data type represents a text column with a maximum length of 65,535 (216 - 1) characters. In storage, each uses a two-byte length prefix indicating the byte quantity in the value.

MEDIUMTEXT − This data type represents a text column with a maximum length of 16,777,215 (224 - 1) characters. In storage, each uses a three-byte length prefix indicating the byte quantity in the value.

LONGTEXT − This data type represents a text column with a maximum length of 4,294,967,295 or 4GB (232 - 1) characters. In storage, each uses a four-byte length prefix indicating the byte quantity in the value.

https://www.tutorialspoint.com/mariadb/mariadb_data_types.htm

jasiek

I don't know what happens when a template is constructed. Probably it is simply too long.
Analyzing log files should give you an answer - does it save to the database correctly? You can inspect raw data via DB Admin tools.

Nickjansen

When we create it in Mailstyler it creates the code with approx 64,000 chars. After putting it into the Campaign Manager, it then converts it to 66,000ish chars. If the database is only accepting 65,535 then this appears to be where the problem is. Thanks very much for coming back to me. I think the best thing to do is go to MediumText at this stage so we can create bigger mailouts.

Is there any instruction on easily installing PHPMYADMIN on the same server as EPESICRM? I am using Ubuntu 16.04

Thanks for coming back to me! I really appreciate your help ?

jasiek

Nickjansen Thank you for detailing the problem. Hopefully it will come handy one day. I will have to put this on my list to do to increase the field size by default to avoid this situation in the future.
Thanks for reporting the problem and I am glad we can fix it quickly.

If you have shell access then follow these instructions to install PhpMyAdmin:
https://www.digitalocean.com/community/tutorials/how-to-install-and-secure-phpmyadmin-on-ubuntu-16-04

And let me know how it worked.
Good luck ?

Epesi ENS | Epesi Academy | epesi.cloud PaaS | GitHub

Help Me! | Download from SourceForge