View Issue Details

This bug affects 1 person(s).
 12
IDProjectCategoryView StatusLast Update
04026Bug reportsSurvey takingpublic2010-01-09 00:33
Reportersokeking Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.87RC5 
Fixed in Version1.87+ 
Summary04026: Date Format Problems (PHP)
Description

In a non-anonymous survey all collected data hast 01.01.1970 01:00 as timestamp. I cannot influence this issue by changing the surveys date-format.

Also very curious is, that the backup file of the databasis is named LimeSurvey_XXX_dump_1970-01-01.sql.

Additional Information

I got help in the IRC chat. Perhaps the questions i was asked there help to analyze the problem:

I'm using PHP Version 5.2.10 and MySQL 5.0.67 on a all-inkl.com server. On that server are also running: phpbb3 and a website - both using a databasis and php with date-fomat.

Limesurvey hasn't this problem on my localhost. But there i'm using PHP 5.3.1.

TagsNo tags attached.
Bug heat12
Complete LimeSurvey version number (& build)8159
I will donate to the project if issue is resolved
BrowserFirefox 3.5.6
Database type & versionMySQL 5.0.67
Server OS (if known)donno
Webserver software & version (if known)
PHP Version5.2.10

Relationships

related to 04031 closedc_schmitz Updates 

Users monitoring this issue

n_r

Activities

c_schmitz

c_schmitz

2010-01-04 17:39

administrator   ~10700

Check your global settings and look what you set in the Time difference option

n_r

n_r

2010-01-04 22:21

reporter   ~10702

Hi,
i got the absolutely same problem!
I cant discover the bug neither. My time difference ist set to 'hours'. If this is what you mean.

user372

2010-01-04 22:23

  ~10703

Changing the time difference setting solved to problem for LimeSurvey user "elisa" ==> see LimeSurvey forum:
https://www.limesurvey.org/en/support/forums/1-installation-a-update-issues/35946-no-expired-surveys-after-upgrading#35974

sokeking

sokeking

2010-01-05 00:17

reporter   ~10704

HEY GREAT! IT WORKED!
Besides that, this still seems to be a bug. The setting I had before changing it to '0' was 'hours' - same like in this thread i recently found:
https://www.limesurvey.org/de/support/hilfe-foren/1-installation-a-update-issues/35472-invite-sent--print-1969-12-31-2100

If you need any further information from me to find the bug, i would be pleased to help you guys.

Thanks a lot for the great help!

c_schmitz

c_schmitz

2010-01-05 00:35

administrator   ~10705

Yes, this seems to be an upgrade bug.
I will have to find out why it happens.

sokeking

sokeking

2010-01-05 00:42

reporter   ~10706

Last edited: 2010-01-05 00:43

Well, but i didn't upgrade the system. It was a fresh installation of the RC.

c_schmitz

c_schmitz

2010-01-05 01:17

administrator   ~10707

Ok thank you.

c_schmitz

c_schmitz

2010-01-05 01:18

administrator   ~10708

This will be solved in the next Plus version.
For now go to Global settings and set time difference to "0".

n_r

n_r

2010-01-05 08:55

reporter   ~10711

Great. It helped. Thank you guys :)

user4627

2010-01-05 11:30

  ~10717

is this a general problem with ms sql? All my date columns are filled with this value: 1970-01-01 01:00

sokeking

sokeking

2010-01-05 19:10

reporter   ~10724

No it isn't! Its caused by the software when formating the date field. You can see that when backing up the database within limesurvey. Part of the name of the backup file has the same odd value '1970-01-01'.

Issue History

Date Modified Username Field Change
2009-12-28 19:54 sokeking New Issue
2009-12-28 19:54 sokeking Status new => assigned
2009-12-28 19:54 sokeking Assigned To => user372
2009-12-28 19:54 sokeking LimeSurvey build number => 8159
2009-12-28 19:54 sokeking Browser => Firefox 3.5.6
2009-12-28 19:54 sokeking Database & DB-Version => MySQL 5.0.67
2009-12-28 19:54 sokeking Operating System (Server) => donno
2009-12-28 19:54 sokeking Webserver => all-inkl.com
2009-12-28 19:54 sokeking PHP Version => 5.2.10
2010-01-03 20:25 user372 Assigned To user372 => c_schmitz
2010-01-04 17:39 c_schmitz Note Added: 10700
2010-01-04 17:40 c_schmitz Webserver all-inkl.com =>
2010-01-04 17:40 c_schmitz View Status private => public
2010-01-04 22:18 n_r Issue Monitored: n_r
2010-01-04 22:21 n_r Note Added: 10702
2010-01-04 22:23 user372 Note Added: 10703
2010-01-05 00:17 sokeking Note Added: 10704
2010-01-05 00:35 c_schmitz Note Added: 10705
2010-01-05 00:42 sokeking Note Added: 10706
2010-01-05 00:43 sokeking Note Edited: 10706
2010-01-05 01:17 c_schmitz Note Added: 10707
2010-01-05 01:18 c_schmitz Note Added: 10708
2010-01-05 01:18 c_schmitz Status assigned => resolved
2010-01-05 01:18 c_schmitz Fixed in Version => 1.87+
2010-01-05 01:18 c_schmitz Resolution open => fixed
2010-01-05 01:23 c_schmitz Relationship added related to 04031
2010-01-05 08:55 n_r Note Added: 10711
2010-01-05 11:30 user4627 Note Added: 10717
2010-01-05 11:30 user4627 Issue Monitored: user4627
2010-01-05 19:10 sokeking Note Added: 10724
2010-01-09 00:33 c_schmitz Status resolved => closed
2010-10-25 00:18 c_schmitz Category Survey at Runtime => Survey taking
2021-08-03 01:40 guest Bug heat 10 => 12