View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
06157Bug reportsData Entry (non public)public2012-06-20 14:05
ReporterRBornat Assigned Tomdekker  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00RC2 
Fixed in Version2.00RC3 
Summary06157: random answer order doesn't work with postgresql
Description

multiple choice question, randomize once, two columns, preview question gives error

Steps To Reproduce

multiple choice question, randomize once, two columns:

question:
Read the following statements and tick the box next to the correct answer below.

int a=10;
int b=20;

a=b;

The new values of a and b:

subquestion:
a=20 b=0

other:
any other values for a and b:

try preview question. Result is error

Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42601]: Syntax error: 7 ERROR: non-integer constant in ORDER BY LINE 1: ...t_qid=5 AND scale_id=0 AND language='en' ORDER BY 0.98433262... ^. The SQL statement executed was: SELECT * FROM lime_questions WHERE parent_qid=5 AND scale_id=0 AND language='en' ORDER BY 0.98433262883484

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)120510
I will donate to the project if issue is resolvedNo
Browsersafari
Database type & versionpostgresql 9.1.3
Server OS (if known)OS X Lion
Webserver software & version (if known)OS X Lion
PHP VersionOS X Lion

Users monitoring this issue

There are no users monitoring this issue.

Activities

mdekker

mdekker

2012-06-01 10:07

reporter   ~19022

In 1.92 db_random returns the random function name to use for the used db-adapter, while in Yii it returns a random number. There seems to be no abstraction-layer present in Yii that could handle this. It seems there already is an exception for mssql / sqlsrv, so I would suggest to implement our own switch here, what db types do we support?

mdekker

mdekker

2012-06-01 10:22

reporter   ~19023

Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8600

mdekker

mdekker

2012-06-01 10:26

reporter   ~19024

Fix committed to Yii branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8602

mdekker

mdekker

2012-06-01 10:44

reporter   ~19025

Fixed. Thanks for the report!

I also removed of the randomization options: Randomize once on survey start as that doesn't work. If you use that in your survey, please set if to something else before upgrading.

c_schmitz

c_schmitz

2012-06-20 14:05

administrator   ~19378

2.0RC3 released

Related Changesets

LimeSurvey: Yii 15ee7929

2012-06-01 01:18:21

mdekker

Details Diff
Fixed 06157: Random answer order doesn't work with postgresql Affected Issues
06157
mod - application/helpers/database_helper.php Diff File

LimeSurvey: Yii baabd42d

2012-06-01 01:24:26

mdekker

Details Diff
Fixed 06157: Random answer order doesn't work with postgresql
dev: forgot some breaks
Affected Issues
06157
mod - application/helpers/database_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-05-31 16:00 RBornat New Issue
2012-06-01 10:07 mdekker Note Added: 19022
2012-06-01 10:07 mdekker Assigned To => c_schmitz
2012-06-01 10:07 mdekker Status new => feedback
2012-06-01 10:17 mdekker Summary can't preview question => random answer order doesn't work with postgresql
2012-06-01 10:22 mdekker Assigned To c_schmitz => mdekker
2012-06-01 10:22 mdekker Status feedback => assigned
2012-06-01 10:22 mdekker Changeset attached => LimeSurvey Yii 15ee7929
2012-06-01 10:22 mdekker Note Added: 19023
2012-06-01 10:22 mdekker Resolution open => fixed
2012-06-01 10:26 mdekker Changeset attached => LimeSurvey Yii baabd42d
2012-06-01 10:26 mdekker Note Added: 19024
2012-06-01 10:44 mdekker Note Added: 19025
2012-06-01 10:44 mdekker Status assigned => resolved
2012-06-01 10:44 mdekker Fixed in Version => 2.00RC3
2012-06-20 14:05 c_schmitz Note Added: 19378
2012-06-20 14:05 c_schmitz Status resolved => closed