View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
19332Bug reportsSurvey editingpublic2024-01-02 08:482024-01-15 19:38
Reporterc.schwarzenberg Assigned Togabrieljenik  
PrioritynoneSeverityblock 
Status closedResolutionduplicate 
Product Version6.4.x 
Summary19332: 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

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)6.4.0+231218
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgresql 13
Server OS (if known)Debian 11
Webserver software & version (if known)nginx 1.18
PHP Version7.4.33

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

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

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

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

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

gabrieljenik

2024-01-15 14:50

manager   ~79167

https://github.com/LimeSurvey/LimeSurvey/actions/runs/7388055003/job/20492562356#step:7:739
DenisChenu

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

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?

Issue History

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