View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 06018 | Bug reports | Response browsing | public | 2012-04-16 13:31 | 2012-04-18 22:58 |
| Reporter | Mazi | Assigned To | c_schmitz | ||
| Priority | normal | Severity | minor | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.92+ | ||||
| Fixed in Version | 1.92+ | ||||
| Summary | 06018: Using mssqlnative the "date" question type uses DATETIME type and not DATE | ||||
| Description | When using MS SQL server 2008 and mssqlnative driver, Limesurvey creates a DATETIME field for date questions. Thus, "12:00:00" is added to the date. | ||||
| Steps To Reproduce | Create a date question type for a MS SQL based system and check the lime_survey_12345 table after activation. | ||||
| Additional Information | Problem might show up at LS 2 as well. | ||||
| Tags | No tags attached. | ||||
| Attached Files | |||||
| Bug heat | 4 | ||||
| Complete LimeSurvey version number (& build) | 120405 | ||||
| I will donate to the project if issue is resolved | No | ||||
| Browser | Firefox 9 | ||||
| Database type & version | MySQL 5 | ||||
| Server OS (if known) | Win 7 | ||||
| Webserver software & version (if known) | Apache 2.2 | ||||
| PHP Version | 5.3.1 | ||||
| Git branch / Pull Request URL | |||||
|
Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8168 |
|
|
The DB related problem seems to be solved, well done. There still seems to be a driver related problem (see atatched screenshots): At the MS SQL based system, the result of a date question type is shown with "00:00:00" while at my local MySQL system it is correctly shown as date only without additional time information. |
|
|
Yeah, I am sorry, but you will have to live with that for now. |
|
|
1.92+ release |
|
|
LimeSurvey: master ea8dad84 2012-04-16 07:22 Details Diff |
Fixed issue 06018: Using mssqlnative the "date" question type uses DATETIME type and not DATE |
Affected Issues 06018 |
|
| mod - admin/questiongrouphandling.php | Diff File | ||
| mod - classes/adodb/datadict/datadict-mssql.inc.php | Diff File | ||
| mod - classes/adodb/datadict/datadict-mssqlnative.inc.php | Diff File | ||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2012-04-16 13:31 | Mazi | New Issue | |
| 2012-04-16 13:31 | Mazi | Status | new => assigned |
| 2012-04-16 13:31 | Mazi | Assigned To | => c_schmitz |
| 2012-04-16 13:31 | Mazi | File Added: Unbenannt.PNG | |
| 2012-04-16 14:21 | c_schmitz | Status | assigned => resolved |
| 2012-04-16 14:21 | c_schmitz | Fixed in Version | => 1.92+ |
| 2012-04-16 14:21 | c_schmitz | Resolution | open => fixed |
| 2012-04-16 14:22 | c_schmitz | Changeset attached | => LimeSurvey master ea8dad84 |
| 2012-04-16 14:22 | c_schmitz | Note Added: 18372 | |
| 2012-04-16 15:48 | Mazi | Note Added: 18377 | |
| 2012-04-16 15:48 | Mazi | Status | resolved => assigned |
| 2012-04-16 15:49 | Mazi | File Added: date_mysql.png | |
| 2012-04-16 15:49 | Mazi | File Added: date_mssql.png | |
| 2012-04-16 15:49 | Mazi | File Added: date_mssql_db.png | |
| 2012-04-17 09:36 | c_schmitz | Note Added: 18401 | |
| 2012-04-17 09:36 | c_schmitz | Status | assigned => resolved |
| 2012-04-18 22:58 | c_schmitz | Note Added: 18420 | |
| 2012-04-18 22:58 | c_schmitz | Status | resolved => closed |