19332: Multiple Choice Questions not working (can't save) - LimeSurvey bugs and feature requests

This issue affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

19332	Bug reports	Survey editing	public	2024-01-02 08:48	2024-01-15 19:38

Reporter	c.schwarzenberg	Assigned To	gabrieljenik
Priority	none	Severity	block
Status	closed	Resolution	duplicate
Product Version	6.4.x

Summary	19332: Multiple Choice Questions not working (can't save)
Description	When creating/editing a multiple choice (MC) question, the first answer option can be saved. But when more than one MC option is added, saving fails with: `CDbCommand failed to execute the SQL statement: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type integer: "new39813" LINE 1: ...ELECT * FROM "lime_questions" "t" WHERE "t"."qid"='new39813'... ^` The questionID (qid) is prefixed with `new`, but an integer is expected.
Steps To Reproduce	Create new survey Add a MC question Set question type to "Multiple choice questions" > "Multiple choice" (Enter question) Add >1 subquestion Click on Save -> Fails with error message
Tags	No tags attached.

Bug heat	8
Complete LimeSurvey version number (& build)	6.4.0+231218
I will donate to the project if issue is resolved	No
Browser
Database type & version	Postgresql 13
Server OS (if known)	Debian 11
Webserver software & version (if known)	nginx 1.18
PHP Version	7.4.33

User List	There are no users monitoring this issue.

DenisChenu 2024-01-11 08:55 developer ~79146	@c.schwarzenberg if you can test the patch https://github.com/LimeSurvey/LimeSurvey/pull/3686/files And tell us if it's OK on https://bugs.limesurvey.org/view.php?id=19331

c.schwarzenberg 2024-01-13 15:17 reporter ~79160	Hi @DenisChenu Thank you very much, that fixes it. I am not allowed to open/see the linked issue 19331.

c.schwarzenberg 2024-01-13 15:17 reporter ~79161	Hi @DenisChenu Thank you very much, that fixes it. I am not allowed to open/see the linked issue 19331.

gabrieljenik 2024-01-15 14:25 manager ~79166	@DenisChenu Can you review and provide insght about failing CI? I wasn't able to run the test locally actually.

gabrieljenik 2024-01-15 14:50 manager ~79167	https://github.com/LimeSurvey/LimeSurvey/actions/runs/7388055003/job/20492562356#step:7:739

DenisChenu 2024-01-15 16:46 developer ~79168	@DenisChenu Can you review and provide insght about failing CI? I don't view the failing CI …

mferraz 2024-01-15 19:38 reporter ~79170	This seems to be the same bug that I've reopened here: https://bugs.limesurvey.org/view.php?id=18896 Can I try that patch?

Date Modified	Username	Field	Change
2024-01-02 08:48	c.schwarzenberg	New Issue
2024-01-08 11:03	DenisChenu	Assigned To	=> gabrieljenik
2024-01-08 11:03	DenisChenu	Status	new => closed
2024-01-08 11:03	DenisChenu	Resolution	open => duplicate
2024-01-11 08:55	DenisChenu	Note Added: 79146
2024-01-11 08:55	DenisChenu	Bug heat	0 => 2
2024-01-13 15:17	c.schwarzenberg	Note Added: 79160
2024-01-13 15:17	c.schwarzenberg	Bug heat	2 => 4
2024-01-13 15:17	c.schwarzenberg	Note Added: 79161
2024-01-15 14:25	gabrieljenik	Note Added: 79166
2024-01-15 14:25	gabrieljenik	Bug heat	4 => 6
2024-01-15 14:50	gabrieljenik	Note Added: 79167
2024-01-15 16:46	DenisChenu	Note Added: 79168
2024-01-15 19:38	mferraz	Note Added: 79170
2024-01-15 19:38	mferraz	Bug heat	6 => 8