View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06018Bug reportsResponse browsingpublic2012-04-16 13:312012-04-18 22:58
ReporterMazi Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.92+ 
Target Version1.92+Fixed in Version1.92+ 
Summary06018: 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.

TagsNo tags attached.
Attached Files
Unbenannt.PNG (1,424 bytes)   
Unbenannt.PNG (1,424 bytes)   
date_mysql.png (2,086 bytes)   
date_mysql.png (2,086 bytes)   
date_mssql.png (1,320 bytes)   
date_mssql.png (1,320 bytes)   
date_mssql_db.png (26,360 bytes)   
date_mssql_db.png (26,360 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)120405
I will donate to the project if issue is resolvedNo
BrowserFirefox 9
Database type & versionMySQL 5
Server OS (if known)Win 7
Webserver software & version (if known)Apache 2.2
PHP Version5.3.1

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2012-04-16 14:22

administrator   ~18372

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=8168
Mazi

Mazi

2012-04-16 15:48

updater   ~18377

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.
After the fix the DB type of a newly set up survey is switched to date and within the MS SQL DB there is no "00:00:00" data. So I wonder where this comes from? A wrong mapping by the driver, adding the hours by default?!
c_schmitz

c_schmitz

2012-04-17 09:36

administrator   ~18401

Yeah, I am sorry, but you will have to live with that for now.
The fix is very hard to do and not worth it because in 2.0 it is always a datetime type anyway.
c_schmitz

c_schmitz

2012-04-18 22:58

administrator   ~18420

1.92+ release

Related Changesets

LimeSurvey: master ea8dad84

2012-04-16 05:22:24

c_schmitz

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

Issue History

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