- Posts: 1
- Thank you received: 0
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
- Topic Author
- Offline
- New Member
Less
More
6 years 2 days ago #166142
by NathiM
[Microsoft][ODBC Driver 13 for SQL Server]: CDbCommand failed to execute the SQL was created 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?
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.
- jelo
- Offline
- Platinum Member
Less
More
- Posts: 5070
- Thank you received: 1263
6 years 2 days ago #166152
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic [Microsoft][ODBC Driver 13 for SQL Server]: CDbCommand failed to execute the SQL
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.
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.
- salter
- Offline
- Junior Member
Less
More
- Posts: 26
- Thank you received: 0
5 years 11 months ago #167067
by salter
Replied by salter on topic [Microsoft][ODBC Driver 13 for SQL Server]: CDbCommand failed to execute the SQL
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
- Visitor
5 years 11 months ago #167083
by LouisGac
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.
Replied by LouisGac on topic [Microsoft][ODBC Driver 13 for SQL Server]: CDbCommand failed to execute the SQL
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.