View Issue Details

This bug affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
09375Bug reportsResponse browsingpublic2015-02-11 15:57
Reporteradolfocorreia Assigned Togabrieljenik  
PrioritynormalSeverityminor 
Status closedResolutionno change required 
Product Version2.05+ 
Summary09375: 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.

TagsNo tags attached.
Attached Files
screenshot.3.png (35,360 bytes)   
screenshot.3.png (35,360 bytes)   
screenshot.edit_answer.png (24,364 bytes)   
screenshot.edit_answer.png (24,364 bytes)   
screenshot.personal_config.png (16,017 bytes)   
screenshot.personal_config.png (16,017 bytes)   
answer_20_view.png (13,695 bytes)   
answer_20_view.png (13,695 bytes)   
Bug heat10
Complete LimeSurvey version number (& build)140915
I will donate to the project if issue is resolvedNo
Browser
Database type & versionSQL Server
Server OS (if known)RHEL 6.5
Webserver software & version (if known)Apache 2.2.15
PHP Version5.3.3

Users monitoring this issue

adolfocorreia

Activities

DenisChenu

DenisChenu

2014-12-02 14:52

developer   ~31143

@gabrieljenik : i can take it, but of you have some times :).

gabrieljenik

gabrieljenik

2014-12-16 21:03

manager   ~31276

Leave it to me..!

gabrieljenik

gabrieljenik

2014-12-16 21:39

manager   ~31277

Adolfo, Can you please send me a survey to reproduce the issue?
I have tried to reproduce it, but couldn't.

Thanks!

gabrieljenik

gabrieljenik

2014-12-16 21:44

manager   ~31278

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.

DenisChenu

DenisChenu

2014-12-17 08:13

developer   ~31280

And the information of the Date format slected at personnal setings

adolfocorreia

adolfocorreia

2014-12-17 19:35

reporter   ~31296

Thank you for checking this problem! I have uploaded some files. Is that all you asked for?

gabrieljenik

gabrieljenik

2014-12-18 12:50

manager   ~31297

Can't reproduce this still.
The timestamps in the answer #20 looks strange.
Can you please send me an export of one of your answers in Excel format and in VV format?

This happens to new entries also?
Have you switched languages once the survey has started?

Thanks

DenisChenu

DenisChenu

2014-12-18 13:19

developer   ~31300

@adolfocorreia : to be uploaded:

  • a LSA file (survey archive) : if needed : set this bug report to private
  • a Screenshot of your user preferences.
adolfocorreia

adolfocorreia

2014-12-19 23:11

reporter   ~31321

@gabrieljenik
Yes, it is happening to new entries. And I think we haven't changed the language since the survey has started (I'm not totally sure though, since I am not the only administrator).

@DenisChenu
I had already uploaded the user preferences (check file screenshot.personal_config.png above). Please let me know if that is what you asked for or if you need something else.

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.

DenisChenu

DenisChenu

2014-12-20 11:36

developer   ~31323

Set to private (i think you can do it too : edit button).
@gabrieljenik ; whenyou have dl and extract the file, we delete the file and remove the password, OK ?

gabrieljenik

gabrieljenik

2014-12-22 19:56

manager   ~31337

File downloaded. File note with password deleted.

gabrieljenik

gabrieljenik

2014-12-22 19:58

manager   ~31338

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.

gabrieljenik

gabrieljenik

2015-01-03 03:15

manager   ~31411

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.
Microsoft SQL Server, when outputting to the App, sends the value as Mmm d,y, and not as Y-m-d (usual in postgre or MySQL). Somehow these values are not being received as expected, and as so, not formatted correctly, and show strangely.

Please could you confirm you are running Microsoft SQL Server?

gabrieljenik

gabrieljenik

2015-01-03 14:09

manager   ~31412

Also, does this happen with date questions you addess yourself? (As opposed to thw automatic date fields as start date)

gabrieljenik

gabrieljenik

2015-01-05 14:55

manager   ~31419

I was able to reproduce the issue with the values in the answers.
This codepad (http://codepad.org/vgCEvJgT) simulates the Date_Time_Converter usage:

$date = new Date_Time_Converter("Oct 23 2014 06:50:17:0000", "Y-m-d H:i:s");
$D = $date->convert("d-m-Y 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?

DenisChenu

DenisChenu

2015-01-05 15:12

developer   ~31420

@gabrieljenik : Carsten have a mssql server for testing/debug purpose

adolfocorreia

adolfocorreia

2015-01-06 18:52

reporter   ~31434

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!

adolfocorreia

adolfocorreia

2015-01-06 19:34

reporter   ~31436

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!

gabrieljenik

gabrieljenik

2015-01-06 20:09

manager   ~31437

Great to hear that!

gabrieljenik

gabrieljenik

2015-01-06 20:11

manager   ~31438

Wrong locale config in DB driver caused date to e sent from the DB to the App in a format not expected by LS.

DenisChenu

DenisChenu

2015-01-07 09:13

developer   ~31440

Hi, maybe we have to put this in documentation (at minima) ?

gabrieljenik

gabrieljenik

2015-01-07 12:13

manager   ~31442

I will add that

gabrieljenik

gabrieljenik

2015-01-07 13:03

manager   ~31443

Seems it was already there. :(
https://manual.limesurvey.org/Troubleshooting#Dates_are_not_correctly_displayed_using_MSSQL_Server_with_FreeTDS_on_Linux

DenisChenu

DenisChenu

2015-01-07 14:35

developer   ~31444

\o/ We have the best manual ;)

c_schmitz

c_schmitz

2015-02-11 15:57

administrator   ~31673

Version 2.05 Build 150211 released

Issue History

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