View Issue Details

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

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

On https://www.limesurvey.org/

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?

www.limesurvey.org 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 www.limesurve.org is using
Server OS (if known)Any
Webserver software & version (if known)Any
PHP VersionPHP Version 7.1.21 on my local Linux

Activities

LouisGac

LouisGac

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