View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
04530Bug reportsSurvey takingpublic2010-08-17 13:28
Reporterronvdburg Assigned Toc_schmitz  
PrioritynormalSeveritycrash 
Status closedResolutionfixed 
Product Version1.90 
Fixed in Version1.90+ 
Summary04530: Date is corrupted after switching to another group and back.
Description

The (calendar)date of a question is corrupted after switching to another group and back.

Steps To Reproduce

Use group-by-group mode.
Have a question of type date.
Execute survey.
Enter a date in the question.
Press <Next>
Press <Previous>
The date is now corrupted.

Additional Information

I used a closed survey.
The question is conditional.

TagsNo tags attached.
Attached Files
save.php (29,437 bytes)
Bug heat6
Complete LimeSurvey version number (& build)9046
I will donate to the project if issue is resolved
BrowserIE8 and also verified with FF 3.6.8
Database type & versionmysql 5.0.77
Server OS (if known)Centos 5.3 / Linux version 2.6.18
Webserver software & version (if known)apache 2.2.3
PHP Version5.1.6

Users monitoring this issue

ronvdburg

Activities

ronvdburg

ronvdburg

2010-08-12 12:28

reporter   ~12615

When dateformat is changed to 'yyyy-mm-dd', the problem disappears.

I verified previous versions of limesurvey:
= v1.85+ build 7593 = Corrupts data with format 'dd-mm-yyyy'. Ok using 'yyyy-mm-dd'. So, it already had this problem in v1.85+.
= v1.71+ build 5535 = Ok. It is using format 'YYYY-MM-DD'; this cannot be changed.

So my suggestion is that the problem was introduced between v1.71+ build 5535 and v1.85+ build 7593.

ronvdburg

ronvdburg

2010-08-12 13:00

reporter   ~12616

I also checked other formats in v1.90+ build 9046.
dd.mm.yyyy : corrupts data
dd-mm-yyyy : corrupts data
dd/mm/yyyy : corrupts data
yyyy.mm.dd : works okay
yyyy-mm-dd : works okay
yyyy/mm/dd : works okay
d.m.yyyy : corrupts date

12.8.2010 becomes 20.12.2007
12.9.2010 becomes 20.12.2008
1.1.2010 becomes 20.9.2012
2.1.2010 becomes 20.9.2012
9.1.2010 becomes 20.9.2012
10.1.2010 becomes 20.12.2000
11.1.2010 becomes 20.12.2000
19.1.2010 becomes 20.12.2000
20.1.2010 becomes 20.12.2000
31.1.2010 becomes 20.12.2000
1.2.2010 becomes 20.9.2012
10.2.2010 becomes 20.12.2001
1.3.2010 becomes 20.9.2012
10.3.2010 becomes 20.12.2002
31.1.2010 becomes 20.12.2000

20.12.2007 becomes 20.7.2012
20.7.2012 becomes 20.2.2007
20.2.2007 becomes 20.7.2002
20.7.2002 becomes 20.2.2007

mm-dd-yyyy : corrupts data; 08-12-2010 becomes 07-31-2003
mm.dd.yyyy : corrupts data; 08.12.2010 becomes 07.31.2009
mm-dd-yyyy : corrupts data; 08-12-2010 now becomes 07-31-2009 ???

There is a second entry mm-dd-yyyy in the survey settings:
yyyy-mm-dd : works okay

c_schmitz

c_schmitz

2010-08-12 14:40

administrator   ~12617

thank you for the great analysis - we will have a look asap

c_schmitz

c_schmitz

2010-08-12 14:45

administrator   ~12618

Another question: Did you test on an inactive survey only? Is there a difference to a normal active survey?

c_schmitz

c_schmitz

2010-08-12 14:49

administrator   ~12619

I cannot reproduce the problem. >Works fine here on active and inactive surveys.
Can you provide a tiny sample survey please?

ronvdburg

ronvdburg

2010-08-12 14:51

reporter   ~12620

I tested on active surveys only.

For active survey: I see in the database the correct data. So, the data is not corrupted during the <Next> operation, but during the <Previous> operation.

I now also tested on an inactive survey and have the same result. Uuuh... cached in the SESSION variables? Can I check that?

c_schmitz

c_schmitz

2010-08-12 14:59

administrator   ~12621

Last edited: 2010-08-12 14:59

As said, I can't reproduce here - I will need a sample survey. Maybe you did not properly update all your LimeSurvey files? Also try clearing your browser cache.
I just tried on our demo installation and it works fine there, too.

ronvdburg

ronvdburg

2010-08-12 15:21

reporter   ~12622

I created a new tiny survey and it did not reproduce. Clearing the browser cache did not solve the issue either.

So I will try what an apache restart does (server side cache?)

ronvdburg

ronvdburg

2010-08-12 15:28

reporter   ~12623

Clearing cache, restarting apache solves the data corruption in the tiny test survey, but not in the large (older) survey.

