View Issue Details

Jump to NotesJump to History
This issue affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
13646Bug reportsLimeSurvey Websitepublic2018-05-03 14:312018-06-28 10:57
ReporterTinumm Assigned Toc_schmitz  
PrioritynoneSeveritypartial_block 
Status closedResolutionfixed 
Product Version3.7.x 
Fixed in Version3.12.x 
Summary13646: Error after Database Query MSSQL
Description

After succesfull installation of LimeSurvey a random database input results in an internal Servererror.

Steps To Reproduce

  1. Start LimeSurvey Webinterface

  2. try to change admin password
    2.1 succesfully enter "Current password:"
    2.2 succesfully enter "New password:"
    2.3 succesfully enter "Repeat new password:"

  3. when enter "Save" / "Save and close" no changes will be made and an wild error appears.
    translated:
    CDbCommand failed to execute the SQL statement: SQLSTATE [42000]: [Microsoft] [ODBC Driver 17 for SQL Server] [SQL Server] The implicit conversion of the char data type to
    binary is not allowed. Use the CONVERT function to execute this query.

  4. Same Error appears when trying to change the personal language setting

  5. Same Error appears when trying to change "email" or "full name"

Seems like it's not important what kind of data i want to change - the error stays

Additional Information

+Microsoft ODBC Driver 13 for SQL Server (13.1.4414.46)
+Microsoft ODBC Driver 17 for SQL Server (17.1.0.1)
+Microsoft Visual C++ 2008 Redistributable x64
+Microsoft Visual C++ 2008 Redistributable x86
+Microsoft Visual C++ 2013 Redistributable x64
+Microsoft Visual C++ 2017 Redistributable x64
+Microsoft Visual C++ 2017 Redistributable x86
+PHP extension "php_pdo_sqlsrv_72_nts_x86.dll" & "php_sqlsrv_72_nts_x86.dll"

