View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
06153Bug reportsInstallationpublic2012-05-31 10:212012-06-20 14:08
ReporterKimBracknell Assigned Toc_schmitz  
PrioritynormalSeverityminor 
Status closedResolutionfixed 
Product Version1.92+ 
Fixed in Version1.92+ 
Summary06153: Cannot find data type DATE
Description

Hi there,

Last year I hosted LimeSurvey on my web site and it worked a treat. It used the same SQL Server 2005 as is installed now. I have recently upgraded to v. 1.92 (120501).

Unfortunately if I use DATE fields in any of my surveys, whether new or imported, then I get the following error when trying to activate any of them: "Cannot find data type DATE" (see error attached). The SQL Server 2005 backend database has a database COMPATIBILITY_LEVEL = 90.

The following web site:
stackoverflow.com/questions/1685026/prob...e-type-in-sql-server
suggests I need to change the COMPATIBILITY_LEVEL to 100.

Steps To Reproduce

Using version LimeSurvey 1.92 (120501), SQL Server 2005 backend.

  1. Create a new survey called TEST and save it.
  2. Add a new group, Group 1, and then 'Save question group'.
  3. Add a new question field, with Code='Q1' as Question type DATE.
  4. Save the survey and then 'Activate the survey'.
  5. Click on 'Activate Survey' at bottom of page.
  6. Error shown: 'Survey could not be activated - see below.
Additional Information

Survey could not be activated.
Database error: [Microsoft][ODBC SQL Server Driver][SQL Server]Column, parameter, or variable #6: Cannot find data type DATE.

id I NOTNULL AUTO PRIMARY,
submitdate T,
lastpage I,
startlanguage C(20) NOTNULL,
token C(36),
59634X68X385 D

TagsNo tags attached.
Attached Files
LS_Activate.jpg (82,450 bytes)   
LS_Activate.jpg (82,450 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)120501
I will donate to the project if issue is resolvedNo
BrowserChrome v.20 and/or IE 9
Database type & versionSQL Server 2005
Server OS (if known)Windows Server (unknown - hosted)
Webserver software & version (if known)IIS
PHP Version5.2.2

Users monitoring this issue

There are no users monitoring this issue.

Activities

KimBracknell

KimBracknell

2012-06-03 08:49

reporter   ~19046

I have since updated to 1.92(120530) and the issue remains.
Cheers,
Kim.
KimBracknell

KimBracknell

2012-06-04 03:37

reporter   ~19050

If this error is caused by the lack of a DATE type in SQL Server 2005 (only introduced in SQL Sever 2008 ??) perhaps this page can help:

http://weblogs.sqlteam.com/jeffs/archive/2007/10/31/sql-server-2005-date-time-only-data-types.aspx

This link discusses creating a DATE type in SQL Server 2005.

FYI,
KIm.
c_schmitz

c_schmitz

2012-06-12 14:46

administrator   ~19208

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

c_schmitz

2012-06-20 14:08

administrator   ~19405

New 1.92+ version released.

Related Changesets

LimeSurvey: master e7ba7f0c

2012-06-12 05:46:55

c_schmitz

Details Diff 		Fixed issue 06153: "Cannot find data type DATE" when activating a survey with MSSQL 2005 Affected Issues
06153
mod - admin/activate_functions.php Diff File

Issue History

Date Modified Username Field Change
2012-05-31 10:21 KimBracknell New Issue
2012-05-31 10:21 KimBracknell File Added: LS_Activate.jpg
2012-06-03 08:49 KimBracknell Note Added: 19046
2012-06-04 03:37 KimBracknell Note Added: 19050
2012-06-04 15:59 Mazi Assigned To => c_schmitz
2012-06-04 15:59 Mazi Status new => assigned
2012-06-12 14:46 c_schmitz Changeset attached => LimeSurvey master e7ba7f0c
2012-06-12 14:46 c_schmitz Note Added: 19208
2012-06-12 14:46 c_schmitz Resolution open => fixed
2012-06-12 14:47 c_schmitz Status assigned => resolved
2012-06-12 14:47 c_schmitz Fixed in Version => 1.92+
2012-06-20 14:08 c_schmitz Note Added: 19405
2012-06-20 14:08 c_schmitz Status resolved => closed