View Issue Details

IDProjectCategoryView StatusLast Update
13632Bug reports[All Projects] Import/Exportpublic2018-05-18 15:15
ReporterolleAssigned To 
PrioritynoneSeveritycrash 
Status newResolutionopen 
Product Version3.7.x 
Target VersionFixed in Version 
Summary13632: Can't import survey in postgres
Description

Trying to import a survey I get:

CDbCommand failed to execute the SQL statement: SQLSTATE[42P10]: Invalid column reference: 7 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ...d='259743' and parent_qid=0 GROUP BY qid ORDER BY question_o...
^. The SQL statement executed was: SELECT DISTINCT qid FROM "lime_questions" "t" WHERE sid=:sid and parent_qid=0 GROUP BY qid ORDER BY question_order

Steps To Reproduce
  1. Install master with postgres
  2. Import survey
  3. Crash
Additional Information

Would be nice if anyone else could confirm this problem.

TagsNo tags attached.
Complete LimeSurvey version number (& build)master
I will donate to the project if issue is resolvedNo
Browser-
Database & DB-Versionpsql (PostgreSQL) 10.3 (Ubuntu 10.3-1.pgdg14.04+1)
Operating System (Server)-
Webserver software & version-
PHP Version7.1

Activities

olle

olle

2018-04-24 15:07

administrator  

limesurvey_survey_259743.lss (410,323 bytes)
DenisChenu

DenisChenu

2018-04-24 15:20

developer   ~47511

Imported with success, last GIT
PHP : 5.6.35-1~dotdeb+7.1
pgsql 9.1.24lts2

olle

olle

2018-04-26 11:45

administrator   ~47541

Yeah, it only fails on latest postgres. Thanks for testing, Denis.

LouisGac

LouisGac

2018-05-16 12:14

manager   ~47614

maybe we should just raise the minimal psql version?

olle

olle

2018-05-16 12:15

administrator   ~47615

Last edited: 2018-05-16 12:15

View 2 revisions

@LouisGac, it's the other way around - it fails on the latest postgres version.

LouisGac

LouisGac

2018-05-16 12:43

manager   ~47623

maybe we should just down the maximal psgsql version?

DenisChenu

DenisChenu

2018-05-18 10:06

developer   ~47674

@olle : you don't fix it ?
@LouisGac : i prefer to remove msql support than pg ;)

olle

olle

2018-05-18 10:18

administrator   ~47679

I don't have time to fix it.

DenisChenu

DenisChenu

2018-05-18 13:21

developer   ~47683

But i think you already fixed ? I remind to see a fix ??? I'm mad or not ?

olle

olle

2018-05-18 15:15

administrator   ~47686

Did not touch this.

Issue History

Date Modified Username Field Change
2018-04-24 15:07 olle New Issue
2018-04-24 15:07 olle File Added: limesurvey_survey_259743.lss
2018-04-24 15:20 DenisChenu Note Added: 47511
2018-04-26 11:45 olle Note Added: 47541
2018-05-16 12:14 LouisGac Note Added: 47614
2018-05-16 12:15 olle Note Added: 47615
2018-05-16 12:15 olle Note Edited: 47615 View Revisions
2018-05-16 12:43 LouisGac Note Added: 47623
2018-05-18 10:06 DenisChenu Note Added: 47674
2018-05-18 10:18 olle Note Added: 47679
2018-05-18 13:21 DenisChenu Note Added: 47683
2018-05-18 15:15 olle Note Added: 47686