View Issue Details

IDProjectCategoryView StatusLast Update
14021Bug reports[All Projects] Otherpublic2019-01-10 17:59
ReporterlemonlimebittersAssigned ToLouisGac 
Status closedResolutionno change required 
Product Version3.13.x 
Target VersionFixed in Version 
Summary14021: Email template length limited to ~65k characters

Not able to save email templates that are longer than ~65889 characters.

Table "lime_surveys_languagesettings" columns for email templates are too small. Can the size be increased?

With the demand for nice looking html emails, comes large amounts of embedded CSS which takes up an enormous amount of characters.

Tested on MySQL, v5.5.60

Steps To Reproduce


Try to save any email template longer than 65,535 characters into any email template.
It will save up until the character limit.

Additional Information

I'm not able to try this on a PostgreSQL server . Perhaps not affected as
text = 'variable unlimited length' on PostgreSQL? gives error message
"CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'surveyls_email_invite' at row 1"

TagsNo tags attached.
Complete LimeSurvey version number (& build)Version 3.14.3+180809 and Version 3.14.8
I will donate to the project if issue is resolvedNo
Browserany browser
Database & DB-VersionMySQL and what ever is using
Server OS (if known)Any
Webserver software & version (if known)Any
PHP VersionPHP Version 7.1.21 on my local Linux




2019-01-10 17:59

manager   ~50173

please, open a feature request for ls4

Issue History

Date Modified Username Field Change
2018-08-31 10:29 lemonlimebitters New Issue
2019-01-10 17:59 LouisGac Assigned To => LouisGac
2019-01-10 17:59 LouisGac Status new => closed
2019-01-10 17:59 LouisGac Resolution open => no change required
2019-01-10 17:59 LouisGac Note Added: 50173