View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
04337Bug reportsSurvey takingpublic2010-05-12 14:502010-05-21 19:05
Reportertankbay Assigned Touser372 
PriorityurgentSeverityblock 
Status closedResolutionfixed 
Product Version1.87+ 
Fixed in Version1.90RC1 
Summary04337: Using the "Previous" button to go back to a hidden question crashes the app with SQL error
Description

The first question in our survey is a hidden question using the built in hide function. This question is populated by passing the value (an organisation ID) into this question using the calling url. This all works fine.

When you go on to complete a question or two (does not matter how many) and then use the "Previous" button in LS to go back, it will crash if a user goes back to the start of the survey.

Steps To Reproduce

1) Create hidden question.
2) Add more visible questions.
3) Run survey.
4) Use "Previous" button in app to keep going back. When you hit the hidden question it will crash.

Additional Information

Error= "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'group by type' at line 1:SELECT type FROM compass_questions WHERE qid= group by type"

Question type is short text.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)8518
I will donate to the project if issue is resolved
BrowserFF 3.6.3 on Mac OSX Snow Leopard + FF & IE 8 on Win Vista and Win 7
Database type & versionMySQL 5.0.77
Server OS (if known)Centos 5.4
Webserver software & version (if known)Apache 2.2.3
PHP Version5.1.6

Relationships

Relationship GraphDependency Graph
duplicate of 04333 closedlemeur "Previous" button, used from second question, gives SQL error when first question is hidden 

Users monitoring this issue

There are no users monitoring this issue.

Activities

lemeur

lemeur

2010-05-12 23:35

developer   ~11800

should be fixed in rev 8713.
tankbay

tankbay

2010-05-12 23:58

reporter   ~11801

Excellent work lemeur - very quick turnaround!

Any idea of the release date for 8713?

Regards,

Jon (Tankbay)
lemeur

lemeur

2010-05-13 09:38

developer   ~11803

Usually we release a new version once a week during the testing phase (betat then RC releases) and even during the stable phase (stable plus release).

Regards,

Thibault
lemeur

lemeur

2010-05-21 19:05

developer   ~11925

1.90 beta3 release

Issue History

Date Modified Username Field Change
2010-05-12 14:50 tankbay New Issue
2010-05-12 14:50 tankbay Status new => assigned
2010-05-12 14:50 tankbay Assigned To => user372
2010-05-12 22:11 lemeur Relationship added duplicate of 04333
2010-05-12 23:35 lemeur Note Added: 11800
2010-05-12 23:35 lemeur Status assigned => resolved
2010-05-12 23:35 lemeur Fixed in Version => 1.90RC1
2010-05-12 23:35 lemeur Resolution open => fixed
2010-05-12 23:58 tankbay Note Added: 11801
2010-05-13 09:38 lemeur Note Added: 11803
2010-05-21 19:05 lemeur Note Added: 11925
2010-05-21 19:05 lemeur Status resolved => closed
2010-10-25 00:18 c_schmitz Category Survey at Runtime => Survey taking