View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
08777Bug reportsSurvey participants (Tokens)public2014-02-27 08:512014-03-02 12:30
ReporterDosMaster Assigned Toc_schmitz  
PriorityhighSeveritycrash 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08777: Incorrect syntax is used for MSSQL when mapping participant attributes to new token.
Description

Wrong syntax to add a column in MSSQL.
Syntax used:
ALTER TABLE tokens_436639 ADD COLUMN [attribute_1] VARCHAR ( 255 )

Should be:
ALTER TABLE tokens_436639 ADD [attribute_1] VARCHAR ( 255 )

driver used:
extension=php_pdo_sqlsrv_54_nts.dll

the word COLUMN should not be used.

Steps To Reproduce

When adding participant to survey in participant panel, the next step is to map unmapped participant attributes. After moving unmapped attribute from "Unmapped participant attributes" to "token attributes to create" and pressing continue, it will crash.
Se attached image.

TagsNo tags attached.
Attached Files
LSError.gif (31,596 bytes)   
LSError.gif (31,596 bytes)   
Bug heat2
Complete LimeSurvey version number (& build)140226
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMSSQL 2008
Server OS (if known)WIndows 2008 R2
Webserver software & version (if known)IIS 7.5
PHP Version5.4.25

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2014-02-27 09:05

administrator   ~28963

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

c_schmitz

2014-03-02 12:30

administrator   ~29056

2.0+ Build 140302 released.

Related Changesets

LimeSurvey: master 3f8613f4

2014-02-27 08:05:36

c_schmitz

Details Diff 		Fixed issue 08777: Error when mapping participant attributes to new token attributes adn using MSSQL Affected Issues
08777
mod - application/models/Participant.php Diff File

Issue History

Date Modified Username Field Change
2014-02-27 08:51 DosMaster New Issue
2014-02-27 08:51 DosMaster File Added: LSError.gif
2014-02-27 08:55 c_schmitz Assigned To => c_schmitz
2014-02-27 08:55 c_schmitz Status new => assigned
2014-02-27 09:05 c_schmitz Changeset attached => LimeSurvey master 3f8613f4
2014-02-27 09:05 c_schmitz Note Added: 28963
2014-02-27 09:05 c_schmitz Resolution open => fixed
2014-02-27 09:06 c_schmitz Status assigned => resolved
2014-02-27 09:06 c_schmitz Fixed in Version => 2.05+
2014-03-02 12:30 c_schmitz Note Added: 29056
2014-03-02 12:30 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)