View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
19363Bug reportsSurvey editingpublic2024-01-19 02:482024-01-19 10:12
Reportergonzalezha Assigned Togabrieljenik  
PrioritynoneSeveritypartial_block 
Status closedResolutionduplicate 
Product Version6.4.x 
Summary19363: Error at saving “Array (Texts)” question on MSSQL
Description

When I´m working with array questions, if I insert a new subquestion in Y-Scale or X-Scale and then I click on the Save button, suddenly appear the next error message.
CDbCommand failed to execute the SQL statement: SQLSTATE[22018]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'new81629' to data type int.

Steps To Reproduce

Steps to reproduce

  1. Create a new survey.
  2. Then go to Structure and add a new array(texts) question.
  3. Insert a new subquestion in y-scale or x-scale.
  4. Finally click on Save.

Expected result

The question saved correctly.

Actual result

Shows the error message:
CDbCommand failed to execute the SQL statement: SQLSTATE[22018]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the nvarchar value 'new81629' to data type int.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)LimeSurvey Community Edition Version 6.4.0+231218
I will donate to the project if issue is resolvedNo
Browser
Database type & versionmssql 2016
Server OS (if known)
Webserver software & version (if known)IIS
PHP Version8.2.13

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2024-01-19 10:11

developer   ~79224

Not same DB, but near same issue (related to same newXXX sent to search)

Issue History

Date Modified Username Field Change
2024-01-19 02:48 gonzalezha New Issue
2024-01-19 10:11 DenisChenu Note Added: 79224
2024-01-19 10:11 DenisChenu Bug heat 0 => 2
2024-01-19 10:12 DenisChenu Assigned To => gabrieljenik
2024-01-19 10:12 DenisChenu Status new => closed
2024-01-19 10:12 DenisChenu Resolution open => duplicate