Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82034

Hi there - first of all I love LimeSurvey, thank you all for your hard work.

I have a survey running - all going well - and have always updated (3-click comfort update so I'm running Version 1.92+ Build 120613) when needed. Now, part way through, my surveys aren't logging the 'date last action' and 'date started' properly - it always now logs as "1980-01-01 00:00:00"

Screenshot below:


I've not changd the survey or any settings. What's happening please?
Last Edit: 4 years 2 months ago by planneroftowns.
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82036

  • Ben_V
  • Ben_V's Avatar
  • Offline
  • Platinum Lime
  • Posts: 1805
  • Thank you received: 445
  • Karma: 111
Are you working (localy) on a virtual server?
Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
All LS releases => bit.ly/1VMuTDu | 2.06lts => bit.ly/1Qv44A1
Demo surveys => bit.ly/20NW9V8 (already included in /docs/demosurveys)
Last Edit: 4 years 2 months ago by Ben_V.
The administrator has disabled public write access.
The following user(s) said Thank You: planneroftowns

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82038

benitov wrote:
Are you working (localy) on a virtual server?

No, on 1&1 shared hosting.

If it helps rule something out, there's also a forum (phpBB) running and the dates on that are okay so I think the server time is set correctly.

And in LimeSurvey, global settings, general is showing the correct date and time (with a -1 offset applied for daylight savings here in the UK).

It's confusing, isn't it!
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82043

  • lowprofile
  • lowprofile's Avatar
  • Offline
  • Junior Lime
  • Posts: 22
  • Thank you received: 1
  • Karma: 0
Don't the most recent responses come at the bottom of the page, eg, newer responses have a correct date according to your screenshot
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82049

lowprofile wrote:
Don't the most recent responses come at the bottom of the page, eg, newer responses have a correct date according to your screenshot

I think it depends on which 'view' of the response you use.

Clicking 'display responses'

Loads them in 'ascending order (older first and what you're referring to)

Whilst clicking 'display last 50 responses'

Loads them the other way round, newest first. That's what I as using when I took the screenshot. If you look at the responseID column, you'll see they're that way round.

So it is definitely only the latest responses that are coming up with the odd date/time. It was working fine for a few weeks. Perhaps one of the latest updates has broken something?
Last Edit: 4 years 2 months ago by planneroftowns.
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82067

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5977
  • Thank you received: 368
  • Karma: 260
planneroftowns wrote:
So it is definitely only the latest responses that are coming up with the odd date/time. It was working fine for a few weeks. Perhaps one of the latest updates has broken something?
Most probably there has been a bug fix which causes the different behavior.

Check if your survey is set to be non anonymous. In this case fake dates are used to enhance privacy. This might have been buggy and fixed recently.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
The following user(s) said Thank You: planneroftowns

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82077

Mazi wrote:
planneroftowns wrote:
So it is definitely only the latest responses that are coming up with the odd date/time. It was working fine for a few weeks. Perhaps one of the latest updates has broken something?
Most probably there has been a bug fix which causes the different behavior.

Check if your survey is set to be non anonymous. In this case fake dates are used to enhance privacy. This might have been buggy and fixed recently.

Ah, this sounds like it could be the reason. Thank you very much for your response. The survey is set as anonymous displayed via:
general settings - tokens - Anonymized responses? Answers to this survey are anonymized. (Cannot be changed)

However, I was confused as it also says under
general settings - notification and data management - Date stamp? Responses will be date stamped. (Cannot be changed)

Which I thought meant that I could see the date/time of responses. And that is what had been happening to date.

I don't want to use a token-basd survey in this instance - I am sending out an 'open call' for survey responses and then when people answer the survey they give their name and email address as part of the response. So I have their permission to record and store it with the responses, but didnt want them to have to go through the registration hassle of getting a token as I think this would reduce my overall number of repsonses. The survey does not have a token table associated with it.

Ideally, I'd like to roll-back to the previous (buggy!) version so that I can continue to record this date/time information but I notice that the latest update changed the database schema. So it sounds like going backwards would be a bit messy...

It is possible/desirable to roll back?

It seems a bit odd that you can't tell when a response was submitted, just from the point of view of letting you track how well responses are coming in over time, whether the responses are drying up etc. Does knowing a date and time risk anonymity? Limesurvey happily records the IP address which I would have thought would be more of an issue

As a work around I'll now have to go in each day and rename the responses with today's date (less worried about the time). But quite a manual work-around if there are lots of responses.

Can you please suggest how I might modify my limesurvey to allow this date information to be recorded?

Or could it perhaps be an option in future updates? Obviously, I appreciate I am only one person/user.
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82107

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5977
  • Thank you received: 368
  • Karma: 260
- I don't recommend to roll back to the previous version.

- A survey can be non anonymous and NOT use tokens. Simply don't create a token table and do not agree to switch to private mode when activating the survey.

- I'm not sure where how the link to the survey is distributed, but it might be an alternative to create a copy of the survey, set it to be non anonymous and distribute the link to the new survey.
You should be able to merge data later at SPSS or Excel or maybe even inside Limesurvey by using VV export/import and adapting the file structure: docs.limesurvey.org/Exporting+results&st...Export_and_VVImport_

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
The following user(s) said Thank You: planneroftowns

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82112

Thank you very much indeed for your help - the support has been very quick and helpful. I think you're right - I'll export the survey data, deactivate the survey, change the settings and then reactivate. I'm off to leave a donation! :laugh:
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82132

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5977
  • Thank you received: 368
  • Karma: 260
Thanks for supporting Limesurvey!

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82343

  • dcordova
  • dcordova's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
Hi!

Well I'm having the same issue after updating to Version 1.92+ Build 120613, all my active surveys are saving responses with this time amd date stamp: 1980-01-01 00:00:00.

My settings for Date stamp:

Date stamp? Responses will be date stamped. (Cannot be changed)

My settings for Anonymized Responses

Anonymized responses? Answers to this survey are anonymized. (Cannot be changed)

I didn't have this issue before (and I've been working for a year with LS), any help or fix that maybe I'm not aware of?

Thanks for the help!
Last Edit: 4 years 2 months ago by dcordova.
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82345

  • TMSWhite
  • TMSWhite's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 758
  • Thank you received: 83
  • Karma: 37
There was a bug in an older 1.92+ release that let anonymous surveys save those dates when "Date Stamp" was true. That bug has since been fixed, so if the survey is anonymous, responses are now being logged as 1980-01-01 00:00:00 even if "Date Stamp" is true.
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82346

  • dcordova
  • dcordova's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
So I will have to create tokens tables form now on? in order to get the Date Stamp?
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82347

  • dcordova
  • dcordova's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 15
  • Karma: 0
Don't even mind to answer my last question, I already found out I don't need those!

I already fixed it!

SO thanks Again!!
The administrator has disabled public write access.

Survey Complete dates did work... now new responses logged as 1980-01-01 00:00:0 4 years 2 months ago #82348

  • Mazi
  • Mazi's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 5977
  • Thank you received: 368
  • Karma: 260
dcordova wrote:
SO thanks Again!!
You're welcome :-)

If our hints have been helpful and you enjoy limesurvey please consider a donation to give Limesurvey a future .
We do all this in our free time and you don't have to pay a penny for this software.

Without your help we can't keep this project alive.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.284 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form