View Issue Details

This issue affects 1 person(s).
 10
IDProjectCategoryView StatusLast Update
08732Bug reportsInstallationpublic2014-03-02 12:29
Reporterfvanderstarre Assigned Toc_schmitz  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version2.00+ 
Summary08732: Survey create date, start date, expiry date not correctly displayed
Description

In our LimeSurvey system survey create date, start date and expiry date are incorrectly displayed. Survey creation date "2013-10-17 00:00:00.000" is shown as "01-07-2000".

Steps To Reproduce

Upgrade LimeSurvey from 1.90 (dbVersion 143) to 2.00+/2.05+ (164/176), or new installation.

Additional Information

pdo db_lib + FreeTDS

TagsNo tags attached.
Attached Files
adminscreen.jpg (7,238 bytes)   
adminscreen.jpg (7,238 bytes)   
sqlserver.jpg (5,779 bytes)   
sqlserver.jpg (5,779 bytes)   
setstartexpdate.jpg (19,752 bytes)   
setstartexpdate.jpg (19,752 bytes)   
showstartexpdate.jpg (21,787 bytes)   
showstartexpdate.jpg (21,787 bytes)   
Bug heat10
Complete LimeSurvey version number (& build)2.00+ Build 130929
I will donate to the project if issue is resolvedNo
BrowserFirefox, IE, Chrome
Database type & versionMicrosoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (VM)
Server OS (if known)DB server: Windows, Appl./Web server : Linux RHEL 5.8
Webserver software & version (if known)Apache/2.2.3 (Red Hat)
PHP Version5.3.3
Git branch / Pull Request URL

Users monitoring this issue

fvanderstarre, joop

Activities

c_schmitz

c_schmitz

2014-02-25 16:11

administrator   ~28906

I cannot reproduce. Does this happen if you use the latest 2.05 build and a new installation?

c_schmitz

c_schmitz

2014-02-25 16:12

administrator   ~28907

Where do you see this exactly. Can you provide a screenshot, please?

fvanderstarre

fvanderstarre

2014-02-27 07:47

reporter   ~28962

To test a new 2.05 installation I have to set up a new environment first.
The problem is also there in a 2.05 upgrade (see attached screen shots).

DenisChenu

DenisChenu

2014-02-27 10:22

developer   ~28968

It's due to language used in survey.

The date string seems to take the format of the survey, maybe there are some possibility to have different string in same response table (let me take a trye)

We don't use "admin user preference" here.

c_schmitz

c_schmitz

2014-02-27 12:11

administrator   ~28972

fvanderstarre: Your screenshot only shows 'date created' from the survey list

What about start date, expiry date ? Where do you see it showed wrong?

fvanderstarre

fvanderstarre

2014-02-27 12:19

reporter   ~28973

Please check uploaded images (setting survey start/expiry dates).

DenisChenu

DenisChenu

2014-02-27 12:45

developer   ~28977

@Carsten : date show are set to 'default' date format (the 1st language). Don't take 'admin choice' into account.

For each reponse line it's
function getExtendedAnswer($iSurveyID, $sFieldCode, $sValue, $oLanguage) in common_helper (need to force to admin choice ) ?
Not sure for other part.

DenisChenu

DenisChenu

2014-02-27 12:47

developer   ~28978

Last edited: 2014-02-27 12:48

PS:
@fvanderstarre : for http://bugs.limesurvey.org/file_download.php?file_id=6224&type=bug : it take your admin choice into account : it's OK here.
PS: see the doc : http://manual.limesurvey.org/First_login_-_Your_user_preferences#Date_format

Only for browse response

fvanderstarre

fvanderstarre

2014-02-27 13:38

reporter   ~28981

Last edited: 2014-02-27 13:39

@DenisChenu: I do not quite get your point, to me it is obvious that the date values shown are incorrect?
But in the database they are stored OK!

DenisChenu

DenisChenu

2014-02-27 13:43

developer   ~28982

Look at your admin choice for date : it's used your choice here.

fvanderstarre

fvanderstarre

2014-02-27 13:54

reporter   ~28983

My admin date format setting is "dd-mm-yyyy".

c_schmitz

c_schmitz

2014-02-27 14:10

administrator   ~28984

I see: This seems to be caused by an incorrect setting in FreeTDS.
Edit the /etc/freetds/locales.conf of freetds, remove all content and replace it with

[default]
date format = %Y-%m-%d %H:%M:%S.%z

Restart the webserver.

I will add this to the documentation

c_schmitz

