View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
13632 | Bug reports | Import/Export | public | 2018-04-24 15:07 | 2019-08-27 15:00 |
Reporter | ollehar | Assigned To | LimeBot | ||
Priority | none | Severity | block | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.7.x | ||||
Fixed in Version | 3.17.x | ||||
Summary | 13632: 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 | ||||
Steps To Reproduce |
| ||||
Additional Information | Would be nice if anyone else could confirm this problem. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 12 | ||||
Complete LimeSurvey version number (& build) | master | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | - | ||||
Database type & version | psql (PostgreSQL) 10.3 (Ubuntu 10.3-1.pgdg14.04+1) | ||||
Server OS (if known) | - | ||||
Webserver software & version (if known) | - | ||||
PHP Version | 7.1 | ||||
Imported with success, last GIT |
|
Yeah, it only fails on latest postgres. Thanks for testing, Denis. |
|
maybe we should just raise the minimal psql version? |
|
|
|
maybe we should just down the maximal psgsql version? |
|
@olle : you don't fix it ? |
|
I don't have time to fix it. |
|
But i think you already fixed ? I remind to see a fix ??? I'm mad or not ? |
|
Did not touch this. |
|
@ollehar & @DenisChenu are there any updates on this one? |
|
Nothing from me. Maybe assign it to someone responsible for LimeSurvey? ;) |
|
I will create an installation of LS with postgre DB and test it (fix it if possible). |
|
@DenisChenu it actually works in the newer version of LS3 (3.17.13). So i think it's already fixed !! |
|
@eddylackmann : don't found time myself to test on PostgreSQL 10 and up :) i only check on pgsql 9 where it's OK. |
|
Works fine on PostgreSQl 10 |
|
@DenisChenu so will close this ticket. Or did you wanna try it by yourself ? |
|
Ask at @ollehar : i never checked or report this bug … |
|
I have $ psql -V Will test now. |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2018-04-24 15:07 | ollehar | New Issue | |
2018-04-24 15:07 | ollehar | File Added: limesurvey_survey_259743.lss | |
2018-04-24 15:20 | DenisChenu | Note Added: 47511 | |
2018-04-26 11:45 | ollehar | Note Added: 47541 | |
2018-05-11 22:31 | caseylucas | Issue Monitored: caseylucas | |
2018-05-16 12:14 |
|
Note Added: 47614 | |
2018-05-16 12:15 | ollehar | Note Added: 47615 | |
2018-05-16 12:15 | ollehar | Note Edited: 47615 | |
2018-05-16 12:43 |
|
Note Added: 47623 | |
2018-05-18 10:06 | DenisChenu | Note Added: 47674 | |
2018-05-18 10:18 | ollehar | Note Added: 47679 | |
2018-05-18 13:21 | DenisChenu | Note Added: 47683 | |
2018-05-18 15:15 | ollehar | Note Added: 47686 | |
2019-07-11 15:04 | cdorin | Assigned To | => cdorin |
2019-07-11 15:04 | cdorin | Status | new => feedback |
2019-07-11 15:04 | cdorin | Note Added: 52834 | |
2019-07-11 15:24 | ollehar | Note Added: 52841 | |
2019-07-11 15:24 | ollehar | Status | feedback => assigned |
2019-08-08 17:19 | cdorin | Assigned To | cdorin => LimeBot |
2019-08-27 11:36 | LimeBot | Note Added: 53286 | |
2019-08-27 14:37 | LimeBot | Status | assigned => feedback |
2019-08-27 14:37 | LimeBot | Note Added: 53293 | |
2019-08-27 14:43 | DenisChenu | Note Added: 53295 | |
2019-08-27 14:46 | LimeBot | File Added: postgreSql.PNG | |
2019-08-27 14:46 | LimeBot | File Added: survey import.PNG | |
2019-08-27 14:46 | LimeBot | Note Added: 53297 | |
2019-08-27 14:48 | LimeBot | Note Added: 53298 | |
2019-08-27 14:49 | DenisChenu | Note Added: 53299 | |
2019-08-27 14:50 | ollehar | Note Added: 53300 | |
2019-08-27 14:50 | ollehar | Status | feedback => assigned |
2019-08-27 15:00 | LimeBot | Status | assigned => closed |
2019-08-27 15:00 | LimeBot | Resolution | open => fixed |
2019-08-27 15:00 | LimeBot | Fixed in Version | => 3.17.x |
2021-08-09 12:21 | guest | Bug heat | 10 => 12 |