LimeSurvey issue tracker
Registration

View Issue Details Jump to Notes ] Related Changesets ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
06825Bug reports[All Projects] Securitypublic2012-11-02 16:112012-11-06 10:37
Reporterhelper 
Assigned Toc_schmitz 
PrioritynormalSeveritycrash 
StatusclosedResolutionfixed 
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.
I will donate to the project if issue is resolved within 48 hrsNo
LimeSurvey build number OR git commit ID121101
Browserany
Database & DB-VersionMicrosoft SQL Server 2008
Operating System (Server)Windows 2008r2
Webserver software & versionApache 2.4
PHP Version5.4
Attached Files? file icon survey_archive_418521.lsa [^] (4,357 bytes) 2012-11-02 16:11

- Relationships

-  Notes
User avatar (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 [^]
User avatar (21927)
c_schmitz (administrator)
2012-11-02 21:42

New version 2.00+ Build 121102 released.
User avatar (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


Copyright © 2000 - 2014 MantisBT Team
Powered by Mantis Bugtracker