View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
15199 | Bug reports | Survey taking | public | 2019-08-27 18:43 | 2019-09-02 10:42 |
Reporter | DenisChenu | Assigned To | DenisChenu | ||
Priority | none | Severity | minor | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.17.x | ||||
Fixed in Version | 3.17.x | ||||
Summary | 15199: MSSQL : date/time question are not reloaded properly | ||||
Description | When using MSSQL : date time question broken when reload survey (via resume later option) | ||||
Steps To Reproduce |
| ||||
Additional Information | IN DB datetime are saved as Surely need to remove the extra .000 … | ||||
Tags | No tags attached. | ||||
Attached Files | |||||
Bug heat | 6 | ||||
Complete LimeSurvey version number (& build) | 3.17.13 | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | firefox | ||||
Database type & version | SQLServer | ||||
Server OS (if known) | windowserver 2016 | ||||
Webserver software & version (if known) | IIS | ||||
PHP Version | 7.2.16 | ||||
Abstracting the whole datetime questions to hide the db differences are badly needed. The NULL vs empty issue (answering behavior) is demanding a change too. I'm not using MS SQL with LimeSurvey, but when you state you need to remove the extra .000, I wonder what datatype is expected? The recommendation for "most" compatible to SQL Standard is to use only datetime smalldatetime datetime2 datetimeoffset Changing types via CAST will result in different times. The most common mapping between MySQL and SQLServer seems to be this: |
|
smalldatetime , yes maybe we can set this in mssql … About null VS empty : mysql accept 0000-00-00 00:00:00 for date time (if you set as ""), but not mssql. |
|
Can you quickly check if you same issue on pgsql ? Then i think you can have same issue (if not … it's something other …) |
|
Sorry, I'm currently not running a Postgres test environment. SQL -> PostGres Correct, MySQL allows to store '0000-00-00' ... to data types related to dates. You sometimes see conversion tools adding NULL for these fields. The masterplan for getting MySQL, SQLServer and PSQL abstracted so that the questions types can be coded without DB exceptions is overdue. |
|
@jelo : the NULL vs empty value already have their feature if i remind … this is not related to this issue Checkjed with pgsql : OK for YY-M-D H:i:s like mysql : Isue only for mssql |
|
https://github.com/LimeSurvey/LimeSurvey/commit/c3ab1051f02e5a2c2de551c05b55d3aee09ae66f |
|
Fixed in Release 3.17.14+190902 |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2019-08-27 18:43 | DenisChenu | New Issue | |
2019-08-27 18:43 | DenisChenu | Status | new => assigned |
2019-08-27 18:43 | DenisChenu | Assigned To | => DenisChenu |
2019-08-27 18:43 | DenisChenu | File Added: survey_archive_dateIssue.lsa | |
2019-08-28 11:02 | jelo | Note Added: 53321 | |
2019-08-28 11:12 | DenisChenu | Note Added: 53322 | |
2019-08-28 11:34 | DenisChenu | Assigned To | DenisChenu => LimeBot |
2019-08-28 11:34 | DenisChenu | Status | assigned => feedback |
2019-08-28 11:34 | DenisChenu | Note Added: 53323 | |
2019-08-28 11:35 | DenisChenu | Assigned To | LimeBot => DenisChenu |
2019-08-28 11:35 | DenisChenu | Status | feedback => assigned |
2019-08-28 12:36 | jelo | Note Added: 53325 | |
2019-08-28 13:18 | DenisChenu | Note Added: 53326 | |
2019-08-28 13:23 | DenisChenu | Note Edited: 53326 | |
2019-08-28 13:51 | DenisChenu | Status | assigned => resolved |
2019-08-28 13:51 | DenisChenu | Resolution | open => fixed |
2019-08-28 13:51 | DenisChenu | Fixed in Version | => 3.17.x |
2019-08-28 13:51 | DenisChenu | Note Added: 53327 | |
2019-09-02 10:42 | lime_release_bot | Note Added: 53376 | |
2019-09-02 10:42 | lime_release_bot | Status | resolved => closed |