View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
11348Bug reportsSurvey editingpublic2016-06-07 15:442016-06-13 12:27
Reporterlescaph Assigned ToLouisGac 
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.50.x 
Summary11348: sql error with apostrophe in group names
Description

If a group name contains an apostrophe ( ' or ' ), the search function at listquestions page throws an sql error :
CDbCommand n'a pas pu exécuter la commande SQL : SQLSTATE[42000]: Syntax error or access violation: 1064 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 'xxx'))' at line 1

Steps To Reproduce
  1. Use an apostrophe in a group name
  2. List survey questions (/index.php/admin/survey/sa/listquestions/)
  3. Select a group
  4. Hit search button
TagsNo tags attached.
Bug heat6
Complete LimeSurvey version number (& build)160606
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL 5.5
Server OS (if known)Debian jessie
Webserver software & version (if known)custom Apache 2.2
PHP Version7

Users monitoring this issue

There are no users monitoring this issue.

Activities

LouisGac

LouisGac

2016-06-07 15:48

developer   ~39284

I can't reproduce.
could you attach a lss file please?
ollehar

ollehar

2016-06-07 15:51

administrator   ~39285

Last edited: 2016-06-07 15:51

Also, enable debug = 2 in application/config/config.php, try again and attach the complete error message (especially the complete SQL query). Thank you.
LouisGac

LouisGac

2016-06-07 15:55

developer   ~39286

it's ok, we could reproduce (confusion between list group and list questions)
LouisGac

LouisGac

2016-06-07 16:01

developer   ~39288

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

c_schmitz

2016-06-13 12:27

administrator   ~39486

Version 2.50 Build 160613 released

Related Changesets

LimeSurvey: master 9d68e02a

2016-06-07 14:00:59

LouisGac

Details Diff 		Fixed issue 11348: sql error with apostrophe in group names Affected Issues
11348
mod - application/models/Question.php Diff File

Issue History

Date Modified Username Field Change
2016-06-07 15:44 lescaph New Issue
2016-06-07 15:46 LouisGac Sticky Issue No => Yes
2016-06-07 15:48 LouisGac Note Added: 39284
2016-06-07 15:51 ollehar Note Added: 39285
2016-06-07 15:51 ollehar Note Edited: 39285
2016-06-07 15:55 LouisGac Note Added: 39286
2016-06-07 16:01 LouisGac Changeset attached => LimeSurvey master 9d68e02a
2016-06-07 16:01 LouisGac Note Added: 39288
2016-06-07 16:01 LouisGac Assigned To => LouisGac
2016-06-07 16:01 LouisGac Resolution open => fixed
2016-06-07 16:01 LouisGac Status new => resolved
2016-06-08 12:54 c_schmitz Sticky Issue Yes => No
2016-06-13 12:27 c_schmitz Note Added: 39486
2016-06-13 12:27 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing