11644: SQL error in postgresql when filtering by date types in participants list and responses list

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

11644	Bug reports	Survey participants (Tokens)	public	2016-09-10 15:27	2016-09-20 10:48

Reporter	aesteban	Assigned To	ollehar
Priority	high	Severity	minor
Status	closed	Resolution	fixed
Product Version	2.51.x
Fixed in Version	2.51.x

Summary	11644: SQL error in postgresql when filtering by date types in participants list and responses list
Description	SQL error when filtering by valid from and valid until in survey participant list and datestamp in responses list.
Steps To Reproduce	Example with "valid from" field: Go to participant list Try to filter by valid from with '4' An SQL error raise
Tags	No tags attached.

Bug heat	4
Complete LimeSurvey version number (& build)	160908
I will donate to the project if issue is resolved	No
Browser	Firefox
Database type & version	Postgres 9.4.8
Server OS (if known)	Debian 8 Jessie
Webserver software & version (if known)	nginx 1.6.2
PHP Version	5.6.24

User List	There are no users monitoring this issue.

c_schmitz 2016-09-12 14:30 administrator ~40762	While there is no SQL error, the filter does not work on myssql, mssql either.

ollehar 2016-09-19 11:46 administrator ~40817	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=20485

ollehar 2016-09-19 14:53 administrator ~40819	Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=20495

c_schmitz 2016-09-20 10:48 administrator ~40827	Version 2.52 Build 160920 released

LimeSurvey: master cf3338ea 2016-09-19 11:45:55 ollehar Details Diff	Fixed issue 11644: SQL error in postgresql when filtering by date types in participants list and responses list	Affected Issues 11644
	mod - application/controllers/admin/responses.php	Diff File
	mod - application/models/SurveyDynamic.php	Diff File
	mod - application/models/TokenDynamic.php	Diff File
	mod - application/views/admin/responses/listResponses_view.php	Diff File
	mod - scripts/admin/listresponse.js	Diff File
LimeSurvey: master b0402934 2016-09-19 14:52:58 ollehar Details Diff	Fixed issue 11644: SQL error in postgresql when filtering by date types in participants list and responses list	Affected Issues 11644
	mod - application/models/SurveyDynamic.php	Diff File
	mod - application/models/TokenDynamic.php	Diff File
	mod - application/views/admin/responses/listResponses_view.php	Diff File
	mod - scripts/admin/listresponse.js	Diff File

Date Modified	Username	Field	Change
2016-09-10 15:27	aesteban	New Issue
2016-09-11 17:46	aesteban	Summary	SQL error in postgresql when filtering by valid from and valid until in survey participant list => SQL error in postgresql when filtering by date types in participants list and responses list
2016-09-11 17:46	aesteban	Description Updated
2016-09-11 17:46	aesteban	Steps to Reproduce Updated
2016-09-12 14:30	c_schmitz	Note Added: 40762
2016-09-14 13:47	c_schmitz	Priority	none => high
2016-09-16 15:25	ollehar	Assigned To	=> ollehar
2016-09-16 15:25	ollehar	Status	new => assigned
2016-09-16 15:26	ollehar	Product Version	2.52.x => 2.51.x
2016-09-19 11:46	ollehar	Changeset attached	=> LimeSurvey master cf3338ea
2016-09-19 11:46	ollehar	Note Added: 40817
2016-09-19 11:46	ollehar	Resolution	open => fixed
2016-09-19 14:53	ollehar	Changeset attached	=> LimeSurvey master b0402934
2016-09-19 14:53	ollehar	Note Added: 40819
2016-09-19 14:54	ollehar	Status	assigned => resolved
2016-09-19 14:54	ollehar	Fixed in Version	=> 2.51.x
2016-09-20 10:48	c_schmitz	Note Added: 40827
2016-09-20 10:48	c_schmitz	Status	resolved => closed
2016-12-08 10:39	c_schmitz	Category	Tokens => Survey participants (Tokens)