View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 08732 | Bug reports | Installation | public | 2014-02-17 10:12 | 2014-03-02 12:29 |
| Reporter | fvanderstarre | Assigned To | c_schmitz | ||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 2.00+ | ||||
| Summary | 08732: 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 | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 10 | ||||
| Complete LimeSurvey version number (& build) | 2.00+ Build 130929 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox, IE, Chrome | ||||
| Database type & version | Microsoft 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 Version | 5.3.3 | ||||
| Git branch / Pull Request URL | |||||
|
I cannot reproduce. Does this happen if you use the latest 2.05 build and a new installation? |
|
|
Where do you see this exactly. Can you provide a screenshot, please? |
|
|
To test a new 2.05 installation I have to set up a new environment first. |
|
|
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. |
|
|
fvanderstarre: Your screenshot only shows 'date created' from the survey list What about start date, expiry date ? Where do you see it showed wrong? |
|
|
Please check uploaded images (setting survey start/expiry dates). |
|
|
@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 |
|
|
PS: Only for browse response |
|
|
@DenisChenu: I do not quite get your point, to me it is obvious that the date values shown are incorrect? |
|
|
Look at your admin choice for date : it's used your choice here. |
|
|
My admin date format setting is "dd-mm-yyyy". |
|
|
I see: This seems to be caused by an incorrect setting in FreeTDS. [default] Restart the webserver. I will add this to the documentation |
|
|
We have no such file as "/etc/freetds/locales.conf" on our system. |
|
|
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. |
|
|
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? |
|
|
As said, you will need to ask a Linux export or google it. |
|
|
I changed the default date format setting in /etc/locales.conf; this seemed to do the trick. Thank you. |
|
|
2.0+ Build 140302 released. |
|
| 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 |