View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 10
IDProjectCategoryView StatusDate SubmittedLast Update
19509Bug reportsLabel setspublic2024-04-03 17:282024-06-24 13:17
Reporterriqcles Assigned Totibor.pacalat  
PrioritynoneSeveritycrash 
Status closedResolutionfixed 
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 heat10
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
gabrieljenik

gabrieljenik

2024-06-18 17:48

manager   ~80389

https://github.com/LimeSurvey/LimeSurvey/pull/3890
DenisChenu

DenisChenu

2024-06-21 15:32

developer   ~80417

@riqcles : I know you can test the fix :)
riqcles

riqcles

2024-06-21 16:51

reporter   ~80427

Yes... test is ok :)
guest

guest

2024-06-24 09:58

viewer   ~80431

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=36422
LimeBot

LimeBot

2024-06-24 13:17

administrator   ~80445

Fixed in Release 6.5.14+240624

Related Changesets

LimeSurvey: master 6a12ea84

2024-06-24 09:57:57

Gabriel Jenik


Committer: GitHub Details Diff 		Fixed issue 19509: Postgres error when adding language (03890)

Co-authored-by: lapiudevgit <devgit@lapiu.biz>		 Affected Issues
19509
mod - application/helpers/admin/label_helper.php Diff File

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
2024-06-03 12:48 tibor.pacalat Assigned To => gabrieljenik
2024-06-03 12:48 tibor.pacalat Status new => assigned
2024-06-18 17:48 gabrieljenik Assigned To gabrieljenik => DenisChenu
2024-06-18 17:48 gabrieljenik Status assigned => ready for code review
2024-06-18 17:48 gabrieljenik Note Added: 80389
2024-06-18 17:48 gabrieljenik Bug heat 2 => 4
2024-06-21 15:32 DenisChenu Assigned To DenisChenu => tibor.pacalat
2024-06-21 15:32 DenisChenu Status ready for code review => ready for testing
2024-06-21 15:32 DenisChenu Note Added: 80417
2024-06-21 15:32 DenisChenu Bug heat 4 => 6
2024-06-21 16:51 riqcles Note Added: 80427
2024-06-24 09:58 Changeset attached => LimeSurvey master 6a12ea84
2024-06-24 09:58 guest Note Added: 80431
2024-06-24 09:58 guest Bug heat 6 => 8
2024-06-24 09:58 tibor.pacalat Status ready for testing => resolved
2024-06-24 09:58 tibor.pacalat Resolution open => fixed
2024-06-24 13:17 LimeBot Note Added: 80445
2024-06-24 13:17 LimeBot Status resolved => closed
2024-06-24 13:17 LimeBot Bug heat 8 => 10