View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
07029Bug reportsSurvey participants (Tokens)public2012-12-12 21:06
ReporterpfpDave Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionunable to reproduce 
Product Version2.00+ 
Summary07029: Adding participants from CPD to a survey Token table with custom attributes mapped gives CDbException error
Description

As discussed in 06956:

  • Create a survey with custom attributes
  • goto CPD (with same custom attributes)
  • select a couple of participants and click 'Add to survey'
  • Select survey from list and click Next
  • Map both attributes across and tick 'Make these mappings automatic in future'
  • Click Continue
  • Error appears:

<h1>CDbException</h1>

CDbCommand failed to execute the SQL statement: SQLSTATE[22018]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Conversion failed when converting the nvarchar value 'attribute_1' to data type int.. The SQL statement executed was: SELECT [value]
FROM [participant_attribute]
WHERE participant_id = :participant_id AND attribute_id = :attrid. Bound with participant_id='f588643d-00dd-4644-b851-feed5381a39a', attrid='attribute_1' (C:\limesurvey_test\framework\db\CDbCommand.php:528)

#0 C:\limesurvey_test\framework\db\CDbCommand.php(408): CDbCommand->queryInternal('fetch', Array, Array)
#1 C:\limesurvey_test\application\models\Participants.php(1107): CDbCommand->queryRow()
#2 C:\limesurvey_test\application\models\Participants.php(1078): Participants->updateTokenAttributeValue('154851', 'f588643d-00dd-4...', 'attribute_1', 17)
#3 C:\limesurvey_test\application\controllers\admin\participantsaction.php(1540): Participants->copytosurveyatt('154851', Array, Array, 'f588643d-00dd-4...', 'false', 'false', 'false', 'true')
#4 [internal function]: participantsaction->addToTokenattmap()
#5 C:\limesurvey_test\framework\web\actions\CAction.php(107): ReflectionMethod->invokeArgs(Object(participantsaction), Array)
#6 C:\limesurvey_test\application\core\Survey_Common_Action.php(82): CAction->runWithParamsInternal(Object(participantsaction), Object(ReflectionMethod), Array)
#7 C:\limesurvey_test\application\controllers\admin\participantsaction.php(51): Survey_Common_Action->runWithParams(Array)
#8 C:\limesurvey_test\framework\web\CController.php(309): participantsaction->runWithParams(Array)
#9 C:\limesurvey_test\framework\web\CController.php(287): CController->runAction(Object(participantsaction))
#10 C:\limesurvey_test\framework\web\CController.php(266): CController->runActionWithFilters(Object(participantsaction), Array)
#11 C:\limesurvey_test\application\controllers\AdminController.php(169): CController->run('participants')
#12 C:\limesurvey_test\framework\web\CWebApplication.php(276): AdminController->run('participants')
#13 C:\limesurvey_test\framework\web\CWebApplication.php(135): CWebApplication->runController('admin/participa...')
#14 C:\limesurvey_test\framework\base\CApplication.php(162): CWebApplication->processRequest()
#15 C:\limesurvey_test\index.php(178): CApplication->run()
#16 {main}

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)121204
I will donate to the project if issue is resolvedNo
BrowserFirefox 16
Database type & versionSQL Express 2012
Server OS (if known)Server 2008
Webserver software & version (if known)IIS 7
PHP Version5.4.8
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-12-07 11:23

administrator   ~23019

There have been quite some changes. Can you still reproduce it in 121207? If yes please attach a new debug dump

c_schmitz

c_schmitz

2012-12-11 15:46

administrator   ~23140

Pretty please?

pfpDave

pfpDave

2012-12-12 14:51

reporter   ~23176

Sorry for the delay ...

Tested in 121211 and looks to be fixed, many thanks!

c_schmitz

c_schmitz

2012-12-12 21:06

administrator   ~23188

Thank you.

Issue History

Date Modified Username Field Change
2012-12-05 14:25 pfpDave New Issue
2012-12-07 11:23 c_schmitz Note Added: 23019
2012-12-07 11:23 c_schmitz Assigned To => c_schmitz
2012-12-07 11:23 c_schmitz Status new => feedback
2012-12-11 15:46 c_schmitz Note Added: 23140
2012-12-12 14:51 pfpDave Note Added: 23176
2012-12-12 14:51 pfpDave Status feedback => assigned
2012-12-12 21:06 c_schmitz Note Added: 23188
2012-12-12 21:06 c_schmitz Status assigned => closed
2012-12-12 21:06 c_schmitz Resolution open => unable to reproduce
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)