View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
10316Bug reportsSurvey editingpublic2016-02-05 15:012016-02-10 21:03
Reporterollehar Assigned ToLouisGac 
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version2.50.x 
Target Version2.50.x 
Summary10316: Can't search surveys using postgres
Description

CDbCommand failed to execute the SQL statement: SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer ~~ unknown
LINE 1: ...agesettings.surveyls_title LIKE '%sd%') OR (t.sid LIKE '%sd%...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.. The SQL statement executed was: SELECT COUNT(*) FROM "lime_surveys" "t" LEFT JOIN lime_surveys_languagesettings AS surveys_languagesettings ON ( surveys_languagesettings.surveyls_language = t.language AND t.sid = surveys_languagesettings.surveyls_survey_id )LEFT JOIN lime_users AS users ON ( users.uid = t.owner_id ) WHERE ((surveys_languagesettings.surveyls_title LIKE :ycp1) OR (t.sid LIKE :ycp2)) OR (t.admin LIKE :ycp3)

/var/www/lime25/limesurvey/framework/db/CDbCommand.php(543)

543 throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',

Steps To Reproduce

Go to survey list, search.

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)latest
I will donate to the project if issue is resolvedNo
Browser
Database type & versionpostgres
Server OS (if known)linux
Webserver software & version (if known)chromium
PHP Version5.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2016-02-05 19:40

administrator   ~34642

Comparing an integer (survey ID) to a string using 'LIKE' is a type mismatch.
LouisGac

LouisGac

2016-02-08 20:06

developer   ~34754

using strong type is a mismatch ^^
LouisGac

LouisGac

2016-02-08 20:06

developer   ~34755

I removed the comparison in another commit
c_schmitz

c_schmitz

2016-02-10 21:03

administrator   ~34863

2.5 Build 160210 released

Issue History

Date Modified Username Field Change
2016-02-05 15:01 ollehar New Issue
2016-02-05 19:39 c_schmitz Assigned To => LouisGac
2016-02-05 19:39 c_schmitz Status new => assigned
2016-02-05 19:40 c_schmitz Note Added: 34642
2016-02-08 20:06 LouisGac Note Added: 34754
2016-02-08 20:06 LouisGac Note Added: 34755
2016-02-08 20:06 LouisGac Status assigned => resolved
2016-02-08 20:06 LouisGac Resolution open => fixed
2016-02-10 21:03 c_schmitz Note Added: 34863
2016-02-10 21:03 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing