View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
03617Bug reportsSurvey takingpublic2009-09-01 16:10
Reporterizahn Assigned Touser372 
PrioritynormalSeveritypartial_block 
Status closedResolutionunable to reproduce 
Product Version1.85+ 
Summary03617: problem with quotation mark in long free text question
Description

Unfortunately this issue has been hard to pin down. It seems that if the participant responds with a quotation mark (') in a long free text question on the last group of a survey, an sql error is triggered. I can reproduce this a will on my own installation (Version 1.85+) but not on the demonstration installation on limesurvey.org.

To reproduce on my machine:
1) create a study presented group by group with at least two groups.
2) in the last group, create a long free text question.
3) activate the study and run it. In the long free text question, include a quotation mark (') in your response.

This triggers the following error:

"An error occurred saving a response to survey id Demonstration of long free text error - 46588

DATA TO BE ENTERED:
46588X204X1094: 33
46588X205X1095: I'm trying to understand.

SQL CODE THAT FAILED:
UPDATE lime_survey_46588 SET submitdate = '1980-01-01 00:00:00', 46588X205X1095 = 'I'm trying to understand.' WHERE id=1

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 'm trying to understand.' WHERE id=1' at line 1"

TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
BrowserFirefox
Database type & versionMySQL 5.1
Server OS (if known)Ubuntu linux version 9.04
Webserver software & version (if known)Apache2
PHP Version5.2

Users monitoring this issue

izahn

Activities

izahn

izahn

2009-09-01 07:33

reporter   ~09296

I've attached a survey file that triggers the error.

user372

2009-09-01 07:41

  ~09297

Last edited: 2009-09-01 07:42

I CAN'T reproduce the error on my installation, which runs the latest stable version (released yesterday).

  1. which build of LimeSurvey do you use? ==> If not the latest build 7548 ==> Upgrade and tell us, if you can still have the problem afterwards.
  2. can you reproduce the issue on my installation?
    http://www.prandstetter.at/limesurvey/index.php?sid=46588&lang=en
izahn

izahn

2009-09-01 07:46

reporter   ~09298

Thanks for the quick response. I cannot seem to reproduce on your installation. I'm running build 7460. I will see if upgrading to 7548 resolves the issue.

Thanks!

izahn

izahn

2009-09-01 16:09

reporter   ~09308

The issue appears to be fixed in build 7548. Sorry for the noise, I should have upgraded before reporting.

-Ista

Issue History

Date Modified Username Field Change
2009-09-01 07:31 izahn New Issue
2009-09-01 07:31 izahn Status new => assigned
2009-09-01 07:31 izahn Assigned To => user372
2009-09-01 07:31 izahn File Added: limesurvey_survey_46588.csv
2009-09-01 07:31 izahn Browser => Firefox
2009-09-01 07:31 izahn Database & DB-Version => MySQL 5.1
2009-09-01 07:31 izahn Operating System (Server) => Ubuntu linux version 9.04
2009-09-01 07:31 izahn Webserver => Apache2
2009-09-01 07:31 izahn PHP Version => 5.2
2009-09-01 07:33 izahn Issue Monitored: izahn
2009-09-01 07:33 izahn Note Added: 09296
2009-09-01 07:41 user372 Note Added: 09297
2009-09-01 07:41 user372 Status assigned => feedback
2009-09-01 07:42 user372 Note Edited: 09297
2009-09-01 07:46 izahn Note Added: 09298
2009-09-01 16:09 izahn Note Added: 09308
2009-09-01 16:10 user372 Status feedback => closed
2009-09-01 16:10 user372 Resolution open => unable to reproduce
2010-10-25 00:18 c_schmitz Category Survey at Runtime => Survey taking