View Issue Details

Jump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
03459Bug reportsSurvey takingpublic2009-07-09 12:362009-07-29 11:11
Reporterlevel420 Assigned Tojcleeland  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.85+ 
Fixed in Version1.85+ 
Summary03459: Using a "lower than" > character as code within label set leads to a save error in the end user survey form
Description

I've created a survey which uses two label sets within a question of type "Array (Flexible Labels) dual scale and attribute "Dual Dropdown".

Within one of the used label sets where a user can choose from a range of procent values there is an selecteable option which says "lower than 10%". For this value i used the code "<10".

If a end user chooses "lower than 10%" and navigates to the next page or ends the survey an Error is displayed in the "end of survey page":

"Not saved.
An unexptected error occured. Your answer could not be saved.
Your answers are not lost. They have been mailed to the administratore of this survey and will be entered later manually to the database."

(Sorry, translated from german to english).

An error message is sent to the admin mail address with the error message.

As soon as the label set code for "lower than 10%" is changed from <10 to lt.10 everything works as expected.

"

TagsNo tags attached.
Attached Files
bug_limesurvey_survey_export.csv (4,512 bytes)
limesurvey_labelset_drugs.csv (600 bytes)
limesurvey_labelset_percent.csv (627 bytes)
Bug heat6
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
Browser
Database type & versionmysql 5.0.45
Server OS (if known)suse linux 10.3
Webserver software & version (if known)apache 2.2
PHP Version5.2.6 with Suhosin-Patch 0.9.6.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

level420

level420

2009-07-09 12:40

reporter   ~08807

Last edited: 2009-07-09 12:41

With some tests and moves I managed to retreive the following error message via email after a failed survey save. Please note the unbalanced string ticks within the VALUES part of the sql insert statement:

