View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
18663Bug reportsSurvey participants (Tokens)public2023-03-02 12:182023-06-20 17:49
Reportertwilllig Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version5.6.x 
Summary18663: SQL error when adding survey participants along with their custom attributes to CPDB
Description

When you add survey participants to the CPDB, custom attributes can not be copied.

Steps To Reproduce

Steps to reproduce

  • You need an active survey with participants and an added attribute which was added in "Manage attributes" on "Survey participants" menu. (I uploaded an example lsa.)
  • in "Survey participants" menu -> "Display participants": select one ore more participants and choose "Add participants to central database"
  • on the following page drag&drop your custom attribute into the second window "Participant attributes to create"
  • click on "Continue"
  • modal with SQL error message appears

Expected result

the attribute should be copied over to the CPDB

Actual result

attribute cannot be copied

TagsNo tags attached.
Attached Files
survey_archive_427567.lsa (4,273 bytes)
bug_participants.png (113,104 bytes)
Bug heat4
Complete LimeSurvey version number (& build)5.6.8
I will donate to the project if issue is resolvedNo
BrowserChrome
Database type & versionmySql
Server OS (if known)
Webserver software & version (if known)
PHP Version8.0.25

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2023-03-02 15:21

developer   ~74007

https://github.com/LimeSurvey/LimeSurvey/pull/2959
twilllig

twilllig

2023-03-02 15:59

developer   ~74009

wow, that was fast
DenisChenu

DenisChenu

2023-03-02 16:57

developer   ~74011

I like to play with model->rules
;)
DenisChenu

DenisChenu

2023-03-22 12:37

developer   ~74223

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

Related Changesets

LimeSurvey: master 36fe2561

2023-03-22 13:37

DenisChenu

Committer: GitHub


Details Diff		 Fixed issue 18663: SQL error when adding survey participants along w… (#2959) Affected Issues
18663
mod - application/models/Participant.php Diff File
mod - application/models/ParticipantAttributeName.php Diff File

Issue History

Date Modified Username Field Change
2023-03-02 12:18 twilllig New Issue
2023-03-02 12:18 twilllig File Added: survey_archive_427567.lsa
2023-03-02 12:18 twilllig File Added: bug_participants.png
2023-03-02 12:19 DenisChenu Assigned To => DenisChenu
2023-03-02 12:19 DenisChenu Status new => assigned
2023-03-02 14:49 DenisChenu Status assigned => confirmed
2023-03-02 15:21 DenisChenu Status confirmed => assigned
2023-03-02 15:21 DenisChenu Note Added: 74007
2023-03-02 15:21 DenisChenu Bug heat 0 => 2
2023-03-02 15:57 DenisChenu Assigned To DenisChenu => gabrieljenik
2023-03-02 15:57 DenisChenu Status assigned => ready for code review
2023-03-02 15:59 twilllig Note Added: 74009
2023-03-02 15:59 twilllig Bug heat 2 => 4
2023-03-02 16:57 DenisChenu Note Added: 74011
2023-03-02 18:45 gabrieljenik Assigned To gabrieljenik =>
2023-03-02 18:45 gabrieljenik Status ready for code review => ready for testing
2023-03-22 12:37 DenisChenu Changeset attached => LimeSurvey master 36fe2561
2023-03-22 12:37 DenisChenu Note Added: 74223
2023-03-22 12:37 DenisChenu Assigned To => DenisChenu
2023-03-22 12:37 DenisChenu Resolution open => fixed
2023-03-26 15:22 DenisChenu Status ready for testing => resolved
2023-06-20 17:49 c_schmitz Status resolved => closed