View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
08967Bug reportsCentral participant databasepublic2014-04-15 15:322014-04-22 21:28
ReporterNicksonYap Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.05+ 
Fixed in Version2.05+ 
Summary08967: Unable to map paticipant attributes to "Token attributes to create" when adding participants to survey.
Description

A survey was created simply.
When I add participants to survey and drag and drop attributes from the CPDB column to the , "Token attributes to create" and click "Continue"
A messy error popped up and seems to be related to:
SQLSTATE[42000]

Steps To Reproduce
  1. Create test survey.
  2. Add participants into CPDB.
  3. Create attributes in CPDB.
  4. Assign attribute values to participants.
  5. Select and add few participants to survey.
  6. Drag and drop "participant attributes" from left column to middle column.
  7. Click "Continue"
  8. Messy error apprears.
Additional Information

I installed LimeSurvey using Installatron.
I have reproduced this many times in the same version.
I have ran the database integrity check from LS.

Error cannot be reproduced in version:
2.00+
2.05+.131209

Error is reproduced in version:
2.05+.140404
2.05+.140414

I have also manually installed 2.05+.140414, manually created MySQL database.
The "messy" error is reproduced.

TagsNo tags attached.
Attached Files
Untitled-1.jpg (340,715 bytes)
limesurvey_survey_921242.lss (12,640 bytes)
8967-with-trace.JPG (126,128 bytes)
Bug heat8
Complete LimeSurvey version number (& build)140414
I will donate to the project if issue is resolvedNo
BrowserGoogle Chrome
Database type & versionMySQL 5.5.32-cll-lve
Server OS (if known)Linux
Webserver software & version (if known)cPanel 11.40.1 (build 11)
PHP Version5.4.23

Users monitoring this issue

NicksonYap

Activities

NicksonYap

NicksonYap

2014-04-15 15:58

reporter   ~29800

Error cannot be reproduced in version:
2.05+.140317

Error was produced in version:
2.05+.140320
NicksonYap

NicksonYap

2014-04-15 16:00

reporter   ~29801

Last edited: 2014-04-15 16:00

To summarize everything so that the devs can know from which version the problem comes in:

Error cannot be reproduced in version:
2.00+
2.05+.131209
2.05+.140317

Error is reproduced in version:
2.05+.140320
2.05+.140404
2.05+.140414

This means from the transition from 2.05+.140317 to 2.05+.140414 caused the problem.
moorech

moorech

2014-04-15 16:10

reporter   ~29803

I am also seeing this bug. Experienced in 140404 and now in 140414

LimeSurvey build number OR git commit ID 140414
Browser Google Chrome, Latest
Database & DB-Version MySQL 5.0.95
Operating System (Server) RHEL 6
Webserver software & version Apache 2.2.3-83
PHP Version 5.3.3
NicksonYap

NicksonYap

2014-04-15 16:16

reporter   ~29804

Suddenly, i get this error in: 2.05+.140317
Oh my....
I'm now checking if I was confused or the error was not that simple.
NicksonYap

NicksonYap

2014-04-15 16:52

reporter   ~29807

I did some tests on 2.05+ Build 140226.
Long story short:
I did not get the error in the first place, add participant to survey, no problem.
I then added another participant and attribute, i tried to add participant to survey, i get the error again.

Everything it just too confusing for me to tell what was going on.
c_schmitz

c_schmitz

2014-04-16 14:58

administrator   ~29818

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

c_schmitz

2014-04-22 21:28

administrator   ~29858

2.05+ Build 140422 released.

Related Changesets

LimeSurvey: master 9c2aadfc

2014-04-16 14:57

c_schmitz


Details Diff		 Fixed issue 08967: Unable to map paticipant attributes to "Token attributes to create" when adding participants to survey Affected Issues
08967
mod - application/models/Participant.php Diff File

Issue History

Date Modified Username Field Change
2014-04-15 15:32 NicksonYap New Issue
2014-04-15 15:32 NicksonYap File Added: Untitled-1.jpg
2014-04-15 15:33 NicksonYap Issue Monitored: NicksonYap
2014-04-15 15:35 NicksonYap File Added: limesurvey_survey_921242.lss
2014-04-15 15:37 c_schmitz Assigned To => c_schmitz
2014-04-15 15:37 c_schmitz Status new => assigned
2014-04-15 15:58 NicksonYap Note Added: 29800
2014-04-15 16:00 NicksonYap Note Added: 29801
2014-04-15 16:00 NicksonYap Note Edited: 29801
2014-04-15 16:01 c_schmitz Priority urgent => normal
2014-04-15 16:10 moorech Note Added: 29803
2014-04-15 16:13 moorech File Added: 8967-with-trace.JPG
2014-04-15 16:16 NicksonYap Note Added: 29804
2014-04-15 16:52 NicksonYap Note Added: 29807
2014-04-16 14:58 c_schmitz Status assigned => resolved
2014-04-16 14:58 c_schmitz Fixed in Version => 2.05+
2014-04-16 14:58 c_schmitz Resolution open => fixed
2014-04-16 14:58 c_schmitz Changeset attached => LimeSurvey master 9c2aadfc
2014-04-16 14:58 c_schmitz Note Added: 29818
2014-04-22 21:28 c_schmitz Note Added: 29858
2014-04-22 21:28 c_schmitz Status resolved => closed
2021-08-08 23:45 guest Bug heat 6 => 8