View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
08497Bug reportsCentral participant databasepublic2013-12-31 04:102014-01-16 16:45
Reporterduvemyster Assigned Toc_schmitz  
PrioritylowSeverityminor 
Status closedResolutionfixed 
Fixed in Version2.05+ 
Summary08497: Long email address fields are truncated when utilizing "Add participants to central database" from token table
Description

The token table email field type is text.
The participant table email field type is varchar(80).
Characters 81 and following are truncated when sending a long token table email field to the participant table.

Steps To Reproduce

The steps to reproduce are rare cases. Following are two examples:

  1. Enter an email address longer than 80 characters in a token table.
  2. And/or, edit a token table to string together multiple email addresses that cumulatively exceed 80 characters (i.e., one recipient with multiple email accounts)

Then "add participant to central database" from token table.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)Build 131206
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome Version 31.0.1650.63 m
Database type & versionMySQL 5.1
Server OS (if known)Linux
Webserver software & version (if known)Apache/2.2
PHP Version5.4.10

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-01-14 01:28

administrator   ~27844

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=13679
c_schmitz

c_schmitz

2014-01-14 01:29

administrator   ~27845

Patch fixes all email fields to maximum email size of 254 characters.
Note: Multiple email addresses in tokens were never officially supported.
Anyway, Central participants database only supports single email addresses. On import into CPDB the first one is used if multiple ones are provided in tokens.
c_schmitz

c_schmitz

2014-01-16 16:45

administrator   ~27914

2.05+ Build 140116 released

Related Changesets

LimeSurvey: master f2939dd2

2014-01-14 00:27:45

c_schmitz

Details Diff 		Fixed issue 08497: Long email address fields are truncated when utilizing "Add participants to central database" from token table Affected Issues
08497
mod - application/config/version.php Diff File
mod - application/controllers/admin/participantsaction.php Diff File
mod - application/helpers/update/updatedb_helper.php Diff File
mod - installer/sql/create-mssql.sql Diff File
mod - installer/sql/create-mysql.sql Diff File
mod - installer/sql/create-pgsql.sql Diff File

Issue History

Date Modified Username Field Change
2013-12-31 04:10 duvemyster New Issue
2014-01-09 23:33 c_schmitz Assigned To => c_schmitz
2014-01-09 23:33 c_schmitz Status new => assigned
2014-01-14 01:28 c_schmitz Changeset attached => LimeSurvey master f2939dd2
2014-01-14 01:28 c_schmitz Note Added: 27844
2014-01-14 01:28 c_schmitz Resolution open => fixed
2014-01-14 01:29 c_schmitz Note Added: 27845
2014-01-14 01:29 c_schmitz Status assigned => resolved
2014-01-14 01:29 c_schmitz Fixed in Version => 2.05+
2014-01-16 16:45 c_schmitz Note Added: 27914
2014-01-16 16:45 c_schmitz Status resolved => closed