Check out the LimeSurvey source code on GitHub!

Cannot find data type DATE

More
4 years 8 months ago #81152 by KimBracknell
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 8 months ago #81153 by c_schmitz

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form