View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
04416Bug reportsSurvey takingpublic2010-06-12 12:502010-07-11 23:38
Reporteruser8521Assigned Toc_schmitz  
PriorityurgentSeverityblock 
Status closedResolutionfixed 
Product Version1.87+ 
Fixed in Version1.90RC3 
Summary04416: Slider-layout and INSERTANS function
Description

When i try to retrieve the value from a question on the previous page using the INSERTANS-function, it doesn't work for the questions from type "multiple numerical" AND "using the slider layout". I works for all other types of questions.

Even when i simply try to print the value in the next page on the screen, the survey crashes and i get the next error message:

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 'AND language='nl'' at line 1:SELECT type, lid, lid1 FROM lime_questions WHERE qid= AND language='nl'

Steps To Reproduce
  1. Make a question. (Attribute-setting i don't mention, have default-values)
    • TYPE: multiple numerical input
    • USE SLIDER LAYOUT: "YES"
    • SLIDER ACCURACY: 1
    • SLIDER MAX VALUE: 10
    • TEXT SEPARATOR: :
    • DISPLAY MIN AND MAX: "YES"
    • SLIDER MIN VALUE: 1
    • ANSER OPTIONS:
      *option 1 :left text:right text
  2. USE {INSERTANS:SIDXGIDXQID} in a boilerplate question
Additional Information

We are using limeservice, so if it would make things easier for you, you can always have the coordinates to log in to the survey and see the problem yourself.

thank you already for a wonderful support!

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)1.78
I will donate to the project if issue is resolved
Browser
Database type & versionusing limeservice
Server OS (if known)using limeservice
Webserver software & version (if known)using limeservice
PHP Versionusing limeservice

Users monitoring this issue

There are no users monitoring this issue.

Activities

lemeur

lemeur

2010-06-20 08:10

developer   ~12266

I can't reproduce the problem: this is either already fixed in 1.90RC1 or related to somthing else.

Can you upload a test survey?

Regards,
Thibault
lemeur

lemeur

2010-06-29 21:37

developer   ~12316

Have you tried 1.90RC1 ?
If it is still there please upload a test survey cause I st(ill can't reproduce.
lemeur

lemeur

2010-07-07 18:35

developer   ~12373

@solid,
Please give feedback if you want us to fix this issue.

Regards,
Thibault
lemeur

lemeur

2010-07-10 18:49

developer   ~12382

@solid, please give feedback or I'll have to close the ticket.
c_schmitz

c_schmitz

2010-07-11 23:38

administrator   ~12384

Last edited: 2010-07-11 23:38

User used a code for a non-existing question which created the error.
I fixed the error handling a couple revisions ago.

Issue History

Date Modified Username Field Change
2010-06-12 12:50 user8521 New Issue
2010-06-12 12:50 user8521 Status new => assigned
2010-06-12 12:50 user8521 Assigned To => user372
2010-06-17 00:34 c_schmitz Assigned To user372 => lemeur
2010-06-20 08:10 lemeur Note Added: 12266
2010-06-20 08:10 lemeur Status assigned => feedback
2010-06-29 21:37 lemeur Note Added: 12316
2010-07-07 18:35 lemeur Note Added: 12373
2010-07-10 18:49 lemeur Note Added: 12382
2010-07-11 23:38 c_schmitz Note Added: 12384
2010-07-11 23:38 c_schmitz Status feedback => closed
2010-07-11 23:38 c_schmitz Assigned To lemeur => c_schmitz
2010-07-11 23:38 c_schmitz Resolution open => fixed
2010-07-11 23:38 c_schmitz Fixed in Version => 1.90RC3
2010-07-11 23:38 c_schmitz Note Edited: 12384
2010-10-25 00:18 c_schmitz Category Survey at Runtime => Survey taking