View Issue Details

IDProjectCategoryView StatusLast Update
06825Bug reports[All Projects] Securitypublic2012-11-06 10:37
Reporterhelper 
Assigned Toc_schmitz 
PrioritynormalSeveritycrash 
Status closedResolutionfixed 
Product Version2.00+ 
Target VersionFixed in Version2.00+ 
Summary06825: Long free text field improper escape sequence for Microsoft SQL
DescriptionEntering an apostrophe in a long free text field escapes with an improper character (should be another apostrophe for MSSQL).

Error executing query in dbExecuteAssoc:CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 'm'.. The SQL statement executed was: UPDATE lime_survey_418521 SET [lastpage]='1', [datestamp]='2012-11-02 06:10:13', [ipaddr]='172.28.204.176', [418521X5X42]='Y', [418521X5X276]='I\'m testing' WHERE ID=2
Steps To ReproduceEnter the following phrase in a long free text:

I'm testing

Click on next.
TagsNo tags attached.
Complete LimeSurvey version number (& build)121101
I will donate to the project if issue is resolvedNo
Browserany
Database & DB-VersionMicrosoft SQL Server 2008
Operating System (Server)Windows 2008r2
Webserver software & versionApache 2.4
PHP Version5.4

Relationships

Activities

helper

2012-11-02 16:11

reporter  

survey_archive_418521.lsa (4,357 bytes)

c_schmitz

2012-11-02 17:09

administrator   ~21926

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10129

c_schmitz

2012-11-02 21:42

administrator   ~21927

New version 2.00+ Build 121102 released.

c_schmitz

2012-11-06 10:37

administrator   ~21982

Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10156

Related Changesets

LimeSurvey: master 3ad09748

2012-11-02 16:08:58

c_schmitz

Details Diff
Fixed issue 06825: Long free text field improper escape sequence for Microsoft SQL
mod - application/helpers/common_helper.php Diff File

LimeSurvey: 2.1 14a65ae2

2012-11-02 16:08:58

c_schmitz

Details Diff
Fixed issue 06825: Long free text field improper escape sequence for Microsoft SQL
mod - application/helpers/common_helper.php Diff File

Issue History

Date Modified Username Field Change
2012-11-02 16:11 helper New Issue
2012-11-02 16:11 helper File Added: survey_archive_418521.lsa
2012-11-02 16:40 c_schmitz Assigned To => c_schmitz
2012-11-02 16:40 c_schmitz Status new => assigned
2012-11-02 17:08 c_schmitz Status assigned => resolved
2012-11-02 17:08 c_schmitz Fixed in Version => 2.00+
2012-11-02 17:08 c_schmitz Resolution open => fixed
2012-11-02 17:09 c_schmitz Changeset attached => LimeSurvey master 3ad09748
2012-11-02 17:09 c_schmitz Note Added: 21926
2012-11-02 21:42 c_schmitz Note Added: 21927
2012-11-02 21:42 c_schmitz Status resolved => closed
2012-11-06 10:37 c_schmitz Changeset attached => LimeSurvey 2.1 14a65ae2
2012-11-06 10:37 c_schmitz Note Added: 21982