View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 07303 | Bug reports | Data Entry (non public) | public | 2013-02-14 20:38 | 2013-02-15 19:04 |
| Reporter | malberghini | Assigned To | DenisChenu | ||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | no change required | ||
| Product Version | 2.00+ | ||||
| Summary | 07303: All surveys have a submitdate of 1980-01-01 | ||||
| Description | All surveys are having the submitdate of responses set as 1980-01-01 00:00:00 | ||||
| Steps To Reproduce |
| ||||
| Additional Information | From our MySQL logs: 919012 Query UPDATE lime_survey_768818 SET 919073 Query UPDATE lime_survey_242461 SET | ||||
| Tags | No tags attached. | ||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 130213 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Chrome on Mac OSX 10.7.5 | ||||
| Database type & version | mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i386) using readline 5.1 | ||||
| Server OS (if known) | Linux 2.6.18-274.el5 (red hat) | ||||
| Webserver software & version (if known) | Apache/2.2.3 | ||||
| PHP Version | 2.2.0 | ||||
| Git branch / Pull Request URL | |||||
|
What is your survey setting ? |
|
|
See documentation date_stamp: |
|
|
The survey settings are set to No for the Date Stamp option. It's setting an obviously incorrect date stamp. My suggestion is to record NULL instead of 1980-01-01 00:00:00 when the option is set to not record. |
|
|
No, NULL mean "not submitted" and it's a date SQL. |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2013-02-14 20:38 | malberghini | New Issue | |
| 2013-02-15 10:11 | DenisChenu | Note Added: 24093 | |
| 2013-02-15 10:11 | DenisChenu | Assigned To | => DenisChenu |
| 2013-02-15 10:11 | DenisChenu | Status | new => assigned |
| 2013-02-15 10:14 | DenisChenu | Note Added: 24095 | |
| 2013-02-15 18:31 | malberghini | Note Added: 24119 | |
| 2013-02-15 19:04 | DenisChenu | Note Added: 24120 | |
| 2013-02-15 19:04 | DenisChenu | Status | assigned => closed |
| 2013-02-15 19:04 | DenisChenu | Resolution | open => no change required |