View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
17523Bug reportsImport/Exportpublic2021-08-18 14:562021-08-18 16:50
Reporterzufolo441 Assigned Togalads  
PrioritynoneSeveritypartial_block 
Status closedResolutionduplicate 
Product Version5.x 
Summary17523: error in SQL exporting answers
Description

hi,
When I try to export answers I obtain this error:

CDbCommand failed to execute the SQL statement: SQLSTATE[42803]: Grouping error: 7 ERROR: column "lime_survey_543839.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 5: ORDER BY "lime_survey_543839"."id" ASC

Steps To Reproduce

go to https://XXX/index.php/admin/export/sa/exportresults/surveyid/543839

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)5.1.3
I will donate to the project if issue is resolvedNo
BrowserFirefox 91
Database type & versionPostgreSQL 12
Server OS (if known)FreeBSD 13.0
Webserver software & version (if known)Apache 2.4
PHP Version7.4

Relationships

Relationship GraphDependency Graph
duplicate of 17522 closedollehar CDbCommand failed to execute the SQL statement: SQLSTATE[42803] 

Users monitoring this issue

There are no users monitoring this issue.

Activities

nooblag

nooblag

2021-08-18 14:58

reporter   ~66051

Could be related to 17522?
galads

galads

2021-08-18 16:50

reporter   ~66053

Duplicate to 17522

Issue History

Date Modified Username Field Change
2021-08-18 14:56 zufolo441 New Issue
2021-08-18 14:58 nooblag Note Added: 66051
2021-08-18 14:58 nooblag Bug heat 0 => 2
2021-08-18 16:50 galads Assigned To => galads
2021-08-18 16:50 galads Status new => closed
2021-08-18 16:50 galads Resolution open => duplicate
2021-08-18 16:50 galads Note Added: 66053
2021-08-18 16:50 galads Bug heat 2 => 4
2021-08-18 16:50 galads Relationship added duplicate of 17522