View Issue Details

This issue affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
07303Bug reportsData Entry (non public)public2013-02-15 19:04
Reportermalberghini Assigned ToDenisChenu  
PrioritynormalSeveritypartial_block 
Status closedResolutionno change required 
Product Version2.00+ 
Summary07303: All surveys have a submitdate of 1980-01-01
Description

All surveys are having the submitdate of responses set as 1980-01-01 00:00:00

Steps To Reproduce
  1. Submit any survey
Additional Information

From our MySQL logs:

919012 Query UPDATE lime_survey_768818 SET submitdate='1980-01-01 00:00:00' WHERE ID=21

919073 Query UPDATE lime_survey_242461 SET submitdate='1980-01-01 00:00:00' WHERE ID=1

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)130213
I will donate to the project if issue is resolvedNo
BrowserChrome on Mac OSX 10.7.5
Database type & versionmysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i386) using readline 5.1
Server OS (if known)Linux 2.6.18-274.el5 (red hat)
Webserver software & version (if known)Apache/2.2.3
PHP Version2.2.0
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2013-02-15 10:11

developer   ~24093

What is your survey setting ?

DenisChenu

DenisChenu

2013-02-15 10:14

developer   ~24095

See documentation date_stamp:
http://docs.limesurvey.org/Creating+a+new+survey#Notification_amp_data_management

malberghini

malberghini

2013-02-15 18:31

reporter   ~24119

The survey settings are set to No for the Date Stamp option. It's setting an obviously incorrect date stamp. My suggestion is to record NULL instead of 1980-01-01 00:00:00 when the option is set to not record.

DenisChenu

DenisChenu

2013-02-15 19:04

developer   ~24120

No,

NULL mean "not submitted" and it's a date SQL.
mySQL accept 0000-00-00 but (maybe) msSQL not (or other SQLLite? when we made the option).

Issue History

Date Modified Username Field Change
2013-02-14 20:38 malberghini New Issue
2013-02-15 10:11 DenisChenu Note Added: 24093
2013-02-15 10:11 DenisChenu Assigned To => DenisChenu
2013-02-15 10:11 DenisChenu Status new => assigned
2013-02-15 10:14 DenisChenu Note Added: 24095
2013-02-15 18:31 malberghini Note Added: 24119
2013-02-15 19:04 DenisChenu Note Added: 24120
2013-02-15 19:04 DenisChenu Status assigned => closed
2013-02-15 19:04 DenisChenu Resolution open => no change required