View Issue Details

Related ChangesetsJump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
10187Bug reportsSurvey editingpublic2015-12-27 00:032016-01-08 15:35
Reporteraesteban Assigned ToLouisGac 
PrioritynormalSeverityblock 
Status closedResolutionfixed 
Product Version2.50.x 
Summary10187: Crash when using search engine in survey list
Description

DB crash occurs when admin user try to use search engine

Steps To Reproduce

1.- Create a survey
2.- List surveys
3.- Write "admin" in search box and click on "Search"

Internal Server Error

CDbCommand falló al ejecutar la sentencia SQL: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer ~~ unknown
LINE 1: ...gesettings.surveyls_title LIKE '%admin%') OR (sid LIKE '%adm...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.

Additional Information

Code try to use LIKE operator for INTEGER column

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)9bd256db795caa08829816656fc2
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionPostgresql 9.4
Server OS (if known)Debian Jessie
Webserver software & version (if known)Nginx 1.6.2
PHP Version5.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

LouisGac

LouisGac

2015-12-28 11:41

developer   ~34117

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

c_schmitz

2016-01-08 15:35

administrator   ~34195

Version 2.5RC6 released

Related Changesets

LimeSurvey: 2.5 d3133530

2015-12-28 11:41

LouisGac


Details Diff		 Fixed issue 10187: added table alias for "like" research Affected Issues
10187
mod - application/models/Survey.php Diff File

Issue History

Date Modified Username Field Change
2015-12-27 00:03 aesteban New Issue
2015-12-28 11:41 LouisGac Changeset attached => LimeSurvey 2.5 d3133530
2015-12-28 11:41 LouisGac Note Added: 34117
2015-12-28 11:41 LouisGac Assigned To => LouisGac
2015-12-28 11:41 LouisGac Resolution open => fixed
2015-12-28 11:42 LouisGac Status new => resolved
2016-01-08 15:35 c_schmitz Note Added: 34195
2016-01-08 15:35 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing