The update for Build no Version 1.92+ Build 120517 does not work.

More
5 years 2 months ago #80577 by krishna1088
krishna1088 created the topic: The update for Build no Version 1.92+ Build 120517 does not work.
Hi ,

I updated the survey tool to latest Version 1.92+ and Build 120517, but the submit date in the database table shows : 1980-01-01 00:00:00.


Is there a quick fix for this as our surveys are running live.


thanks,
Krishna

Please Log in to join the conversation.

More
5 years 2 months ago #80790 by sdrori
sdrori replied the topic: The update for Build no Version 1.92+ Build 120517 does not work.
I'm seeing the same problem, Krishna. two of the surveys we have had running for several months suddenly started writing that default date (01-01-1980) into their respective lime_survey_*****.submitdate fields. Interestingly, the corresponding token records have a valid (I assume correct) date in their lime_tokens_*****.completed fields.

We are also using Version 1.92+ Build 12517.

Sam

Please Log in to join the conversation.

More
5 years 2 months ago #80794 by sdrori
sdrori replied the topic: The update for Build no Version 1.92+ Build 120517 does not work.
Krishna,

Resolved the problem for my surveys. Here are the details, hope this helps.

Sam

After some more Googling of the problem I discovered the "Date stamp?" under Survey Settings / General Properties / Notification & data management. This allows one to turn on or off recording of the submit date for a survey response.

Sure enough this was turned off for both problem surveys, i.e: "Responses will NOT be date stamped. " As well the setting cannot be changed while the survey is active.

To resolve this would normally require de-activating each survey, updating its setting, and then re-starting it. HOWEVER, doing this might erase the existing survey response data, so you would need to first back-up all the data and then (after re-starting the survey) import the old data.

See this Lime Survey forum post:
www.limesurvey.org/en/forum/design-issue...-it-automatic-record

Since I did not want to de-activate the survey (and have to back-up and restore the response data) I resolved the problem by making changes to the Lime Survey MySQL database directly:

# This changes each survey's date stamp setting - be sure to use your survey's sid(s)
update boxcar_lime.lime_surveys
set datestamp = 'Y'
where sid = #SID#;

# because my surveys use tokens I was able to restore the submit dates as follows
update lime_survey_#SID# ls
inner join lime_tokens_#SID# lt on lt.token = ls.token
set ls.submitdate = lt.completed
where ls.submitdate='1980-01-01 00:00:00';

I don't know how this happened. As I wrote above both surveys have been up for several months and have not (to my knowledge) ever been de-activated been de-activated.

Somehow it did, and the above queries fix things, though I wonder if it might happen again.

Please Log in to join the conversation.

More
5 years 2 months ago #80809 by sdrori
sdrori replied the topic: The update for Build no Version 1.92+ Build 120517 does not work.
Hang-on!

One more thing to do: an additional column needs to be added to the lime_survey_##### table. Here's the query:

# adds the column datestamp to the survey response table
# substitute your survey's id for "#SID#"
alter TABLE `lime_survey_#SID#`
add column`datestamp` datetime NOT NULL after token;

Though turning on the date stamp seems to cause the submission time to be written to a separate field it also seems to have fixed the original problem, and I'm getting a meaningful date & time in the `submitdate` field as well.

Please Log in to join the conversation.

Did you already participate in our customer survey?

Don't miss your chance for great prices.

Please click here to participate:

Start now

Start now!

Just create your account and start using Limesurvey today.

Register now