View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
13646 | Bug reports | LimeSurvey Website | public | 2018-05-03 14:31 | 2018-06-28 10:57 |
Reporter | Tinumm | Assigned To | c_schmitz | ||
Priority | none | Severity | partial_block | ||
Status | closed | Resolution | fixed | ||
Product Version | 3.7.x | ||||
Fixed in Version | 3.12.x | ||||
Summary | 13646: Error after Database Query MSSQL | ||||
Description | After succesfull installation of LimeSurvey a random database input results in an internal Servererror. | ||||
Steps To Reproduce |
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) | ||||
Tags | error!, 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 --- | ||||
Bug heat | 4 | ||||
Complete LimeSurvey version number (& build) | limesurvey3.7.1+180424 (same with "limesurvey3.7.0+180418") | ||||
I will donate to the project if issue is resolved | No | ||||
Browser | Mozilla Firefox 59.0.2 / Internet Explorer 11.1480 | ||||
Database type & version | MSSSQL 14.0.3022.28 (2017) | ||||
Server OS (if known) | Windows Server 2016 x64 Standard | ||||
Webserver software & version (if known) | IIS 10 | ||||
PHP Version | PHP 7.2.5 x86 and attempted x64 | ||||
push |
|
IMHO this issue has been fixed in the latest version. |
|
hey there, Thanks alot, c_schmitz. |
|
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 |