View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
19509Bug reportsLabel setspublic2024-04-03 17:282024-04-03 17:30
Reporterriqcles Assigned To 
PrioritynoneSeveritycrash 
Status newResolutionopen 
Product Version6.4.x 
Summary19509: Labels - adding language - SQL Postgres error, when adding language
Description

if the label set code contains a character that is not alphanumeric when you choose to add an additional language you get an SQL error message

a video illustrates the problem encountered

https://drive.google.com/file/d/1odLKMPJXRta6ZqllGDczg-hdTvJYiagb/view?usp=sharing

Steps To Reproduce

Steps to reproduce

create a label set
replace the code of the first label for example with the number 1
save label set
edit the label set and add a language

Expected result

the added language appears
the label set is saved with the new language

Actual result

crash with SQL error message

500 : Erreur interne au serveur CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[42883]: Undefined function: 7 ERREUR: l'opérateur n'existe pas : character varying = integer
LINE 1: ... "lime_labels" "t" WHERE (lid = 5) AND ("t"."code"=1) LIMIT ...
^
HINT: Aucun opérateur ne correspond au nom donné et aux types d'arguments.
Vous devez ajouter des conversions explicites de type.
Une erreur interne est survenue quand le serveur Web traitait votre requête.

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)LimeSurvey Community Edition Version 6.5.2+240402
I will donate to the project if issue is resolvedNo
BrowserFirefox / Chrome
Database type & versionPostgresql 15
Server OS (if known)centos 7.9
Webserver software & version (if known)Apache/2.4. (CentOS) PHP/8.2
PHP VersionPHP Version 8.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

riqcles

riqcles

2024-04-03 17:30

reporter   ~79870

Sorry, this is the good link :

https://drive.google.com/file/d/1nBb4fwIcZ_6euF3wFG_STBuQ6Jw_6KXZ/view?usp=sharing

the other is for another bug that I will submit in a few minutes

Issue History

Date Modified Username Field Change
2024-04-03 17:28 riqcles New Issue
2024-04-03 17:30 riqcles Note Added: 79870
2024-04-03 17:30 riqcles Bug heat 0 => 2