View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
08537Bug reportsSurvey participants (Tokens)public2014-01-14 09:422014-01-25 17:22
ReporterpfpDave Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.05+ 
Summary08537: Survey admin allows token length to be set at a value that exceeds schema column width (36)
Description

Survey General Settings --> Tokens --> Set Token Length to allows a value that exceeds the schema column length of 36 characters. Setting this causes an error when generating tokens (be this admin or self registration). If the latter then then following error is displayed to the participant:

Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.
An internal error occurred while the Web server was processing your request. Please contact the webmaster to report this problem.

Thank you.

Steps To Reproduce
  1. Create a new survey
  2. Switch to closed access mode
  3. Add a token entry then use the 'Generate Tokens' button
    OR
    3a. Allow self registration
    3b. attempt to register for the survey
TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)130611
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionSQL Server Express 2012
Server OS (if known)Windows Server 2008 R2
Webserver software & version (if known)IIS 7
PHP Version5.4.8

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-01-17 17:11

administrator   ~27968

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

c_schmitz

2014-01-25 17:22

administrator   ~28163

2.05+ Build 140125 released

Related Changesets

LimeSurvey: master 521095a4

2014-01-17 16:11:32

c_schmitz

Details Diff 		Fixed issue 08537: Survey admin allows token length to be set at a value that exceeds schema column width (36) Affected Issues
08537
mod - application/controllers/admin/database.php Diff File
mod - application/controllers/admin/surveyadmin.php Diff File
mod - application/models/Survey.php Diff File
mod - application/views/admin/survey/subview/tabTokens_view.php Diff File

Issue History

Date Modified Username Field Change
2014-01-14 09:42 pfpDave New Issue
2014-01-17 17:10 c_schmitz Assigned To => c_schmitz
2014-01-17 17:10 c_schmitz Status new => assigned
2014-01-17 17:11 c_schmitz Status assigned => resolved
2014-01-17 17:11 c_schmitz Fixed in Version => 2.05+
2014-01-17 17:11 c_schmitz Resolution open => fixed
2014-01-17 17:11 c_schmitz Changeset attached => LimeSurvey master 521095a4
2014-01-17 17:11 c_schmitz Note Added: 27968
2014-01-25 17:22 c_schmitz Note Added: 28163
2014-01-25 17:22 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)