Tagserror!, mssql
Attached Files
application.log (5,315 bytes)    
2018/05/03 13:35:36 [error] [system.db.CDbCommand] CDbCommand::execute() fehlgeschlagen: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Die implizite Konvertierung vom char-Datentyp in binary ist nicht zulässig. Verwenden Sie die CONVERT-Funktion, um diese Abfrage auszuführen.. Der SQL-Ausdruck war: UPDATE [dbo].[lime_users] SET [users_name]=:yp0, [password]=:yp1, [full_name]=:yp2, [parent_id]=:yp3, [email]=:yp4, [htmleditormode]=:yp5, [templateeditormode]=:yp6, [questionselectormode]=:yp7, [one_time_pw]=:yp8, [dateformat]=:yp9, [created]=:yp10, [modified]=GETDATE(), [lang]=:yp11 WHERE [dbo].[lime_users].[uid]=1.
2018/05/03 13:35:36 [error] [exception.CDbException] CDbException: CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Die implizite Konvertierung vom char-Datentyp in binary ist nicht zulässig. Verwenden Sie die CONVERT-Funktion, um diese Abfrage auszuführen. in D:\www\limesurvey\framework\db\CDbCommand.php:358
Stack trace:
#0 D:\www\limesurvey\framework\db\ar\CActiveRecord.php(1756): CDbCommand->execute()
#1 D:\www\limesurvey\framework\db\ar\CActiveRecord.php(1130): CActiveRecord->updateByPk('1', Array)
#2 D:\www\limesurvey\framework\db\ar\CActiveRecord.php(811): CActiveRecord->update(NULL)
#3 D:\www\limesurvey\application\controllers\admin\useraction.php(636): CActiveRecord->save()
#4 [internal function]: UserAction->personalsettings()
#5 D:\www\limesurvey\framework\web\actions\CAction.php(109): ReflectionMethod->invokeArgs(Object(UserAction), Array)
#6 D:\www\limesurvey\application\core\Survey_Common_Action.php(83): CAction->runWithParamsInternal(Object(UserAction), Object(ReflectionMethod), Array)
#7 D:\www\limesurvey\framework\web\CController.php(308): Survey_Common_Action->runWithParams(Array)
#8 D:\www\limesurvey\framework\web\CController.php(286): CController->runAction(Object(UserAction))
#9 D:\www\limesurvey\framework\web\CController.php(265): CController->runActionWithFilters(Object(UserAction), Array)
#10 D:\www\limesurvey\application\controllers\AdminController.php(158): CController->run('user')
#11 D:\www\limesurvey\framework\web\CWebApplication.php(282): AdminController->run('user')
#12 D:\www\limesurvey\framework\web\CWebApplication.php(141): CWebApplication->runController('admin/user/sa/p...')
#13 D:\www\limesurvey\framework\base\CApplication.php(185): CWebApplication->processRequest()
#14 D:\www\limesurvey\index.php(194): CApplication->run()
#15 {main}
REQUEST_URI=/index.php?r=admin/user/sa/personalsettings
HTTP_REFERER=http://umfrage.de/index.php?r=admin/user/sa/personalsettings
---
2018/05/03 13:42:49 [error] [system.db.CDbCommand] CDbCommand::execute() fehlgeschlagen: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Die implizite Konvertierung vom char-Datentyp in binary ist nicht zulässig. Verwenden Sie die CONVERT-Funktion, um diese Abfrage auszuführen.. Der SQL-Ausdruck war: UPDATE [dbo].[lime_users] SET [users_name]=:yp0, [password]=:yp1, [full_name]=:yp2, [parent_id]=:yp3, [email]=:yp4, [htmleditormode]=:yp5, [templateeditormode]=:yp6, [questionselectormode]=:yp7, [one_time_pw]=:yp8, [dateformat]=:yp9, [created]=:yp10, [modified]=GETDATE(), [lang]=:yp11 WHERE [dbo].[lime_users].[uid]=1.
2018/05/03 13:42:49 [error] [exception.CDbException] CDbException: CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Die implizite Konvertierung vom char-Datentyp in binary ist nicht zulässig. Verwenden Sie die CONVERT-Funktion, um diese Abfrage auszuführen. in D:\www\limesurvey\framework\db\CDbCommand.php:358
Stack trace:
#0 D:\www\limesurvey\framework\db\ar\CActiveRecord.php(1756): CDbCommand->execute()
#1 D:\www\limesurvey\framework\db\ar\CActiveRecord.php(1130): CActiveRecord->updateByPk('1', Array)
#2 D:\www\limesurvey\framework\db\ar\CActiveRecord.php(811): CActiveRecord->update(NULL)
#3 D:\www\limesurvey\application\controllers\admin\useraction.php(636): CActiveRecord->save()
#4 [internal function]: UserAction->personalsettings()
#5 D:\www\limesurvey\framework\web\actions\CAction.php(109): ReflectionMethod->invokeArgs(Object(UserAction), Array)
#6 D:\www\limesurvey\application\core\Survey_Common_Action.php(83): CAction->runWithParamsInternal(Object(UserAction), Object(ReflectionMethod), Array)
#7 D:\www\limesurvey\framework\web\CController.php(308): Survey_Common_Action->runWithParams(Array)
#8 D:\www\limesurvey\framework\web\CController.php(286): CController->runAction(Object(UserAction))
#9 D:\www\limesurvey\framework\web\CController.php(265): CController->runActionWithFilters(Object(UserAction), Array)
#10 D:\www\limesurvey\application\controllers\AdminController.php(158): CController->run('user')
#11 D:\www\limesurvey\framework\web\CWebApplication.php(282): AdminController->run('user')
#12 D:\www\limesurvey\framework\web\CWebApplication.php(141): CWebApplication->runController('admin/user/sa/p...')
#13 D:\www\limesurvey\framework\base\CApplication.php(185): CWebApplication->processRequest()
#14 D:\www\limesurvey\index.php(194): CApplication->run()
#15 {main}
REQUEST_URI=/index.php?r=admin/user/sa/personalsettings
HTTP_REFERER=http://umfrage.de/index.php?r=admin/user/sa/personalsettings
---
application.log (5,315 bytes)   
LimeSurvey_error_IE10.jpg (122,647 bytes)
Bug heat4
Complete LimeSurvey version number (& build)limesurvey3.7.1+180424 (same with "limesurvey3.7.0+180418")
I will donate to the project if issue is resolvedNo
BrowserMozilla Firefox 59.0.2 / Internet Explorer 11.1480
Database type & versionMSSSQL 14.0.3022.28 (2017)
Server OS (if known)Windows Server 2016 x64 Standard
Webserver software & version (if known)IIS 10
PHP VersionPHP 7.2.5 x86 and attempted x64

Users monitoring this issue

There are no users monitoring this issue.

Activities

Tinumm

Tinumm

2018-06-27 15:02

reporter   ~48324

push
c_schmitz

c_schmitz

2018-06-27 15:26

administrator   ~48325

IMHO this issue has been fixed in the latest version.
Please update and let us know if this issue exists in the latest version.
Tinumm

Tinumm

2018-06-28 10:34

reporter   ~48354

hey there,
i can confirm that the error is solved.
Installed version "limesurvey3.12.3+180627" and everything worked fine.

Thanks alot, c_schmitz.

Issue History

Date Modified Username Field Change
2018-05-03 14:31 Tinumm New Issue
2018-05-03 14:31 Tinumm Status new => assigned
2018-05-03 14:31 Tinumm Assigned To => c_schmitz
2018-05-03 14:31 Tinumm File Added: application.log
2018-05-03 14:31 Tinumm File Added: LimeSurvey_error_IE10.jpg
2018-05-03 14:33 Tinumm Tag Attached: mssql
2018-05-03 14:33 Tinumm Tag Attached: error!
2018-06-27 15:02 Tinumm Note Added: 48324
2018-06-27 15:26 c_schmitz Status assigned => feedback
2018-06-27 15:26 c_schmitz Note Added: 48325
2018-06-28 10:34 Tinumm Note Added: 48354
2018-06-28 10:34 Tinumm Status feedback => assigned
2018-06-28 10:57 c_schmitz Status assigned => closed
2018-06-28 10:57 c_schmitz Resolution open => fixed
2018-06-28 10:57 c_schmitz Fixed in Version => 3.12.x