View Issue Details

This bug affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
07956Bug reportsSurvey takingpublic2013-10-09 18:05
ReporterNambu Assigned Toc_schmitz  
PrioritylowSeverityminor 
Status closedResolutionfixed 
Product Version2.00+ 
Fixed in Version2.00+ 
Summary07956: No Randomisation in Matrix questions with only two answers
Description

I had a matrix question with two pictures or two possible answers. I wanted those to be randomized, but it didn´t work at all. In the same survey I had a bigger matrix with ten answers and 14 lines in which the randomization worked.

Steps To Reproduce

Open a matrix question and give only two answer possibilities.

TagsNo tags attached.
Attached Files
Bug heat8
Complete LimeSurvey version number (& build)130611
I will donate to the project if issue is resolvedNo
BrowserMozilla Firefox
Database type & version111
Server OS (if known)111
Webserver software & version (if known)111
PHP Version111

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2013-06-26 18:23

developer   ~25666

Provide a litlle lss file showing this issue.

And remind : with only 2 answer you have good chance to have same order

Nambu

Nambu

2013-06-28 12:07

reporter   ~25686

I uploaded the file now. I know hat the chances are good to get the same order,but I tried it a couple of times. Kind Regards

DenisChenu

DenisChenu

2013-06-30 17:19

developer   ~25690

Last edited: 2013-06-30 17:28

We have:
SELECT * FROM {{questions}} WHERE parent_qid=12884 AND language='de' ORDER BY RAND()

Then sql issue .

This part is for dev i think (do the select without rand to have SQL caching).

<quote>RAND() is not meant to be a perfect random generator. It is a fast way to generate random numbers on demand that is portable between platforms for the same MySQL version. </quote>
http://dev.mysql.com/doc/refman/5.0/en/mathematical-functions.html#function_rand

Mazi

Mazi

2013-07-04 09:52

updater   ~25703

I can reproduce this issue but independently of the number of answer options.

Maybe we are just treating this wrong and the feature was meant to randomize the subquestions and not the columns?!

@Nambu, can you please attach the sample survey as LSS file with the question that worked fine for you?

DenisChenu

DenisChenu

2013-07-04 10:07

developer   ~25706

@Mazi :
Yes sub question (for a while):
SELECT * FROM {{questions}} WHERE parent_qid=12884 AND language='de' ORDER BY RAND()

c_schmitz

c_schmitz

2013-10-07 16:10

administrator   ~26591

Yes, this is a misunderstanding. Randomize answers does mean subquestions in this case. I updated the documentation and will change the label text, too.

c_schmitz

c_schmitz

2013-10-07 16:11

administrator   ~26592

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=13160

c_schmitz

c_schmitz

2013-10-09 11:22

administrator   ~26661

2.00+ Build 121009 released

c_schmitz

c_schmitz

2013-10-09 18:05

administrator   ~26681

Fix committed to 2.05 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&amp;id=13213

Related Changesets

LimeSurvey: master 6eb44795

2013-10-07 14:10:56

c_schmitz

Details Diff
Fixed issue 07956: No randomisation in Matrix questions with only two answer options Affected Issues
07956
mod - application/helpers/common_helper.php Diff File

LimeSurvey: 2.05 90fb89cb

2013-10-09 16:04:52

c_schmitz

Details Diff
Fixed issue 07956: No randomisation in Matrix questions with only two answer options Affected Issues
07956
mod - application/helpers/common_helper.php Diff File

Issue History

Date Modified Username Field Change
2013-06-26 17:25 Nambu New Issue
2013-06-26 18:23 DenisChenu Note Added: 25666
2013-06-26 18:23 DenisChenu View Status private => public
2013-06-28 12:06 Nambu File Added: limesurvey_question_18505.lsq
2013-06-28 12:07 Nambu Note Added: 25686
2013-06-30 17:19 DenisChenu Note Added: 25690
2013-06-30 17:28 DenisChenu Note Edited: 25690
2013-06-30 17:28 DenisChenu Note Edited: 25690
2013-07-04 09:52 Mazi Note Added: 25703
2013-07-04 10:07 DenisChenu Note Added: 25706
2013-09-24 15:14 c_schmitz Assigned To => c_schmitz
2013-09-24 15:14 c_schmitz Status new => assigned
2013-10-07 16:10 c_schmitz Note Added: 26591
2013-10-07 16:11 c_schmitz Changeset attached => LimeSurvey master 6eb44795
2013-10-07 16:11 c_schmitz Note Added: 26592
2013-10-07 16:11 c_schmitz Resolution open => fixed
2013-10-07 16:11 c_schmitz Status assigned => resolved
2013-10-07 16:11 c_schmitz Fixed in Version => 2.00+
2013-10-09 11:22 c_schmitz Note Added: 26661
2013-10-09 11:22 c_schmitz Status resolved => closed
2013-10-09 18:05 c_schmitz Changeset attached => LimeSurvey 2.05 90fb89cb
2013-10-09 18:05 c_schmitz Note Added: 26681