View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
14021Bug reportsOtherpublic2019-01-10 17:59
Reporterlemonlimebitters Assigned ToLouisGac 
PrioritynoneSeveritycrash 
Status closedResolutionno change required 
Product Version3.13.x 
Summary14021: Email template length limited to ~65k characters
Description

Not able to save email templates that are longer than 17503: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.
Bug heat2
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 type & 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

Users monitoring this issue

There are no users monitoring this issue.

Activities

LouisGac

LouisGac

2019-01-10 17:59

developer   ~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