View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 8
IDProjectCategoryView StatusDate SubmittedLast Update
04157Bug reportsOtherpublic2010-02-25 17:092010-03-19 17:02
ReporterMazi Assigned Tolemeur  
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version1.87+ 
Target Version1.87+Fixed in Version1.87+ 
Summary04157: Exporting results fails at dual scale question when using MS SQL Server
Description

I tried to export results of a survey to Excel but it failed with an SQL error. I could track down the error to the dual scale question type. The error message is found inside the XLS document and says:
"[Microsoft][ODBC SQL Server Driver][SQL Server]Die 'lime_answers.qid'-Spalte ist in der Auswahlliste ungültig, da sie nicht in einer Aggregatfunktion und nicht in der GROUP BY-Klausel enthalten ist.:select a., l., l.code as lcode, l.title as ltitle from lime_answers as a, lime_labels as l where qid=1155 AND l.lid =70 AND a.language='en' AND l.code = ? group by l.lid"

Steps To Reproduce

I attached a sample survey. Just import it, activate the survey, fill it out once and then go to export results. It doesn't matter which format you choose, all export formats fail.

Additional Information

I also tested at MySQL, there are no errors, so it's probably just an invalid SQL statement.

TagsNo tags attached.
Attached Files
limesurvey_survey_18565-DUAL SCALE.csv (4,882 bytes)
Bug heat8
Complete LimeSurvey version number (& build)8888
I will donate to the project if issue is resolved
BrowserFF3
Database type & versionMS SQL Server 2005
Server OS (if known)Win XP Sp 3
Webserver software & version (if known)Apache 2.2
PHP Version5.2.11

Users monitoring this issue

There are no users monitoring this issue.

Activities

user372

2010-02-25 17:36

  ~11174

Which LimeSurvey build do you use? On my knowledge this issue has already been fixed in the latest stable plus release.

Can you tell us, if you can reproduce the issue on the latest build?
Mazi

Mazi

2010-02-26 00:24

updater   ~11181

I can still reproduce the problem if there is at least one answer given:
[Microsoft][ODBC SQL Server Driver][SQL Server]Die 'lime_answers.qid'-Spalte ist in der Auswahlliste ungültig, da sie nicht in einer Aggregatfunktion und nicht in der GROUP BY-Klausel enthalten ist.:select a., l., l.code as lcode, l.title as ltitle from lime_answers as a, lime_labels as l where qid=1155 AND l.lid =70 AND a.language='en' AND l.code = ? group by l.lid
Mazi

Mazi

2010-03-10 10:56

updater   ~11278

Carsten, you are the only dev I know having MS SQL for testing. Can you take a look?
Thanks!
c_schmitz

c_schmitz

2010-03-10 19:17

administrator   ~11289

Hello Thibault,

this bug was introduced by your fix in rev. 6477.
Only MySQL allows that not all selected fields are in the GROUP statement too - all other DB types don't allow it since it is not SQL standard.

Can you please have a look at it? Thank you!
lemeur

lemeur

2010-03-12 23:03

developer   ~11313

Fixed in rev 8480.

Issue History

Date Modified Username Field Change
2010-02-25 17:09 Mazi New Issue
2010-02-25 17:09 Mazi Status new => assigned
2010-02-25 17:09 Mazi Assigned To => user372
2010-02-25 17:09 Mazi File Added: limesurvey_survey_18565-DUAL SCALE.csv
2010-02-25 17:09 Mazi Additional Information Updated
2010-02-25 17:36 user372 Note Added: 11174
2010-02-26 00:24 Mazi Note Added: 11181
2010-03-10 10:56 Mazi Assigned To user372 => c_schmitz
2010-03-10 10:56 Mazi Note Added: 11278
2010-03-10 19:15 c_schmitz Assigned To c_schmitz => lemeur
2010-03-10 19:17 c_schmitz Note Added: 11289
2010-03-12 23:03 lemeur Note Added: 11313
2010-03-12 23:03 lemeur Status assigned => resolved
2010-03-12 23:03 lemeur Fixed in Version => 1.87+
2010-03-12 23:03 lemeur Resolution open => fixed
2010-03-19 17:02 c_schmitz Status resolved => closed
2010-05-06 10:27 c_schmitz Category Import / Export => (No Category)