View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
09375 | Bug reports | Response browsing | public | 2014-11-28 23:32 | 2015-02-11 15:57 |
Reporter | adolfocorreia | Assigned To | gabrieljenik | ||
Priority | normal | Severity | minor | ||
Status | closed | Resolution | no change required | ||
Product Version | 2.05+ | ||||
Summary | 09375: Wrong dates at survey results screen | ||||
Description | The survey results screen shows wrong values for the dates. It only shows dates in the years 1999 and 2000, even though all dates are in the year 2014. Please check attached file for a screenshot. When I edit the response or when I export the data, the dates are correct. I have found a similar bug: bug_id=6843. | ||||
Steps To Reproduce | Just open the survey results screen. | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 10 | ||||
Complete LimeSurvey version number (& build) | 140915 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | |||||
Database type & version | SQL Server | ||||
Server OS (if known) | RHEL 6.5 | ||||
Webserver software & version (if known) | Apache 2.2.15 | ||||
PHP Version | 5.3.3 | ||||
@gabrieljenik : i can take it, but of you have some times :). |
|
Leave it to me..! |
|
Adolfo, Can you please send me a survey to reproduce the issue? Thanks! |
|
Can you also please capture the screenshot that appears if you try to edit an answer? I believe there is something wrong on the way the info is stored on your DB. |
|
And the information of the Date format slected at personnal setings |
|
Thank you for checking this problem! I have uploaded some files. Is that all you asked for? |
|
Can't reproduce this still. This happens to new entries also? Thanks |
|
@adolfocorreia : to be uploaded:
|
|
@gabrieljenik @DenisChenu I have uploaded the files you requested in a password protected file since I didn't know how to make the bug report private. The password is in a private note. |
|
Set to private (i think you can do it too : edit button). |
|
File downloaded. File note with password deleted. |
|
The thing that keeps me wondering is the differnce on the submit date between the screenshots of the answer 20. I will look into it and let you know. |
|
If I see correctly, you are running Apache with SQL Server (the one from Microsoft)? If I am correct the value is stored correctly on native DB. Please could you confirm you are running Microsoft SQL Server? |
|
Also, does this happen with date questions you addess yourself? (As opposed to thw automatic date fields as start date) |
|
I was able to reproduce the issue with the values in the answers. $date = new Date_Time_Converter("Oct 23 2014 06:50:17:0000", "Y-m-d H:i:s"); The question is why SQL Server is returning the date values as "Oct 23 2014 06:50:17:0000". Can you please tell me your server or database settings regarding date formats? @DenisChenu, do you know anyone who deals or has more experience with MSSQL installations? |
|
@gabrieljenik : Carsten have a mssql server for testing/debug purpose |
|
Yes, I am using Microsoft SQL Server. I am checking the date format settings with the database team. I will get back to you as soon as I have some info. Thanks! |
|
In light of what you have pointed above, I have found out the reason SQL Server is returning the date values as "Oct 23 2014...". We are using the FreeTDS driver to access the database and the default date format in the file /etc/locales.conf is "%b %e %Y %I:%M:%S:%z%p". I changed it to "%Y-%m-%d %H:%M:%S" as you remarked as being the MySQL default and the dates are correctly shown now. We will check if there are errors in other pages, but I think the problem is solved. Thank you for your help! |
|
Great to hear that! |
|
Wrong locale config in DB driver caused date to e sent from the DB to the App in a format not expected by LS. |
|
Hi, maybe we have to put this in documentation (at minima) ? |
|
I will add that |
|
Seems it was already there. :( |
|
\o/ We have the best manual ;) |
|
Version 2.05 Build 150211 released |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2014-11-28 23:32 | adolfocorreia | New Issue | |
2014-11-28 23:32 | adolfocorreia | File Added: screenshot.3.png | |
2014-11-28 23:33 | adolfocorreia | Issue Monitored: adolfocorreia | |
2014-12-01 10:57 | DenisChenu | Assigned To | => DenisChenu |
2014-12-01 10:57 | DenisChenu | Status | new => assigned |
2014-12-02 14:51 | DenisChenu | Assigned To | DenisChenu => gabrieljenik |
2014-12-02 14:52 | DenisChenu | Note Added: 31143 | |
2014-12-16 21:03 | gabrieljenik | Note Added: 31276 | |
2014-12-16 21:39 | gabrieljenik | Note Added: 31277 | |
2014-12-16 21:44 | gabrieljenik | Note Added: 31278 | |
2014-12-17 08:13 | DenisChenu | Note Added: 31280 | |
2014-12-17 08:13 | DenisChenu | File Added: Capture du 2014-12-17 08:12:57.png | |
2014-12-17 19:32 | adolfocorreia | File Added: limesurvey_survey_794711.lss | |
2014-12-17 19:32 | adolfocorreia | File Added: screenshot.edit_answer.png | |
2014-12-17 19:33 | adolfocorreia | File Added: screenshot.personal_config.png | |
2014-12-17 19:35 | adolfocorreia | Note Added: 31296 | |
2014-12-18 12:50 | gabrieljenik | Note Added: 31297 | |
2014-12-18 13:19 | DenisChenu | Note Added: 31300 | |
2014-12-19 23:10 | adolfocorreia | File Added: files.7z | |
2014-12-19 23:11 | adolfocorreia | Note Added: 31321 | |
2014-12-19 23:14 | adolfocorreia | File Added: answer_20_view.png | |
2014-12-20 11:35 | DenisChenu | View Status | public => private |
2014-12-20 11:36 | DenisChenu | Note Added: 31323 | |
2014-12-22 19:55 | gabrieljenik | File Deleted: files.7z | |
2014-12-22 19:56 | gabrieljenik | Note Added: 31337 | |
2014-12-22 19:58 | gabrieljenik | Note Added: 31338 | |
2015-01-03 03:15 | gabrieljenik | Note Added: 31411 | |
2015-01-03 14:09 | gabrieljenik | Note Added: 31412 | |
2015-01-05 14:55 | gabrieljenik | Note Added: 31419 | |
2015-01-05 14:57 | gabrieljenik | View Status | private => public |
2015-01-05 15:12 | DenisChenu | Note Added: 31420 | |
2015-01-06 18:52 | adolfocorreia | Note Added: 31434 | |
2015-01-06 19:34 | adolfocorreia | Note Added: 31436 | |
2015-01-06 20:09 | gabrieljenik | Note Added: 31437 | |
2015-01-06 20:11 | gabrieljenik | Note Added: 31438 | |
2015-01-06 20:11 | gabrieljenik | Status | assigned => resolved |
2015-01-06 20:11 | gabrieljenik | Resolution | open => no change required |
2015-01-07 09:13 | DenisChenu | Note Added: 31440 | |
2015-01-07 12:13 | gabrieljenik | Note Added: 31442 | |
2015-01-07 13:03 | gabrieljenik | Note Added: 31443 | |
2015-01-07 14:35 | DenisChenu | Note Added: 31444 | |
2015-02-11 15:57 | c_schmitz | Note Added: 31673 | |
2015-02-11 15:57 | c_schmitz | Status | resolved => closed |
2021-08-03 07:24 | guest | Bug heat | 8 => 10 |