View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 2
IDProjectCategoryView StatusDate SubmittedLast Update
12711Bug reportsSurvey takingpublic2017-09-26 13:452017-10-12 09:16
ReporterDenisChenu Assigned ToDenisChenu  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.70.x 
Fixed in Version2.70.x 
Summary12711: Date with dropdow throw SQL error with pgsql
Description

With debug at 2 : Date with dropdow throw SQL error with pgsql. And error shown "Save value in DB error".

Steps To Reproduce

Create a date with dropdown
Activate
Set 2017-02-31 for date

Additional Information

When fix the error: see «Could not convert date Invalid date to format y-d-d. Please check your date format settings.»
I think it's for Admin not user :).

TagsNo tags attached.
Bug heat2
Complete LimeSurvey version number (& build)2.71.0
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionpgsql
Server OS (if known)debian
Webserver software & version (if known)apache
PHP VersionPHP5.6

Relationships

Relationship GraphDependency Graph
related to 09643 closedDenisChenu Date/Time question with drop down values fails validation when only one value is selected and MySQL is not the database 

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2017-09-26 13:47

developer   ~44475

There are multiple solution,

if ($dateTime === false) => $value = "INVALID";. But then show the badly "front-end" helper.

I must test woithout javascript and a text string to see what happen.
DenisChenu

DenisChenu

2017-09-26 14:07

developer   ~44477

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

Related Changesets

LimeSurvey: master 06e58a73

2017-09-26 14:07:18

DenisChenu

Details Diff 		Fixed issue 12711: Date with dropdow throw SQL error with pgsql
Dev: Must disable save bad value in DB in any condition
Dev: partial fix because question is not set as invalid
Dev: didn't remind if we fixed it in 3.0		 Affected Issues
12711
mod - application/helpers/expressions/em_manager_helper.php Diff File

Issue History

Date Modified Username Field Change
2017-09-26 13:45 DenisChenu New Issue
2017-09-26 13:47 DenisChenu Note Added: 44475
2017-09-26 14:07 DenisChenu Changeset attached => LimeSurvey master 06e58a73
2017-09-26 14:07 DenisChenu Note Added: 44477
2017-09-26 14:07 DenisChenu Assigned To => DenisChenu
2017-09-26 14:07 DenisChenu Resolution open => fixed
2017-09-26 14:10 DenisChenu Relationship added related to 09643
2017-09-27 09:25 DenisChenu Status new => resolved
2017-09-27 09:25 DenisChenu Fixed in Version => 2.70.x
2017-10-12 09:16 c_schmitz Status resolved => closed