06825: Long free text field improper escape sequence for Microsoft SQL - LimeSurvey bugs, patches and feature requests

LimeSurvey issue tracker

Registration

View Issue Details [ Jump to Notes ] [ Related Changesets ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

06825

Bug reports

[All Projects] Security

public

2012-11-02 16:11

2012-11-06 10:37

Reporter

helper

Assigned To

c_schmitz

Priority

normal

Severity

crash

Status

closed

Resolution

fixed

Product Version

2.00+

Target Version

Fixed in Version

2.00+

Summary

06825: Long free text field improper escape sequence for Microsoft SQL

Description

Entering 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 Reproduce

Enter the following phrase in a long free text:

I'm testing

Click on next.

I will donate to the project if issue is resolved within 48 hrs

LimeSurvey build number

121101

Browser

any

Database & DB-Version

Microsoft SQL Server 2008

Operating System (Server)

Windows 2008r2

Webserver software & version

Apache 2.4

PHP Version

5.4

Attached Files

survey_archive_418521.lsa [^] (4,357 bytes) 2012-11-02 16:11

Relationships

Notes
(21926) c_schmitz (administrator) 2012-11-02 17:09	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10129 [^]

(21927) c_schmitz (administrator) 2012-11-02 21:42	New version 2.00+ Build 121102 released.

(21982) c_schmitz (administrator) 2012-11-06 10:37	Fix committed to 2.1 branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=10156 [^]

Related Changesets
LimeSurvey: master 3ad09748 Timestamp: 2012-11-02 16:08:58 Author: c_schmitz Committer: Carsten 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 Timestamp: 2012-11-02 16:08:58 Author: c_schmitz Committer: Carsten 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