Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

[Microsoft][ODBC Driver 13 for SQL Server]: CDbCommand failed to execute the SQL

  • NathiM
  • NathiM's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
6 years 2 days ago #166142 by NathiM
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?
Attachments:
The topic has been locked.
More
6 years 2 days ago #166152 by jelo
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.

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
The following user(s) said Thank You: DenisChenu, LouisGac
The topic has been locked.
More
5 years 11 months ago #167067 by salter
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.
The topic has been locked.
  • LouisGac
  • LouisGac's Avatar
  • Visitor
  • Visitor
5 years 11 months ago #167083 by LouisGac

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.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose