Cannot find data type DATE

More
4 years 11 months ago #81152 by KimBracknell
KimBracknell created the topic: Cannot find data type DATE
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:

Please Log in to join the conversation.

More
4 years 11 months ago #81153 by c_schmitz
c_schmitz replied the topic: Cannot find data type DATE

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now