View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
05800Bug reportsSurvey participants (Tokens)public2012-02-09 22:092012-07-19 23:34
ReporterMazi Assigned Tojcleeland  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.00a2 
Target Version2.00a2Fixed in Version2.00RC5 
Summary05800: CPDB attribute mapping problems
Description

  1. Third column missing at attribute mapping
    When mapping CPDB attributes -> token attributes (after having clicked the "add to survey" button at CPDB), the attributes of the previously selected token table are missing.
    Compare to the screen shots at documentation based on CI version: http://docs.limesurvey.org/Central+Participants+Database

  2. Errors at mapping (see step #4 below)

  3. Attribute meta data of additional token attributes gets overwritten (see attached screen shots)

Steps To Reproduce
  1. At CPDB -> display participants click "add to survey" button.
  2. Select a survey of which the token table offers additional attributes.
  3. -> At the mapping only 2 columns are shown.
  4. -> When dropping 1 attribute at the right column and then clicking "continue", I get an error, see "Additional Information" below.
  5. When clicking away the error pop up, I see that a new column at the token table was created. When then going to the "manage additional fields" overview one can see that formerly existing metadata of additional attributes got lost (see screens).
Additional Information

Error step #4:

<h1>CDbException</h1>
<p>CDbCommand failed to execute the SQL statement: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'edb76bbc-45e0-4dfd-8877-7d02f59659eb-2-376249' for key 'PRIMARY'. The SQL statement executed was: INSERT INTO lime_survey_links (participant_id, token_id, survey_id, date_created) VALUES (:participant_id, :token_id, :survey_id, :date_created) (C:\xampp\htdocs\limesurvey_yii\framework\db\CDbCommand.php:336)</p><pre>#0 C:\xampp\htdocs\limesurvey_yii\framework\db\CDbCommand.php(1166): CDbCommand->execute(Array)
#1 C:\xampp\htdocs\limesurvey_yii\application\models\Participants.php(1213): CDbCommand->insert('{{survey_links}...', Array)
#2 C:\xampp\htdocs\limesurvey_yii\application\controllers\admin\participantsaction.php(1694): Participants->copytosurveyatt('376249', '', Array, 'edb76bbc-45e0-4...')
#3 [internal function]: participantsaction->addToTokenattmap()
#4 C:\xampp\htdocs\limesurvey_yii\framework\web\actions\CAction.php(104): ReflectionMethod->invokeArgs(Object(participantsaction), Array)
#5 C:\xampp\htdocs\limesurvey_yii\application\core\Survey_Common_Action.php(82): CAction->runWithParamsInternal(Object(participantsaction), Object(ReflectionMethod), Array)
#6 C:\xampp\htdocs\limesurvey_yii\framework\web\CController.php(300): Survey_Common_Action->runWithParams(Array)
#7 C:\xampp\htdocs\limesurvey_yii\framework\web\CController.php(278): CController->runAction(Object(participantsaction))
#8 C:\xampp\htdocs\limesurvey_yii\framework\web\CController.php(257): CController->runActionWithFilters(Object(participantsaction), Array)
#9 C:\xampp\htdocs\limesurvey_yii\application\controllers\AdminController.php(149): CController->run('participants')
#10 C:\xampp\htdocs\limesurvey_yii\framework\web\CWebApplication.php(277): AdminController->run('participants')
#11 C:\xampp\htdocs\limesurvey_yii\framework\web\CWebApplication.php(136): CWebApplication->runController('admin/participa...')
#12 C:\xampp\htdocs\limesurvey_yii\framework\base\CApplication.php(158): CWebApplication->processRequest()
#13 C:\xampp\htdocs\limesurvey_yii\index.php(171): CApplication->run()
#14 {main}</pre>

TagsNo tags attached.
Attached Files
mapping_current.png (38,489 bytes)   
mapping_current.png (38,489 bytes)   
attributemap[1].png (12,347 bytes)   
attributemap[1].png (12,347 bytes)   
tokenscreen.png (6,866 bytes)   
tokenscreen.png (6,866 bytes)   
token_attributes.PNG (9,865 bytes)   
token_attributes.PNG (9,865 bytes)   
tokenscreen_after_mapping.png (10,681 bytes)   
tokenscreen_after_mapping.png (10,681 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)12411
I will donate to the project if issue is resolvedNo
BrowserFirefox 9
Database type & versionMySQL 5
Server OS (if known)Win 7
Webserver software & version (if known)Apache 2.2
PHP Version5.3.1

Relationships

Relationship GraphDependency Graph
related to 05801 closedjcleeland CPDB attribute mapping GUI design issues 

Users monitoring this issue

There are no users monitoring this issue.

Activities

jcleeland

jcleeland

2012-07-11 05:25

reporter   ~19697

Fixed in update 20120710
c_schmitz

c_schmitz

2012-07-19 23:34

administrator   ~19824

2.00RC6 released.

Issue History

Date Modified Username Field Change
2012-02-09 22:09 Mazi New Issue
2012-02-09 22:09 Mazi Status new => assigned
2012-02-09 22:09 Mazi Assigned To => aniesshsethh
2012-02-09 22:09 Mazi File Added: mapping_current.png
2012-02-09 22:09 Mazi File Added: attributemap[1].png
2012-02-09 22:09 Mazi Assigned To aniesshsethh => jcleeland
2012-02-09 22:12 Mazi Steps to Reproduce Updated
2012-02-09 22:16 Mazi Description Updated
2012-02-09 22:16 Mazi Steps to Reproduce Updated
2012-02-09 22:16 Mazi Additional Information Updated
2012-02-09 22:17 Mazi File Added: tokenscreen.png
2012-02-09 22:17 Mazi File Added: token_attributes.PNG
2012-02-09 22:18 Mazi File Added: tokenscreen_after_mapping.png
2012-02-09 22:22 Mazi Relationship added related to 05801
2012-07-11 05:25 jcleeland Note Added: 19697
2012-07-11 05:25 jcleeland Status assigned => resolved
2012-07-11 05:25 jcleeland Fixed in Version => 2.00RC5
2012-07-11 05:25 jcleeland Resolution open => fixed
2012-07-19 23:34 c_schmitz Note Added: 19824
2012-07-19 23:34 c_schmitz Status resolved => closed
2016-12-08 10:39 c_schmitz Category Tokens => Survey participants (Tokens)