I will compary the definitions of the two surveys via phpMyAdmin...

c_schmitz

c_schmitz

2010-08-12 15:29

administrator   ~12624

Last edited: 2010-08-12 15:30

Yes, or make a copy of the survey where the corruption occurs and trim it down until the bug goes away - maybe it is another question influencing this or a certain configuration.

ronvdburg

ronvdburg

2010-08-12 16:06

reporter   ~12626

I am getting crazy...
I changes the new tiny survey to look like the old large survey (all the survey detailed settings) and now run into the situation:

Using the tiny survey:
<Previous> -> <Next> keeps the proper date.
<Next> -> <Previous> currupts the date.

So, what am I missing?

c_schmitz

c_schmitz

2010-08-12 16:24

administrator   ~12627

"<Previous> -> <Next> keeps the proper date.
<Next> -> <Previous> currupts the date."

I am not sure what that means, do you click first previous, then next? Why don't you attach the survey and add specfic instructions how to reproduce.

ronvdburg

ronvdburg

2010-08-12 16:36

reporter   ~12628

See uploaded tiny test survey.
I stripped all confidential data, so it only includes the test survey.
I also removed the users table.

To produce.
Do survey ==> you see the opening screen.
Press <Next> ==> you see the two questions on group 1.
Question 1: Fill in today's date.
Question 2: Fill in some blabla.
Press <Previous> ==> you see the opening screen again.
Press <Next> ==> you see the two questions on group 1. The date is still today's.
Now press <Next> ==> you progress to group 2 (for the first time).
Now press <Previous> ==> you go back to group 1 with two questions. However, the date for question 1 is now corrupted.
Indeed: first <Previous>

ronvdburg

ronvdburg

2010-08-12 17:53

reporter   ~12629

Would it be possible check if lime-calendar.js is still proper?

The java script looks like it has a fixed date format, but I cannot see if this is related with my problem.

c_schmitz

c_schmitz

2010-08-16 22:26

administrator   ~12635

Fixed in rev 9063

c_schmitz

c_schmitz

2010-08-16 22:26

administrator   ~12636

Thank you - attached fixed file.

ronvdburg

ronvdburg

2010-08-17 10:32

reporter   ~12643

I don't know why the saved.php fixed the issue, but it did. It is confirmed that date isn't corrupted anymore.

Still wondering why adding '&& postedfileds' did the trick... and why lime-calendar.js wasn't involved.

Anyway, thanks Carsten.

Issue History

Date Modified Username Field Change
2010-08-12 10:59 ronvdburg New Issue
2010-08-12 11:56 ronvdburg Issue Monitored: ronvdburg
2010-08-12 12:28 ronvdburg Note Added: 12615
2010-08-12 13:00 ronvdburg Note Added: 12616
2010-08-12 14:40 c_schmitz Assigned To => c_schmitz
2010-08-12 14:40 c_schmitz Status new => assigned
2010-08-12 14:40 c_schmitz Note Added: 12617
2010-08-12 14:45 c_schmitz Note Added: 12618
2010-08-12 14:49 c_schmitz Note Added: 12619
2010-08-12 14:51 ronvdburg Note Added: 12620
2010-08-12 14:59 c_schmitz Note Added: 12621
2010-08-12 14:59 c_schmitz Note Edited: 12621
2010-08-12 15:01 c_schmitz Status assigned => feedback
2010-08-12 15:21 ronvdburg Note Added: 12622
2010-08-12 15:21 ronvdburg Status feedback => assigned
2010-08-12 15:28 ronvdburg Note Added: 12623
2010-08-12 15:29 c_schmitz Note Added: 12624
2010-08-12 15:30 c_schmitz Note Edited: 12624
2010-08-12 16:06 ronvdburg Note Added: 12626
2010-08-12 16:24 c_schmitz Note Added: 12627
2010-08-12 16:31 ronvdburg File Added: LimeSurvey_limesurvey190_dump_2010-08-12.sql
2010-08-12 16:36 ronvdburg Note Added: 12628
2010-08-12 17:53 ronvdburg Note Added: 12629
2010-08-16 22:25 c_schmitz File Deleted: LimeSurvey_limesurvey190_dump_2010-08-12.sql
2010-08-16 22:26 c_schmitz Note Added: 12635
2010-08-16 22:26 c_schmitz Status assigned => resolved
2010-08-16 22:26 c_schmitz Fixed in Version => 1.90+
2010-08-16 22:26 c_schmitz Resolution open => fixed
2010-08-16 22:26 c_schmitz File Added: save.php
2010-08-16 22:26 c_schmitz Note Added: 12636
2010-08-17 10:32 ronvdburg Note Added: 12643
2010-08-17 13:28 c_schmitz Status resolved => closed
2010-10-25 00:18 c_schmitz Category Survey at Runtime => Survey taking
2021-08-03 13:02 guest Bug heat 4 => 6