Welcome, Guest
Username: Password: Remember me

TOPIC: Cannot find data type DATE

Cannot find data type DATE 2 years 3 months ago #81152

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.

As I am stuck with the database can you please assist with how else I might overcome this error?

Thanks,
Kim.
Attachments:
The administrator has disabled public write access.

Re: Cannot find data type DATE 2 years 3 months ago #81153

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 779
  • Thank you received: 111
  • Karma: 92
Please file a bug report on bugs.limesurvey.org
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.099 seconds
Donation Image