Relationship Graph
View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
04026 | Bug reports | Survey taking | public | 2009-12-28 19:54 | 2010-01-09 00:33 |
Reporter | sokeking | Assigned To | c_schmitz | ||
Priority | normal | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 1.87RC5 | ||||
Fixed in Version | 1.87+ | ||||
Summary | 04026: 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. | ||||
Tags | No tags attached. | ||||
Bug heat | 12 | ||||
Complete LimeSurvey version number (& build) | 8159 | ||||
I will donate to the project if issue is resolved | |||||
Browser | Firefox 3.5.6 | ||||
Database type & version | MySQL 5.0.67 | ||||
Server OS (if known) | donno | ||||
Webserver software & version (if known) | |||||
PHP Version | 5.2.10 | ||||
Check your global settings and look what you set in the Time difference option |
|
Hi, |
|
Changing the time difference setting solved to problem for LimeSurvey user "elisa" ==> see LimeSurvey forum: |
|
HEY GREAT! IT WORKED! 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! |
|
Yes, this seems to be an upgrade bug. |
|
Well, but i didn't upgrade the system. It was a fresh installation of the RC. |
|
Ok thank you. |
|
This will be solved in the next Plus version. |
|
Great. It helped. Thank you guys :) |
|
is this a general problem with ms sql? All my date columns are filled with this value: 1970-01-01 01:00 |
|
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'. |
|
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 |
|
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 |
|
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 |
|
Note Added: 10717 | |
2010-01-05 11:30 |
|
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 |