18663: SQL error when adding survey participants along with their custom attributes to CPDB

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

18663	Bug reports	Survey participants (Tokens)	public	2023-03-02 12:18	2023-03-26 15:22

Reporter	twilllig	Assigned To	DenisChenu
Priority	none	Severity	minor
Status	resolved	Resolution	fixed
Product Version	5.6.x

Summary	18663: 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
Tags	No tags attached.

Bug heat	4
Complete LimeSurvey version number (& build)	5.6.8
I will donate to the project if issue is resolved	No
Browser	Chrome
Database type & version	mySql
Server OS (if known)
Webserver software & version (if known)
PHP Version	8.0.25

User List	There are no users monitoring this issue.

twilllig 2023-03-02 12:18 developer	survey_archive_427567.lsa (4,273 bytes) bug_participants.png (113,104 bytes)

DenisChenu 2023-03-02 15:21 developer ~74007	https://github.com/LimeSurvey/LimeSurvey/pull/2959

twilllig 2023-03-02 15:59 developer ~74009	wow, that was fast

DenisChenu 2023-03-02 16:57 developer ~74011	I like to play with model->rules ;)

DenisChenu 2023-03-22 12:37 developer ~74223	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=34388

LimeSurvey: master 36fe2561 2023-03-22 12:37:40 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

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