- Posts: 21
- Thank you received: 3
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Extending email template length
- lemonlimebitters
- Topic Author
- Offline
- Junior Member
Less
More
5 years 7 months ago #172242
by lemonlimebitters
lemonlimebitters
Extending email template length was created by lemonlimebitters
Hi,
I'm having trouble saving my email templates that are longer than ~65889 characters.
I'm guessing this is a database size limitation, if so, is it possible to increase the email template to a medium blob?
(I'd be happy to install a new installation of Limesurvey if this was possible to prevent any corruption to existing surveys.)
Reason for large email size: With the demand for nice looking html emails, comes large amounts of nested CSS which takes up an enormous amount of characters.
Thanks in advance for any help or advice!
I'm having trouble saving my email templates that are longer than ~65889 characters.
I'm guessing this is a database size limitation, if so, is it possible to increase the email template to a medium blob?
(I'd be happy to install a new installation of Limesurvey if this was possible to prevent any corruption to existing surveys.)
Reason for large email size: With the demand for nice looking html emails, comes large amounts of nested CSS which takes up an enormous amount of characters.
Thanks in advance for any help or advice!
lemonlimebitters
The topic has been locked.
- Joffm
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 12790
- Thank you received: 3940
5 years 7 months ago #172265
by Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
Replied by Joffm on topic Extending email template length
Hi,
these templates are stored in table "[limeprefix]_surveys_languagesettings"
So, in a new installation, where you should also create a new database, change the default type of "text" to "mediumtext" or whatever.
And please share you findings.
I did it and at first sight everythings works fine.
But I do not know what will happen when updating. If this table will be affected and changed someday.
Best regards
Joffm
these templates are stored in table "[limeprefix]_surveys_languagesettings"
So, in a new installation, where you should also create a new database, change the default type of "text" to "mediumtext" or whatever.
And please share you findings.
I did it and at first sight everythings works fine.
But I do not know what will happen when updating. If this table will be affected and changed someday.
Best regards
Joffm
Volunteers are not paid.
Not because they are worthless, but because they are priceless
The following user(s) said Thank You: lemonlimebitters
The topic has been locked.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
5 years 7 months ago #172277
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Extending email template length
Recommend to open a bug report / feature request about this too.
Just changing the database structure might be a quick fix, but you might run into issues later.
Just changing the database structure might be a quick fix, but you might run into issues later.
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: lemonlimebitters
The topic has been locked.
- lemonlimebitters
- Topic Author
- Offline
- Junior Member
Less
More
- Posts: 21
- Thank you received: 3
5 years 6 months ago #173291
by lemonlimebitters
lemonlimebitters
Replied by lemonlimebitters on topic Extending email template length
Thanks JoffM and Jelo!
JoffM's solution seems to work for the time being, keeping in mind Jelo's comments.
So I changed all the email template columns to "mediumtext" in the table "[limeprefix]_surveys_languagesettings".
Everything seems stable enough:
- I'm able to send and receive my lengthy emails
- works fine with 'Placeholder fields' included
- no issues editing email templates
Bug reported : bugs.limesurvey.org/view.php?id=14021
Curious if it's only MySql that's affected as PostgreSQL doesn't seem to have such a limitation for 'text' columns, that I can find anyway.
JoffM's solution seems to work for the time being, keeping in mind Jelo's comments.
So I changed all the email template columns to "mediumtext" in the table "[limeprefix]_surveys_languagesettings".
Everything seems stable enough:
- I'm able to send and receive my lengthy emails
- works fine with 'Placeholder fields' included
- no issues editing email templates
Bug reported : bugs.limesurvey.org/view.php?id=14021
Curious if it's only MySql that's affected as PostgreSQL doesn't seem to have such a limitation for 'text' columns, that I can find anyway.
lemonlimebitters
The topic has been locked.