View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
15735Bug reportsSurvey editingpublic2020-01-17 13:152020-01-28 17:44
Reporterwarpinwolf Assigned Toollehar  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version4.0.0-RC14 
Summary15735: Questions can't be saved
Description

Debian Buster
PHP 7.3
Apache 2.4
Postgresql 12.1
limesurvey400 200116.tar.gz (not sure what the actual product version is based upon this download)

psql:> create user ls-db-user with createdb login password '***';
psql:> create database limesurvey with owner = ls-db-user;
psql:> grant all on database limesurvey to ls-db-user;

psql --list
Name | Owner | Encoding | Collate | Ctype | Access privileges
limesurvey | ls-db-user | UTF8 | de_DE.utf8 | de_DE.utf8 | =Tc/ls-db-user +
| | | | | ls-db-user=CTc/ls-db-user

Create a new survey; create question group; create a question -->
Question has been stored, but an error happened: CDbCommand failed to execute the SQL statement: SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ungültige Eingabesyntax für ganze Zahl: »« LINE 1: ...("defaultValueL10ns"."dvid"="t"."dvid") WHERE ("t"."qid"='') ^

Steps To Reproduce

Login as admin
Create a new survey
Survey title: X
Base language: Russian
Date format dd.mm.yyyyy
Save
--> Structure: Add group
Title: X
Save
--> Questionlist: Create question
--> https://servername/limesurvey/index.php/admin/questioneditor/sa/view/surveyid/579365/gid/

500: Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ungültige Eingabesyntax für ganze Zahl: »«
LINE 1: SELECT * FROM "lime_groups" "t" WHERE gid='' LIMIT 1
^

Browser BACK
Browser PAGE REFRESH
--> Questionlist: Create question
Question type: short free text
Question: X
Save
--> Red banner

Question has been stored, but an error happened: CDbCommand failed to execute the SQL statement: SQLSTATE[22P02]: Invalid text representation: 7 FEHLER: ungültige Eingabesyntax für ganze Zahl: »« LINE 1: ...("defaultValueL10ns"."dvid"="t"."dvid") WHERE ("t"."qid"='') ^

TagsNo tags attached.
Attached Files
image.png (28,465 bytes)   
image.png (28,465 bytes)   
Bug heat8
Complete LimeSurvey version number (& build)Version 4.0.0+200116
I will donate to the project if issue is resolvedNo
BrowserChrome & Chromium
Database type & versionPostgreSQL 12.1 (Debian 12.1-1.pgdg90+1)
Server OS (if known)Debian Buster
Webserver software & version (if known)Apache/2.4.25 (Debian) Server built: 2019-10-13T15:43:54
PHP VersionPHP 7.3.13-1+0~20191218.50+debian9~1.gbp23c2da (cli) (built: Dec 18 2019 15:03:24) ( NTS )

Users monitoring this issue

DenisChenu

Activities

warpinwolf

warpinwolf

2020-01-17 13:58

reporter   ~55346

Don't know whether this is relevant - I remember a bug in picocms/nextcloud affected by this:
The Postgresql Documentention (https://www.postgresql.org/docs/current/sql-update.html) says:
The name of a column in the table named by 'table_name' . The column name can be qualified with a subfield name or array subscript, if needed.

===> Do not include the table's name in the specification of a target column — for example, 'UPDATE table_name SET table_name.col = 1' is invalid.
ollehar

ollehar

2020-01-24 14:49

administrator   ~55462

Cannot reproduce with Postgres 12. Which question did you try to save? How did you install LimeSurvey?
ollehar

ollehar

2020-01-24 14:55

administrator   ~55463

Sorry, yes, I can reproduce when base language is Russian.
ollehar

ollehar

2020-01-24 15:39

administrator   ~55465

Fix on branch bug/15735-cannot-save-question-on-postgres
ollehar

ollehar

2020-01-28 11:34

administrator   ~55494

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

lime_release_bot

2020-01-28 17:44

administrator   ~55540

Fixed in Release 4.1.0+200128

Related Changesets

LimeSurvey: master 7aa8973d

2020-01-24 15:33:47

ollehar


Committer: LimeBot Details Diff 		Fixed issue 15735: Questions can't be saved on postgres Affected Issues
15735
mod - application/controllers/admin/limereplacementfields.php Diff File

Issue History

Date Modified Username Field Change
2020-01-17 13:15 warpinwolf New Issue
2020-01-17 13:15 warpinwolf File Added: image.png
2020-01-17 13:52 ollehar Description Updated
2020-01-17 13:52 ollehar Steps to Reproduce Updated
2020-01-17 13:58 warpinwolf Note Added: 55346
2020-01-20 09:18 cdorin Assigned To => cdorin
2020-01-20 09:18 cdorin Status new => assigned
2020-01-24 08:29 DenisChenu Issue Monitored: DenisChenu
2020-01-24 14:49 ollehar Note Added: 55462
2020-01-24 14:49 ollehar Status assigned => feedback
2020-01-24 14:55 ollehar Note Added: 55463
2020-01-24 14:55 ollehar Status feedback => confirmed
2020-01-24 15:39 ollehar Note Added: 55465
2020-01-24 15:39 ollehar Status confirmed => ready for testing
2020-01-28 11:34 LimeBot Changeset attached => LimeSurvey master 7aa8973d
2020-01-28 11:34 ollehar Note Added: 55494
2020-01-28 11:34 ollehar Assigned To cdorin => ollehar
2020-01-28 11:34 ollehar Resolution open => fixed
2020-01-28 17:44 lime_release_bot Note Added: 55540
2020-01-28 17:44 lime_release_bot Status ready for testing => closed
2021-08-03 03:31 guest Bug heat 6 => 8