Hello Everyone

I'm trying to install Limesurvey on Windows Server 2008 R2 Standard with PHP v7.1.7 and Microsoft Drivers 4.3 (x64) for PHP v7.1 for SQL Server IIS installed. When I run the installation it give me the following error:


Internal Server Error
CDbCommand failed to execute the SQL statement: SQLSTATE[22007]: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. #0 C:\inetpub\wwwroot\survey\framework\db\CDbCommand.php(1278): CDbCommand->execute(Array)
#1 C:\inetpub\wwwroot\survey\installer\create-database.php(460): CDbCommand->insert('{{surveymenu}}', Array)
#2 C:\inetpub\wwwroot\survey\application\controllers\InstallerController.php(917): createDatabase(Object(DbConnection))
#3 C:\inetpub\wwwroot\survey\application\controllers\InstallerController.php(519): InstallerController->_setup_tables('C:\\inetpub\\wwwr...')
#4 C:\inetpub\wwwroot\survey\application\controllers\InstallerController.php(83): InstallerController->stepPopulateDb()
#5 C:\inetpub\wwwroot\survey\framework\web\CWebApplication.php(282): InstallerController->run('populatedb')
#6 C:\inetpub\wwwroot\survey\framework\web\CWebApplication.php(141): CWebApplication->runController('installer/popul...')
#7 C:\inetpub\wwwroot\survey\framework\base\CApplication.php(185): CWebApplication->processRequest()
#8 C:\inetpub\wwwroot\survey\index.php(194): CApplication->run()
#9 {main}

Any ideas on how to solve this problem?

What exact version of LimeSurvey should be installed?

Looks like a issue with date converting.
This can be a configuration issue. Can be a bug in LS, too.

You might check if the db user in SQL server and Windows are using the correct regional/language settings (-> dateformat). These kind of error can occure if SQL is expecting a different date format then other parts. But I don't use IIS and SQL-Server in combination with LS.

I would recommend to post the issue to the bugtracker.

I am getting the same error. It only occurs when trying to save any information to "My Account" , such as saving password, adding email, etc.

NathiM wrote: Any ideas on how to solve this problem?

What about Installing a linux server? :lol:

More seriously: we'll have a look to that probelm as soon as we have some time.
If you really need it quickly, in the bug tracker, you can offer to make a donation so the bug is fixed faster.