View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
19345Bug reportsSurvey editingpublic2024-01-16 09:26
Reporterevaluation2023 Assigned Togabrieljenik  
PrioritynoneSeveritycrash 
Status closedResolutionreopened 
Product Version6.4.x 
Summary19345: Error when trying to add new item to matrix question
Description

Since update to 6.4.0/6.4.1 always when try to add more than 1 item to a matrix question, i get an error message and the question will not be saved.

Error-message:
CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ungültige Eingabesyntax für Typ integer: »new65974« LINE 1: ...ELECT * FROM "lime_questions" "t" WHERE "t"."qid"='new65974'... ^

Reproduce:

  1. Create new question, type: matrix
  2. add more than 1 subquestion
  3. click "save" - then the error will occur

(when just adding one item, the question will be saved)

Steps To Reproduce

Steps to reproduce

(Replace this text with detailed step-by-step instructions on how to reproduce the issue)

Expected result

(Write here what you expected to happen)

Actual result

(Write here what happened instead)

TagsNo tags attached.
Attached Files
Unbenannt.png (44,914 bytes)   
Unbenannt.png (44,914 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)6.4.1+240108
I will donate to the project if issue is resolvedNo
Browser
Database type & versionPostgreSQL 13.13
Server OS (if known)Apache/2.4.56 (Debian)
Webserver software & version (if known)
PHP Version8.0.30

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2024-01-11 08:52

developer   ~79143

Thanks for your report.
Issue already reported, we close this on.

DenisChenu

DenisChenu

2024-01-11 08:54

developer   ~79145

@evaluation2023 : 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

evaluation2023

evaluation2023

2024-01-16 06:41

reporter   ~79171

Great - your solution seems to work ;-)
The error described seems to have been rectified.

Can't answer on https://bugs.limesurvey.org/view.php?id=19331 "access denied"

Issue History

Date Modified Username Field Change
2024-01-11 08:30 evaluation2023 New Issue
2024-01-11 08:30 evaluation2023 File Added: Unbenannt.png
2024-01-11 08:52 DenisChenu Assigned To => DenisChenu
2024-01-11 08:52 DenisChenu Status new => closed
2024-01-11 08:52 DenisChenu Resolution open => duplicate
2024-01-11 08:52 DenisChenu Note Added: 79143
2024-01-11 08:52 DenisChenu Bug heat 0 => 2
2024-01-11 08:54 DenisChenu Note Added: 79145
2024-01-16 06:41 evaluation2023 Status closed => feedback
2024-01-16 06:41 evaluation2023 Resolution duplicate => reopened
2024-01-16 06:41 evaluation2023 Note Added: 79171
2024-01-16 06:41 evaluation2023 Bug heat 2 => 4
2024-01-16 09:26 DenisChenu Assigned To DenisChenu => gabrieljenik
2024-01-16 09:26 DenisChenu Status feedback => closed