VALUES ('Mi', ', 'No', '25-50'

After the starting tick of the second value the code <10 should appear.

Here is the mailed message (in german):

Beim Speichern Ihrer Fragebogen-Zugangsschlüssels ist ein Fehler aufgetreten. Fragebogen zur medikamentöse Prämedikation und Analgesie ambulanter und tagesstationärer Patienten - 64369

EINZUGEBENDE DATEN:
64369X26X102tbl#0: Mi
64369X26X102tbl#1: 75
64369X26X103tbl_typD: 1
64369X26X103tbl_vonD: 1
64369X26X103tbl_bisD: 1
64369X26X103iv_typD: 2
64369X26X103iv_vonD: 2
64369X26X103iv_bisD: 2
64369X26X103rect_typD: 3
64369X26X103rect_vonD: 3
64369X26X103rect_bisD: 3
64369X26X103saft_typD: 4
64369X26X103saft_vonD: 4
64369X26X103saft_bisD: 4
64369X26X108ander_typD:
64369X26X108ander_vonD:
64369X26X108ander_bisD:
64369X26X108ander_app:
64369X26X108ander_subst:
64369X26X108ander_regel:
64369X26X108ander_typD:
64369X26X108ander_vonD:
64369X26X108ander_bisD:
64369X26X104tbl#0:
64369X26X104tbl#1:
64369X26X104iv#0:
64369X26X104iv#1:
64369X26X104rect#0:
64369X26X104rect#1:
64369X26X104saft#0:
64369X26X104saft#1:
64369X26X105tbl_typD:
64369X26X105tbl_vonD:
64369X26X105tbl_bisD:
64369X26X105tbl_app:
64369X26X105tbl_subst:
64369X26X105tbl_regel:
64369X26X105tbl_typD:
64369X26X105tbl_vonD:
64369X26X105tbl_bisD:
64369X26X105tbl_typD:
64369X26X105tbl_vonD:
64369X26X105tbl_bisD:
64369X26X105iv_typD:
64369X26X105iv_vonD:
64369X26X105iv_bisD:
64369X26X105iv_app:
64369X26X105iv_subst:
64369X26X105iv_regel:
64369X26X105iv_typD:
64369X26X105iv_vonD:
64369X26X105iv_bisD:
64369X26X105iv_typD:
64369X26X105iv_vonD:
64369X26X105iv_bisD:
64369X26X105rect_typD:
64369X26X105rect_vonD:
64369X26X105rect_bisD:
64369X26X105rect_app:
64369X26X105rect_subst:
64369X26X105rect_regel:
64369X26X105rect_typD:
64369X26X105rect_vonD:
64369X26X105rect_bisD:
64369X26X105rect_typD:
64369X26X105rect_vonD:
64369X26X105rect_bisD:
64369X26X105saft_typD:
64369X26X105saft_vonD:
64369X26X105saft_bisD:
64369X26X105saft_app:
64369X26X105saft_subst:
64369X26X105saft_regel:
64369X26X105saft_typD:
64369X26X105saft_vonD:
64369X26X105saft_bisD:
64369X26X105saft_typD:
64369X26X105saft_vonD:
64369X26X105saft_bisD:
64369X26X109ander_typD:
64369X26X109ander_vonD:
64369X26X109ander_bisD:
64369X26X109ander_app:
64369X26X109ander_subst:
64369X26X109ander_regel:
64369X26X109ander_typD:
64369X26X109ander_vonD:
64369X26X109ander_bisD:
64369X26X109ander_typD:
64369X26X109ander_vonD:
64369X26X109ander_bisD:
64369X26X109ander_app:
64369X26X109ander_subst:
64369X26X109ander_regel:
64369X26X109ander_typD:
64369X26X109ander_vonD:
64369X26X109ander_bisD:
64369X26X106tbl#0:
64369X26X106tbl#1:
64369X26X106iv#0:
64369X26X106iv#1:
64369X26X106rect#0:
64369X26X106rect#1:
64369X26X106saft#0:
64369X26X106saft#1:
64369X26X107tbl_typD:
64369X26X107tbl_vonD:
64369X26X107tbl_bisD:
64369X26X107tbl_app:
64369X26X107tbl_subst:
64369X26X107tbl_regel:
64369X26X107tbl_typD:
64369X26X107tbl_vonD:
64369X26X107tbl_bisD:
64369X26X107tbl_typD:
64369X26X107tbl_vonD:
64369X26X107tbl_bisD:
64369X26X107tbl_app:
64369X26X107tbl_subst:
64369X26X107tbl_regel:
64369X26X107tbl_typD:
64369X26X107tbl_vonD:
64369X26X107tbl_bisD:
64369X26X107tbl_typD:
64369X26X107tbl_vonD:
64369X26X107tbl_bisD:
64369X26X107iv_typD:
64369X26X107iv_vonD:
64369X26X107iv_bisD:
64369X26X107iv_app:
64369X26X107iv_subst:
64369X26X107iv_regel:
64369X26X107iv_typD:
64369X26X107iv_vonD:
64369X26X107iv_bisD:
64369X26X107iv_typD:
64369X26X107iv_vonD:
64369X26X107iv_bisD:
64369X26X107iv_app:
64369X26X107iv_subst:
64369X26X107iv_regel:
64369X26X107iv_typD:
64369X26X107iv_vonD:
64369X26X107iv_bisD:
64369X26X107iv_typD:
64369X26X107iv_vonD:
64369X26X107iv_bisD:
64369X26X107rect_typD:
64369X26X107rect_vonD:
64369X26X107rect_bisD:
64369X26X107rect_app:
64369X26X107rect_subst:
64369X26X107rect_regel:
64369X26X107rect_typD:
64369X26X107rect_vonD:
64369X26X107rect_bisD:
64369X26X107rect_typD:
64369X26X107rect_vonD:
64369X26X107rect_bisD:
64369X26X107rect_app:
64369X26X107rect_subst:
64369X26X107rect_regel:
64369X26X107rect_typD:
64369X26X107rect_vonD:
64369X26X107rect_bisD:
64369X26X107rect_typD:
64369X26X107rect_vonD:
64369X26X107rect_bisD:
64369X26X107saft_typD:
64369X26X107saft_vonD:
64369X26X107saft_bisD:
64369X26X107saft_app:
64369X26X107saft_subst:
64369X26X107saft_regel:
64369X26X107saft_typD:
64369X26X107saft_vonD:
64369X26X107saft_bisD:
64369X26X107saft_typD:
64369X26X107saft_vonD:
64369X26X107saft_bisD:
64369X26X107saft_app:
64369X26X107saft_subst:
64369X26X107saft_regel:
64369X26X107saft_typD:
64369X26X107saft_vonD:
64369X26X107saft_bisD:
64369X26X107saft_typD:
64369X26X107saft_vonD:
64369X26X107saft_bisD:
64369X26X110ander_typD:
64369X26X110ander_vonD:
64369X26X110ander_bisD:
64369X26X110ander_app:
64369X26X110ander_subst:
64369X26X110ander_regel:
64369X26X110ander_typD:
64369X26X110ander_vonD:
64369X26X110ander_bisD:
64369X26X110ander_typD:
64369X26X110ander_vonD:
64369X26X110ander_bisD:
64369X26X110ander_app:
64369X26X110ander_subst:
64369X26X110ander_regel:
64369X26X110ander_typD:
64369X26X110ander_vonD:
64369X26X110ander_bisD:
64369X26X110ander_typD:
64369X26X110ander_vonD:
64369X26X110ander_bisD:
64369X26X110ander_app:
64369X26X110ander_subst:
64369X26X110ander_regel:
64369X26X110ander_typD:
64369X26X110ander_vonD:
64369X26X110ander_bisD:
64369X27X111tbl#0:
64369X27X111tbl#1:
64369X27X111iv#0:
64369X27X111iv#1:
64369X27X111rect#0:
64369X27X111rect#1:
64369X27X111saft#0:
64369X27X111saft#1:
64369X27X112tbl_typD:
64369X27X112tbl_vonD:
64369X27X112tbl_bisD:
64369X27X112tbl_app:
64369X27X112tbl_subst:
64369X27X112tbl_regel:
64369X27X112tbl_typD:
64369X27X112tbl_vonD:
64369X27X112tbl_bisD:
64369X27X112tbl_typD:
64369X27X112tbl_vonD:
64369X27X112tbl_bisD:
64369X27X112tbl_app:
64369X27X112tbl_subst:
64369X27X112tbl_regel:
64369X27X112tbl_typD:
64369X27X112tbl_vonD:
64369X27X112tbl_bisD:
64369X27X112tbl_typD:
64369X27X112tbl_vonD:
64369X27X112tbl_bisD:
64369X27X112tbl_app:
64369X27X112tbl_subst:
64369X27X112tbl_regel:
64369X27X112tbl_typD:
64369X27X112tbl_vonD:
64369X27X112tbl_bisD:
64369X27X112tbl_typD:
64369X27X112tbl_vonD:
64369X27X112tbl_bisD:
64369X27X112iv_typD:
64369X27X112iv_vonD:
64369X27X112iv_bisD:
64369X27X112iv_app:
64369X27X112iv_subst:
64369X27X112iv_regel:
64369X27X112iv_typD:
64369X27X112iv_vonD:
64369X27X112iv_bisD:
64369X27X112iv_typD:
64369X27X112iv_vonD:
64369X27X112iv_bisD:
64369X27X112iv_app:
64369X27X112iv_subst:
64369X27X112iv_regel:
64369X27X112iv_typD:
64369X27X112iv_vonD:
64369X27X112iv_bisD:
64369X27X112iv_typD:
64369X27X112iv_vonD:
64369X27X112iv_bisD:
64369X27X112iv_app:
64369X27X112iv_subst:
64369X27X112iv_regel:
64369X27X112iv_typD:
64369X27X112iv_vonD:
64369X27X112iv_bisD:
64369X27X112iv_typD:
64369X27X112iv_vonD:
64369X27X112iv_bisD:
64369X27X112rect_typD:
64369X27X112rect_vonD:
64369X27X112rect_bisD:
64369X27X112rect_app:
64369X27X112rect_subst:
64369X27X112rect_regel:
64369X27X112rect_typD:
64369X27X112rect_vonD:
64369X27X112rect_bisD:
64369X27X112rect_typD:
64369X27X112rect_vonD:
64369X27X112rect_bisD:
64369X27X112rect_app:
64369X27X112rect_subst:
64369X27X112rect_regel:
64369X27X112rect_typD:
64369X27X112rect_vonD:
64369X27X112rect_bisD:
64369X27X112rect_typD:
64369X27X112rect_vonD:
64369X27X112rect_bisD:
64369X27X112rect_app:
64369X27X112rect_subst:
64369X27X112rect_regel:
64369X27X112rect_typD:
64369X27X112rect_vonD:
64369X27X112rect_bisD:
64369X27X112rect_typD:
64369X27X112rect_vonD:
64369X27X112rect_bisD:
64369X27X112saft_typD:
64369X27X112saft_vonD:
64369X27X112saft_bisD:
64369X27X112saft_app:
64369X27X112saft_subst:
64369X27X112saft_regel:
64369X27X112saft_typD:
64369X27X112saft_vonD:
64369X27X112saft_bisD:
64369X27X112saft_typD:
64369X27X112saft_vonD:
64369X27X112saft_bisD:
64369X27X112saft_app:
64369X27X112saft_subst:
64369X27X112saft_regel:
64369X27X112saft_typD:
64369X27X112saft_vonD:
64369X27X112saft_bisD:
64369X27X112saft_typD:
64369X27X112saft_vonD:
64369X27X112saft_bisD:
64369X27X112saft_app:
64369X27X112saft_subst:
64369X27X112saft_regel:
64369X27X112saft_typD:
64369X27X112saft_vonD:
64369X27X112saft_bisD:
64369X27X112saft_typD:
64369X27X112saft_vonD:
64369X27X112saft_bisD:
64369X27X117ander_typD:
64369X27X117ander_vonD:
64369X27X117ander_bisD:
64369X27X117ander_app:
64369X27X117ander_subst:
64369X27X117ander_regel:
64369X27X117ander_typD:
64369X27X117ander_vonD:
64369X27X117ander_bisD:
64369X27X117ander_typD:
64369X27X117ander_vonD:
64369X27X117ander_bisD:
64369X27X117ander_app:
64369X27X117ander_subst:
64369X27X117ander_regel:
64369X27X117ander_typD:
64369X27X117ander_vonD:
64369X27X117ander_bisD:
64369X27X117ander_typD:
64369X27X117ander_vonD:
64369X27X117ander_bisD:
64369X27X117ander_app:
64369X27X117ander_subst:
64369X27X117ander_regel:
64369X27X117ander_typD:
64369X27X117ander_vonD:
64369X27X117ander_bisD:
64369X27X117ander_typD:
64369X27X117ander_vonD:
64369X27X117ander_bisD:
64369X27X117ander_app:
64369X27X117ander_subst:
64369X27X117ander_regel:
64369X27X117ander_typD:
64369X27X117ander_vonD:
64369X27X117ander_bisD:
64369X27X113tbl#0:
64369X27X113tbl#1:
64369X27X113iv#0:
64369X27X113iv#1:
64369X27X113rect#0:
64369X27X113rect#1:
64369X27X113saft#0:
64369X27X113saft#1:
64369X27X114tbl_typD:
64369X27X114tbl_vonD:
64369X27X114tbl_bisD:
64369X27X114tbl_app:
64369X27X114tbl_subst:
64369X27X114tbl_regel:
64369X27X114tbl_typD:
64369X27X114tbl_vonD:
64369X27X114tbl_bisD:
64369X27X114tbl_typD:
64369X27X114tbl_vonD:
64369X27X114tbl_bisD:
64369X27X114tbl_app:
64369X27X114tbl_subst:
64369X27X114tbl_regel:
64369X27X114tbl_typD:
64369X27X114tbl_vonD:
64369X27X114tbl_bisD:
64369X27X114tbl_typD:
64369X27X114tbl_vonD:
64369X27X114tbl_bisD:
64369X27X114tbl_app:
64369X27X114tbl_subst:
64369X27X114tbl_regel:
64369X27X114tbl_typD:
64369X27X114tbl_vonD:
64369X27X114tbl_bisD:
64369X27X114tbl_typD:
64369X27X114tbl_vonD:
64369X27X114tbl_bisD:
64369X27X114tbl_app:
64369X27X114tbl_subst:
64369X27X114tbl_regel:
64369X27X114tbl_typD:
64369X27X114tbl_vonD:
64369X27X114tbl_bisD:
64369X27X114tbl_typD:
64369X27X114tbl_vonD:
64369X27X114tbl_bisD:
64369X27X114iv_typD:
64369X27X114iv_vonD:
64369X27X114iv_bisD:
64369X27X114iv_app:
64369X27X114iv_subst:
64369X27X114iv_regel:
64369X27X114iv_typD:
64369X27X114iv_vonD:
64369X27X114iv_bisD:
64369X27X114iv_typD:
64369X27X114iv_vonD:
64369X27X114iv_bisD:
64369X27X114iv_app:
64369X27X114iv_subst:
64369X27X114iv_regel:
64369X27X114iv_typD:
64369X27X114iv_vonD:
64369X27X114iv_bisD:
64369X27X114iv_typD:
64369X27X114iv_vonD:
64369X27X114iv_bisD:
64369X27X114iv_app:
64369X27X114iv_subst:
64369X27X114iv_regel:
64369X27X114iv_typD:
64369X27X114iv_vonD:
64369X27X114iv_bisD:
64369X27X114iv_typD:
64369X27X114iv_vonD:
64369X27X114iv_bisD:
64369X27X114iv_app:
64369X27X114iv_subst:
64369X27X114iv_regel:
64369X27X114iv_typD:
64369X27X114iv_vonD:
64369X27X114iv_bisD:
64369X27X114iv_typD:
64369X27X114iv_vonD:
64369X27X114iv_bisD:
64369X27X114rect_typD:
64369X27X114rect_vonD:
64369X27X114rect_bisD:
64369X27X114rect_app:
64369X27X114rect_subst:
64369X27X114rect_regel:
64369X27X114rect_typD:
64369X27X114rect_vonD:
64369X27X114rect_bisD:
64369X27X114rect_typD:
64369X27X114rect_vonD:
64369X27X114rect_bisD:
64369X27X114rect_app:
64369X27X114rect_subst:
64369X27X114rect_regel:
64369X27X114rect_typD:
64369X27X114rect_vonD:
64369X27X114rect_bisD:
64369X27X114rect_typD:
64369X27X114rect_vonD:
64369X27X114rect_bisD:
64369X27X114rect_app:
64369X27X114rect_subst:
64369X27X114rect_regel:
64369X27X114rect_typD:
64369X27X114rect_vonD:
64369X27X114rect_bisD:
64369X27X114rect_typD:
64369X27X114rect_vonD:
64369X27X114rect_bisD:
64369X27X114rect_app:
64369X27X114rect_subst:
64369X27X114rect_regel:
64369X27X114rect_typD:
64369X27X114rect_vonD:
64369X27X114rect_bisD:
64369X27X114rect_typD:
64369X27X114rect_vonD:
64369X27X114rect_bisD:
64369X27X114saft_typD:
64369X27X114saft_vonD:
64369X27X114saft_bisD:
64369X27X114saft_app:
64369X27X114saft_subst:
64369X27X114saft_regel:
64369X27X114saft_typD:
64369X27X114saft_vonD:
64369X27X114saft_bisD:
64369X27X114saft_typD:
64369X27X114saft_vonD:
64369X27X114saft_bisD:
64369X27X114saft_app:
64369X27X114saft_subst:
64369X27X114saft_regel:
64369X27X114saft_typD:
64369X27X114saft_vonD:
64369X27X114saft_bisD:
64369X27X114saft_typD:
64369X27X114saft_vonD:
64369X27X114saft_bisD:
64369X27X114saft_app:
64369X27X114saft_subst:
64369X27X114saft_regel:
64369X27X114saft_typD:
64369X27X114saft_vonD:
64369X27X114saft_bisD:
64369X27X114saft_typD:
64369X27X114saft_vonD:
64369X27X114saft_bisD:
64369X27X114saft_app:
64369X27X114saft_subst:
64369X27X114saft_regel:
64369X27X114saft_typD:
64369X27X114saft_vonD:
64369X27X114saft_bisD:
64369X27X114saft_typD:
64369X27X114saft_vonD:
64369X27X114saft_bisD:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X118ander_app:
64369X27X118ander_subst:
64369X27X118ander_regel:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X118ander_app:
64369X27X118ander_subst:
64369X27X118ander_regel:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X118ander_app:
64369X27X118ander_subst:
64369X27X118ander_regel:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X118ander_app:
64369X27X118ander_subst:
64369X27X118ander_regel:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X118ander_app:
64369X27X118ander_subst:
64369X27X118ander_regel:
64369X27X118ander_typD:
64369X27X118ander_vonD:
64369X27X118ander_bisD:
64369X27X115tbl#0:
64369X27X115tbl#1:
64369X27X115iv#0:
64369X27X115iv#1:
64369X27X115rect#0:
64369X27X115rect#1:
64369X27X115saft#0:
64369X27X115saft#1:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_app:
64369X27X116tbl_subst:
64369X27X116tbl_regel:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_app:
64369X27X116tbl_subst:
64369X27X116tbl_regel:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_app:
64369X27X116tbl_subst:
64369X27X116tbl_regel:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_app:
64369X27X116tbl_subst:
64369X27X116tbl_regel:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_app:
64369X27X116tbl_subst:
64369X27X116tbl_regel:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116tbl_typD:
64369X27X116tbl_vonD:
64369X27X116tbl_bisD:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_app:
64369X27X116iv_subst:
64369X27X116iv_regel:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_app:
64369X27X116iv_subst:
64369X27X116iv_regel:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_app:
64369X27X116iv_subst:
64369X27X116iv_regel:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_app:
64369X27X116iv_subst:
64369X27X116iv_regel:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_app:
64369X27X116iv_subst:
64369X27X116iv_regel:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116iv_typD:
64369X27X116iv_vonD:
64369X27X116iv_bisD:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_app:
64369X27X116rect_subst:
64369X27X116rect_regel:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_app:
64369X27X116rect_subst:
64369X27X116rect_regel:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_app:
64369X27X116rect_subst:
64369X27X116rect_regel:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_app:
64369X27X116rect_subst:
64369X27X116rect_regel:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_app:
64369X27X116rect_subst:
64369X27X116rect_regel:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116rect_typD:
64369X27X116rect_vonD:
64369X27X116rect_bisD:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_app:
64369X27X116saft_subst:
64369X27X116saft_regel:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_app:
64369X27X116saft_subst:
64369X27X116saft_regel:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_app:
64369X27X116saft_subst:
64369X27X116saft_regel:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_app:
64369X27X116saft_subst:
64369X27X116saft_regel:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_app:
64369X27X116saft_subst:
64369X27X116saft_regel:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X116saft_typD:
64369X27X116saft_vonD:
64369X27X116saft_bisD:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_app:
64369X27X119ander_subst:
64369X27X119ander_regel:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_app:
64369X27X119ander_subst:
64369X27X119ander_regel:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_app:
64369X27X119ander_subst:
64369X27X119ander_regel:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_app:
64369X27X119ander_subst:
64369X27X119ander_regel:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_app:
64369X27X119ander_subst:
64369X27X119ander_regel:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X27X119ander_app:
64369X27X119ander_subst:
64369X27X119ander_regel:
64369X27X119ander_typD:
64369X27X119ander_vonD:
64369X27X119ander_bisD:
64369X28X120:
64369X28X121:
64369X28X122:
64369X28X123:
64369X28X129:
64369X28X124zeitm:
64369X28X124azeit:
64369X28X124kdaue:
64369X28X124ldaue:
64369X28X124anxio:
64369X28X124analg:
64369X28X130:
64369X28X125entlv:
64369X28X125kwirk:
64369X28X125kprme:
64369X28X125sedie:
64369X28X125logis:
64369X28X125verge:
64369X28X126koll:
64369X28X126anaes:
64369X28X126fachp:
64369X28X126other:
64369X28X127hold:
64369X28X127schle:
64369X28X127op:
64369X28X127other:
64369X28X128pfleg:
64369X28X128fachp:
64369X28X128anaes:
64369X28X128chir:
64369X28X128other:
64369X28X131:

FEHLERHAFTE SQL ANWEISUNG:
INSERT INTO lime_survey_64369
(64369X26X102tbl#0, 64369X26X102tbl#1, 64369X26X102iv#0, 64369X26X102iv#1, 64369X26X102rect#0, 64369X26X102rect#1, 64369X26X102saft#0, 64369X26X102saft#1, 64369X26X103tbl_typD, 64369X26X103tbl_vonD, 64369X26X103tbl_bisD, 64369X26X103iv_typD, 64369X26X103iv_vonD, 64369X26X103iv_bisD, 64369X26X103rect_typD, 64369X26X103rect_vonD, 64369X26X103rect_bisD, 64369X26X103saft_typD, 64369X26X103saft_vonD, 64369X26X103saft_bisD, 64369X26X108ander_typD, 64369X26X108ander_vonD, 64369X26X108ander_bisD, 64369X26X108ander_app, 64369X26X108ander_subst, 64369X26X108ander_regel, 64369X26X104tbl#0, 64369X26X104tbl#1, 64369X26X104iv#0, 64369X26X104iv#1, 64369X26X104rect#0, 64369X26X104rect#1, 64369X26X104saft#0, 64369X26X104saft#1, 64369X26X105tbl_typD, 64369X26X105tbl_vonD, 64369X26X105tbl_bisD, 64369X26X105iv_typD, 64369X26X105iv_vonD, 64369X26X105iv_bisD, 64369X26X105rect_typD, 64369X26X105rect_vonD, 64369X26X105rect_bisD, 64369X26X105saft_typD, 64369X26X105saft_vonD, 64369X26X105saft_bisD, 64369X26X109ander_typD, 64369X26X109ander_vonD, 64369X26X109ander_bisD, 64369X26X109ander_app, 64369X26X109ander_subst, 64369X26X109ander_regel, 64369X26X106tbl#0, 64369X26X106tbl#1, 64369X26X106iv#0, 64369X26X106iv#1, 64369X26X106rect#0, 64369X26X106rect#1, 64369X26X106saft#0, 64369X26X106saft#1, 64369X26X107tbl_typD, 64369X26X107tbl_vonD, 64369X26X107tbl_bisD, 64369X26X107iv_typD, 64369X26X107iv_vonD, 64369X26X107iv_bisD, 64369X26X107rect_typD, 64369X26X107rect_vonD, 64369X26X107rect_bisD, 64369X26X107saft_typD, 64369X26X107saft_vonD, 64369X26X107saft_bisD, 64369X26X110ander_typD, 64369X26X110ander_vonD, 64369X26X110ander_bisD, 64369X26X110ander_app, 64369X26X110ander_subst, 64369X26X110ander_regel,startlanguage) VALUES ('Mi', ', 'No', '25-50', 'Ke', '50-75', 'Cl', '>75', '1', '1', '1', '2', '2', '2', '3', '3', '3', '4', '4', '4', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'de')

FEHLERMELDUNG:
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 'No', '25-50', 'Ke', '50-75', 'Cl', '>75', '1', '1', '1', '2', '2', '2', '3', '3'' at line 2

user372

2009-07-09 13:22

  ~08808

Please attach a simple sample survey, where we can reproduce the problem - Thx!
level420

level420

2009-07-09 14:10

reporter   ~08809

Attached with both used label sets.

user372

2009-07-15 00:18

  ~08856

I can reproduce the issue.

import the attached survey "bug_limesurvey_survey_export.csv"

activate survey

choose at least once the answer option "lower than 10%" at the first column and choose submit

==> at submit the following error ant notices are displayed:
Did not save

An unexpected error has occurred and your responses cannot be saved.

Your responses have not been lost and have been emailed to the survey administrator and will be entered into our database at a later point.

Notice: Undefined index: s_lang in /home/.sites/962/site989/web/limesurvey/index.php on line 1363

Notice: Undefined index: s_lang in /home/.sites/962/site989/web/limesurvey/index.php on line 1363

Notice: Undefined index: s_lang in /home/.sites/962/site989/web/limesurvey/index.php on line 1363

Notice: Undefined index: s_lang in /home/.sites/962/site989/web/limesurvey/index.php on line 1363

Warning: session_destroy() [function.session-destroy]: Trying to destroy uninitialized session in /home/.sites/962/site989/web/limesurvey/common.php on line 4126
jcleeland

jcleeland

2009-07-21 17:28

reporter   ~08890

Fix uploaded to svn
level420

level420

2009-07-21 17:43

reporter   ~08891

@jcleeland: Thank you for the fix.

Issue History

Date Modified Username Field Change
2009-07-09 12:36 level420 New Issue
2009-07-09 12:36 level420 Status new => assigned
2009-07-09 12:36 level420 Assigned To => user372
2009-07-09 12:36 level420 Database & DB-Version => mysql 5.0.45
2009-07-09 12:36 level420 Operating System (Server) => suse linux 10.3
2009-07-09 12:36 level420 Webserver => apache 2.2
2009-07-09 12:36 level420 PHP Version => 5.2.6 with Suhosin-Patch 0.9.6.2
2009-07-09 12:40 level420 Note Added: 08807
2009-07-09 12:41 level420 Note Edited: 08807
2009-07-09 13:22 user372 Note Added: 08808
2009-07-09 13:22 user372 Status assigned => feedback
2009-07-09 14:05 level420 File Added: bug_limesurvey_survey_export.csv
2009-07-09 14:08 level420 File Added: limesurvey_labelset_drugs.csv
2009-07-09 14:08 level420 File Added: limesurvey_labelset_percent.csv
2009-07-09 14:10 level420 Note Added: 08809
2009-07-15 00:18 user372 Note Added: 08856
2009-07-15 00:18 user372 Status feedback => assigned
2009-07-15 00:18 user372 Assigned To user372 => jcleeland
2009-07-21 17:28 jcleeland Note Added: 08890
2009-07-21 17:28 jcleeland Status assigned => resolved
2009-07-21 17:28 jcleeland Fixed in Version => 1.85+
2009-07-21 17:28 jcleeland Resolution open => fixed
2009-07-21 17:43 level420 Note Added: 08891
2009-07-29 11:11 c_schmitz Status resolved => closed
2010-10-25 00:18 c_schmitz Category Survey at Runtime => Survey taking