c_schmitz

2014-02-27 14:23

administrator   ~28985

https://manual.limesurvey.org/Troubleshooting#Dates_are_not_correctly_displayed_using_MSSQL_Server_and_FreeTDS_on_Linux

fvanderstarre

fvanderstarre

2014-02-27 14:32

reporter   ~28988

Last edited: 2014-02-27 14:35

We have no such file as "/etc/freetds/locales.conf" on our system.
Just /etc/locales.conf but that seems to me to be a Linux thing.... and of course there is /etc/freetds.conf but no locale settings in there.

c_schmitz

c_schmitz

2014-02-27 14:41

administrator   ~28993

Sorry, I am not an Linux expert, so you will need to locate the locales.conf yourself - it depends on the Linux distro you are using.

fvanderstarre

fvanderstarre

2014-02-27 15:12

reporter   ~29002

I found the file (/etc/locales.conf) but this is not a FreeTDS-specific file, so how do I know it can be changed just like that without affecting other applications?

c_schmitz

c_schmitz

2014-02-27 15:25

administrator   ~29003

As said, you will need to ask a Linux export or google it.
Fact is that you need to set the right date format, as laid out.

fvanderstarre

fvanderstarre

2014-02-27 15:30

reporter   ~29004

I changed the default date format setting in /etc/locales.conf; this seemed to do the trick. Thank you.

c_schmitz

c_schmitz

2014-03-02 12:29

administrator   ~29050

2.0+ Build 140302 released.

Issue History

Date Modified Username Field Change
2014-02-17 10:12 fvanderstarre New Issue
2014-02-17 10:14 fvanderstarre Issue Monitored: fvanderstarre
2014-02-17 11:44 joop Issue Monitored: joop
2014-02-17 22:01 c_schmitz Assigned To => c_schmitz
2014-02-17 22:01 c_schmitz Status new => assigned
2014-02-25 16:11 c_schmitz Note Added: 28906
2014-02-25 16:11 c_schmitz Status assigned => feedback
2014-02-25 16:12 c_schmitz Note Added: 28907
2014-02-27 07:44 fvanderstarre File Added: adminscreen.jpg
2014-02-27 07:44 fvanderstarre File Added: sqlserver.jpg
2014-02-27 07:47 fvanderstarre Note Added: 28962
2014-02-27 07:47 fvanderstarre Status feedback => assigned
2014-02-27 10:22 DenisChenu Note Added: 28968
2014-02-27 12:11 c_schmitz Note Added: 28972
2014-02-27 12:11 c_schmitz Status assigned => feedback
2014-02-27 12:17 fvanderstarre File Added: setstartexpdate.jpg
2014-02-27 12:18 fvanderstarre File Added: showstartexpdate.jpg
2014-02-27 12:19 fvanderstarre Note Added: 28973
2014-02-27 12:19 fvanderstarre Status feedback => assigned
2014-02-27 12:45 DenisChenu Note Added: 28977
2014-02-27 12:47 DenisChenu Note Added: 28978
2014-02-27 12:48 DenisChenu Note Edited: 28978
2014-02-27 13:38 fvanderstarre Note Added: 28981
2014-02-27 13:39 fvanderstarre Note Edited: 28981
2014-02-27 13:43 DenisChenu Note Added: 28982
2014-02-27 13:54 fvanderstarre Note Added: 28983
2014-02-27 14:10 c_schmitz Note Added: 28984
2014-02-27 14:23 c_schmitz Note Added: 28985
2014-02-27 14:23 c_schmitz Status assigned => closed
2014-02-27 14:23 c_schmitz Resolution open => fixed
2014-02-27 14:32 fvanderstarre Note Added: 28988
2014-02-27 14:32 fvanderstarre Status closed => feedback
2014-02-27 14:32 fvanderstarre Resolution fixed => reopened
2014-02-27 14:35 fvanderstarre Note Edited: 28988
2014-02-27 14:41 c_schmitz Note Added: 28993
2014-02-27 14:41 c_schmitz Status feedback => resolved
2014-02-27 14:41 c_schmitz Resolution reopened => fixed
2014-02-27 15:12 fvanderstarre Note Added: 29002
2014-02-27 15:25 c_schmitz Note Added: 29003
2014-02-27 15:30 fvanderstarre Note Added: 29004
2014-03-02 12:29 c_schmitz Note Added: 29050
2014-03-02 12:29 c_schmitz Status resolved => closed
2021-09-29 22:22 guest Bug heat 6 => 10