View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
06156Bug reportsData Entry (non public)public2012-06-08 13:46
ReporterRBornat Assigned ToMazi  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00RC2 
Fixed in Version2.00RC2 
Summary06156: Can't save multiple-choice question with more than one subquestion
Description

Question is constructed from

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:

(subquestions)

a=20 b=0
a=20 b=20
a=0 b=10
a=10 b=10
a=30 b=20
a=30 b=0
a=10 b=30
a=0 b=30
a=10 b=20
a=20 b=10

(other)
any other values for a and b:

Steps To Reproduce

options multiple choice with other plus randomise on setting up survey;

insert question text; quick add subquestions (or add them one by one, it makes no difference).

Save question. Error message is

SQLSTATE[42602]: Invalid name: 7 ERROR: invalid name syntax

Error is on line 535

532 public function getLastInsertID($sequenceName='')
533 {
534 $this->setActive(true);
535 return $this->_pdo->lastInsertId($sequenceName);
536 }

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

Mazi

Mazi

2012-06-04 16:02

updater   ~19056

Please attach your survey for testing.
Thanks!

Mazi

Mazi

2012-06-07 14:45

updater   ~19110

I'm still not sure how to reproduce this issue. Please attach a sample survey.

RBornat

RBornat

2012-06-08 13:43

reporter   ~19119

in 200RC2 it just worked ok. (It had failed several times in 200RC1, but no matter).

Mazi

Mazi

2012-06-08 13:45

updater   ~19120

Thanks for your feedback.

Issue History

Date Modified Username Field Change
2012-05-31 15:56 RBornat New Issue
2012-06-04 16:02 Mazi Note Added: 19056
2012-06-04 16:02 Mazi Assigned To => Mazi
2012-06-04 16:02 Mazi Status new => feedback
2012-06-07 14:45 Mazi Note Added: 19110
2012-06-08 13:43 RBornat Note Added: 19119
2012-06-08 13:43 RBornat Status feedback => assigned
2012-06-08 13:45 Mazi Note Added: 19120
2012-06-08 13:46 Mazi Status assigned => closed
2012-06-08 13:46 Mazi Resolution open => fixed
2012-06-08 13:46 Mazi Fixed in Version => 2.00RC2