04157: Exporting results fails at dual scale question when using MS SQL Server

(11174)
ElMatador69 (administrator)
2010-02-25 17:36

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?

(11181)
Mazi (developer)
2010-02-26 00:24

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

(11278)
Mazi (developer)
2010-03-10 10:56

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

(11289)
c_schmitz (administrator)
2010-03-10 19:17

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!

(11313)
lemeur (administrator)
2010-03-12 23:03

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	=> ElMatador69
2010-02-25 17:09	Mazi	File Added: limesurvey_survey_18565-DUAL SCALE.csv
2010-02-25 17:09	Mazi	Additional Information Updated	View Revisions
2010-02-25 17:36	ElMatador69	Note Added: 11174
2010-02-26 00:24	Mazi	Note Added: 11181
2010-03-10 10:56	Mazi	Assigned To	ElMatador69 => 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)

Notes
(11174) ElMatador69 (administrator) 2010-02-25 17:36	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?

(11181) Mazi (developer) 2010-02-26 00:24	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

(11278) Mazi (developer) 2010-03-10 10:56	Carsten, you are the only dev I know having MS SQL for testing. Can you take a look? Thanks!

(11289) c_schmitz (administrator) 2010-03-10 19:17	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!

(11313) lemeur (administrator) 2010-03-12 23:03	Fixed in rev 8480.

Relationships