View Issue Details

This issue affects 1 person(s).
 8
IDProjectCategoryView StatusLast Update
09248Bug reportsSurvey takingpublic2014-09-26 10:09
Reporterlameventanas Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionno change required 
Product Version2.05+ 
Summary09248: Non anonymized survey responses submitdate is 1980-01-01
Description

A survey was created with the non-anonymize option set. The responses are stored with a submitdate of 1980-01-01.

mysql> select * from lime_surveys where sid = 856921 \G
1. row
sid: 856921
owner_id: 35
admin: CCC
active: Y
expires: 2014-09-10 00:00:00
startdate: 2014-09-01 00:00:00
adminemail: admin@mycompany.com
anonymized: N
faxto:
format: G
savetimings: N
template: basic_mycompany1
language: en
additional_languages: zh-Hans
datestamp: N
usecookie: N
allowregister: N
allowsave: N
autonumber_start: 7
autoredirect: N
allowprev: N
printanswers: N
ipaddr: N
refurl: N
datecreated: 2014-08-27
publicstatistics: N
publicgraphs: N
listpublic: N
htmlemail: Y
tokenanswerspersistence: N
assessments: N
usecaptcha: D
usetokens: N
bounce_email: someone@mycompany.com
attributedescriptions: NULL
emailresponseto:
emailnotificationto:
tokenlength: 15
showxquestions: Y
showgroupinfo: B
shownoanswer: Y
showqnumcode: X
bouncetime: NULL
bounceprocessing: N
bounceaccounttype: NULL
bounceaccounthost: NULL
bounceaccountpass: NULL
bounceaccountencryption: NULL
bounceaccountuser: NULL
showwelcome: Y
showprogress: Y
navigationdelay: 0
nokeyboard: N
alloweditaftercompletion: N
googleanalyticsstyle: 0
googleanalyticsapikey:
sendconfirmation: Y
questionindex: 0
1 row in set (0.00 sec)

mysql> select submitdate,count() from lime_survey_856921 group by submitdate;
+---------------------+----------+
| submitdate | count(
) |
+---------------------+----------+
| NULL | 32 |
| 1980-01-01 00:00:00 | 149 |
+---------------------+----------+
2 rows in set (0.00 sec)

TagsNo tags attached.
Bug heat8
Complete LimeSurvey version number (& build)2.05+ Build 140302
I will donate to the project if issue is resolvedNo
Browser
Database type & versionMySQL 5.6.5-m8
Server OS (if known)Linux
Webserver software & version (if known)Apache 2.2.27
PHP Version5.5.14

Users monitoring this issue

lameventanas, rnaujack

Activities

DenisChenu

DenisChenu

2014-09-25 12:18

developer   ~30695

datestamp: N

c_schmitz

c_schmitz

2014-09-26 10:09

administrator   ~30701

You have to activate datestamping

Issue History

Date Modified Username Field Change
2014-09-24 11:49 lameventanas New Issue
2014-09-24 11:50 lameventanas Issue Monitored: lameventanas
2014-09-24 14:42 rnaujack Issue Monitored: rnaujack
2014-09-25 12:18 DenisChenu Note Added: 30695
2014-09-26 10:09 c_schmitz Note Added: 30701
2014-09-26 10:09 c_schmitz Status new => closed
2014-09-26 10:09 c_schmitz Assigned To => c_schmitz
2014-09-26 10:09 c_schmitz Resolution open => no change required
2021-08-17 05:02 guest Bug heat 4 => 8