View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
15961Bug reportsSurvey editingpublic2020-03-08 10:422020-03-14 10:55
Reportermartialblog Assigned Toc_schmitz  
PriorityhighSeverityblock 
Status closedResolutionfixed 
Product Version4.1.7 
Summary15961: Postgres SQL Error when clicking on Questing List in new Survey
Description

After creating a new Survey on a fresh installation (with Postgres, LimeSurvey Version 4.1.7+200224), and then clicking on Question List an SQL Error occurs:

ERROR: syntax error at or near "group" at character 981
STATEMENT: SELECT "t"."qid" AS "t0_c0", "t"."parent_qid" AS "t0_c1", "t"."sid" AS "t0_c2", "t"."gid" AS "t0_c3", "t"."type" AS "t0_c4", "t"."title" AS "t0_c5", "t"."preg" AS "t0_c6", "t"."other" AS "t0_c7", "t"."mandatory" AS "t0_c8", "t"."encrypted" AS "t0_c9", "t"."question_order" AS "t0_c10", "t"."scale_id" AS "t0_c11", "t"."same_default" AS "t0_c12", "t"."relevance" AS "t0_c13", "t"."modulename" AS "t0_c14", "group"."gid" AS "t1_c0", "group"."sid" AS "t1_c1", "group"."group_order" AS "t1_c2", "group"."randomization_group" AS "t1_c3", "group"."grelevance" AS "t1_c4", "ql10n"."id" AS "t2_c0", "ql10n"."qid" AS "t2_c1", "ql10n"."question" AS "t2_c2", "ql10n"."help" AS "t2_c3", "ql10n"."script" AS "t2_c4", "ql10n"."language" AS "t2_c5" FROM "lime_questions" "t" LEFT OUTER JOIN "lime_groups" "group" ON ("t"."gid"="group"."gid") LEFT OUTER JOIN "lime_question_l10ns" "ql10n" ON ("ql10n"."qid"="t"."qid") WHERE ((t.sid='568752') AND (t.parent_qid='0')) AND (language='en') ORDER BY group.group_order asc, t.question_order asc LIMIT 10

character 981 starts here: "group.group_order asc, t.question_order asc LIMIT 10"

Error happens on both Posgres 9.6 and Postgres 10.

Used this Docker Image to recreated the issue: https://github.com/martialblog/docker-limesurvey

Steps To Reproduce
  1. Fresh Installation with Postgres
  2. Login
  3. Create a new Survey (no data but the name)
  4. In the Survey Menu click on Question List
Additional Information

$ psql --version
psql (PostgreSQL) 9.6.17

limesurvey=# \dx
List of installed extensions
Name | Version | Schema | Description
---------+---------+------------+------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language

$cat /etc/debian_version
10.2

$apache2 -v
Server version: Apache/2.4.38 (Debian)
Server built: 2019-10-15T19:53:42

$ php -v
PHP 7.2.26 (cli) (built: Dec 28 2019 22:10:00) ( NTS )
Copyright (c) 1997-2018 The PHP Group

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build) Version 4.1.7+200224
I will donate to the project if issue is resolvedNo
BrowserFirefox 73.0
Database type & versionPostgreSQL 9.6.17
Server OS (if known)Debian 10.2
Webserver software & version (if known)Apache/2.4.38
PHP VersionPHP 7.2.26

Users monitoring this issue

There are no users monitoring this issue.

Activities

ollehar

ollehar

2020-03-09 10:23

administrator   ~56363

Thanks for reporting, will check.
c_schmitz

c_schmitz

2020-03-14 10:55

administrator   ~56537

Please update to the latest version and try again. Thank you.

Issue History

Date Modified Username Field Change
2020-03-08 10:42 martialblog New Issue
2020-03-09 10:23 ollehar Note Added: 56363
2020-03-09 12:34 ollehar Priority none => high
2020-03-14 10:55 c_schmitz Assigned To => c_schmitz
2020-03-14 10:55 c_schmitz Status new => closed
2020-03-14 10:55 c_schmitz Resolution open => fixed
2020-03-14 10:55 c_schmitz Note Added: 56537