View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
03617 | Bug reports | Survey taking | public | 2009-09-01 07:31 | 2009-09-01 16:10 |
Reporter | izahn | Assigned To | |||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | unable to reproduce | ||
Product Version | 1.85+ | ||||
Summary | 03617: 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: 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: SQL CODE THAT FAILED: ERROR MESSAGE: | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | |||||
I will donate to the project if issue is resolved | |||||
Browser | Firefox | ||||
Database type & version | MySQL 5.1 | ||||
Server OS (if known) | Ubuntu linux version 9.04 | ||||
Webserver software & version (if known) | Apache2 | ||||
PHP Version | 5.2 | ||||
I've attached a survey file that triggers the error. |
|
I CAN'T reproduce the error on my installation, which runs the latest stable version (released yesterday).
|
|
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! |
|
The issue appears to be fixed in build 7548. Sorry for the noise, I should have upgraded before reporting. -Ista |
|
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 |
|
Note Added: 09297 | |
2009-09-01 07:41 |
|
Status | assigned => feedback |
2009-09-01 07:42 |
|
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 |
|
Status | feedback => closed |
2009-09-01 16:10 |
|
Resolution | open => unable to reproduce |
2010-10-25 00:18 | c_schmitz | Category | Survey at Runtime => Survey taking |