CDbException

CDbCommand konnte das SQL-Statement nicht ausführen: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Die implizite Konvertierung vom nvarchar(max)-Datentyp in varbinary(max) ist nicht zulässig. Verwenden Sie die CONVERT-Funktion, um diese Abfrage auszuführen.. The SQL statement executed was: INSERT INTO [lime_sessions] ([id], [expire], [data]) VALUES (:id, :expire, :data)

D:\htdocs\limesurvey\framework\db\CDbCommand.php(358)

346         {
347             if($this->_connection->enableProfiling)
348                 Yii::endProfile('system.db.CDbCommand.execute('.$this->getText().$par.')','system.db.CDbCommand.execute');
349 
350             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
351             $message=$e->getMessage();
352             Yii::log(Yii::t('yii','CDbCommand::execute() failed: {error}. The SQL statement executed was: {sql}.',
353                 array('{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
354 
355             if(YII_DEBUG)
356                 $message.='. The SQL statement executed was: '.$this->getText().$par;
357 
358             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
359                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
360         }
361     }
362 
363     /**
364      * Executes the SQL statement and returns query result.
365      * This method is for executing an SQL query that returns result set.
366      * @param array $params input parameters (name=>value) for the SQL execution. This is an alternative
367      * to {@link bindParam} and {@link bindValue}. If you have multiple input parameters, passing
368      * them in this way can improve the performance. Note that if you pass parameters in this way,
369      * you cannot bind parameters or values using {@link bindParam} or {@link bindValue}, and vice versa.
370      * Please also note that all values are treated as strings in this case, if you need them to be handled as

Stack Trace

#0
+
 D:\htdocs\limesurvey\framework\db\CDbCommand.php(1278): CDbCommand->execute(array(":id" => "i3catnijkeoiarnr9mk4iobeb1", ":expire" => 1525255495, ":data" => ""))
1273             }
1274         }
1275         $sql='INSERT INTO ' . $this->_connection->quoteTableName($table)
1276             . ' (' . implode(', ',$names) . ') VALUES ('
1277             . implode(', ', $placeholders) . ')';
1278         return $this->setText($sql)->execute($params);
1279     }
1280 
1281     /**
1282      * Creates and executes an UPDATE SQL statement.
1283      * The method will properly escape the column names and bind the values to be updated.
#1
+
 D:\htdocs\limesurvey\framework\web\CDbHttpSession.php(130): CDbCommand->insert("{{sessions}}", array("id" => "i3catnijkeoiarnr9mk4iobeb1", "expire" => 1525255495, "data" => ""))
125             // shouldn't reach here normally
126             $db->createCommand()->insert($this->sessionTableName, array(
127                 'id'=>$newID,
128                 'expire'=>time()+$this->getTimeout(),
129                 'data'=>'',
130             ));
131         }
132     }
133 
134     /**
135      * Creates the session DB table.
#2
+
 D:\htdocs\limesurvey\application\helpers\frontend_helper.php(1660): CDbHttpSession->regenerateID(true)
1655  * @param int $surveyid
1656  * @return void
1657  */
1658 function resetAllSessionVariables($surveyid)
1659 {
1660     Yii:app()->session->regenerateID(true);
1661     unset($_SESSION['survey_'.$surveyid]['grouplist']);
1662     unset($_SESSION['survey_'.$surveyid]['fieldarray']);
1663     unset($_SESSION['survey_'.$surveyid]['insertarray']);
1664     unset($_SESSION['survey_'.$surveyid]['fieldnamesInfo']);
1665     unset($_SESSION['survey_'.$surveyid]['fieldmap-' . $surveyid . '-randMaster']);
#3
+
 D:\htdocs\limesurvey\application\helpers\frontend_helper.php(1040): resetAllSessionVariables("157138")
1035     $renderWay = getRenderWay($renderToken, $renderCaptcha);
1036     $redata = compact(array_keys(get_defined_vars()));
1037     renderRenderWayForm($renderWay, $redata, $scenarios, $sTemplateViewPath, $aEnterTokenData, $surveyid);
1038 
1039     // Reset all the session variables and start again
1040     resetAllSessionVariables($surveyid);
1041 
1042     // Multi lingual support order : by REQUEST, if not by Token->language else by survey default language
1043     if (returnGlobal('lang',true))
1044     {
1045         $language_to_set=returnGlobal('lang',true);
#4
+
 D:\htdocs\limesurvey\application\helpers\SurveyRuntimeHelper.php(467): buildsurveysession("157138")
462         else
463         {
464             //RUN THIS IF THIS IS THE FIRST TIME , OR THE FIRST PAGE ########################################
465             if (!isset($_SESSION[$LEMsessid]['step']))
466             {
467                 buildsurveysession($surveyid);
468 
469 
470                 if($surveyid != LimeExpressionManager::getLEMsurveyId())
471                     LimeExpressionManager::SetDirtyFlag();
472 
#7
+
 D:\htdocs\limesurvey\framework\web\actions\CAction.php(76): index->run()
71     {
72         $method=new ReflectionMethod($this, 'run');
73         if($method->getNumberOfParameters()>0)
74             return $this->runWithParamsInternal($this, $method, $params);
75 
76         $this->run();
77         return true;
78     }
79 
80     /**
81      * Executes a method of an object with the supplied named parameters.
#8
+
 D:\htdocs\limesurvey\framework\web\CController.php(308): CAction->runWithParams(array("lang" => "de", "sid" => "157138"))
303     {
304         $priorAction=$this->_action;
305         $this->_action=$action;
306         if($this->beforeAction($action))
307         {
308             if($action->runWithParams($this->getActionParams())===false)
309                 $this->invalidActionParams($action);
310             else
311                 $this->afterAction($action);
312         }
313         $this->_action=$priorAction;
#9
+
 D:\htdocs\limesurvey\framework\web\CController.php(286): CController->runAction(index)
281      * @see runAction
282      */
283     public function runActionWithFilters($action,$filters)
284     {
285         if(empty($filters))
286             $this->runAction($action);
287         else
288         {
289             $priorAction=$this->_action;
290             $this->_action=$action;
291             CFilterChain::create($this,$action,$filters)->run();
#10
+
 D:\htdocs\limesurvey\framework\web\CController.php(265): CController->runActionWithFilters(index, array())
260         {
261             if(($parent=$this->getModule())===null)
262                 $parent=Yii::app();
263             if($parent->beforeControllerAction($this,$action))
264             {
265                 $this->runActionWithFilters($action,$this->filters());
266                 $parent->afterControllerAction($this,$action);
267             }
268         }
269         else
270             $this->missingAction($actionID);
#11
+
 D:\htdocs\limesurvey\framework\web\CWebApplication.php(282): CController->run("index")
277         {
278             list($controller,$actionID)=$ca;
279             $oldController=$this->_controller;
280             $this->_controller=$controller;
281             $controller->init();
282             $controller->run($actionID);
283             $this->_controller=$oldController;
284         }
285         else
286             throw new CHttpException(404,Yii::t('yii','Unable to resolve the request "{route}".',
287                 array('{route}'=>$route===''?$this->defaultController:$route)));
#12
+
 D:\htdocs\limesurvey\framework\web\CWebApplication.php(141): CWebApplication->runController("survey/index/sid/157138")
136             foreach(array_splice($this->catchAllRequest,1) as $name=>$value)
137                 $_GET[$name]=$value;
138         }
139         else
140             $route=$this->getUrlManager()->parseUrl($this->getRequest());
141         $this->runController($route);
142     }
143 
144     /**
145      * Registers the core application components.
146      * This method overrides the parent implementation by registering additional core components.
#13
+
 D:\htdocs\limesurvey\framework\base\CApplication.php(185): CWebApplication->processRequest()
180     public function run()
181     {
182         if($this->hasEventHandler('onBeginRequest'))
183             $this->onBeginRequest(new CEvent($this));
184         register_shutdown_function(array($this,'end'),0,false);
185         $this->processRequest();
186         if($this->hasEventHandler('onEndRequest'))
187             $this->onEndRequest(new CEvent($this));
188     }
189 
190     /**
#14
+
 D:\htdocs\limesurvey\index.php(214): CApplication->run()
209         die (sprintf('%s should be writable by the webserver (766 or 776).', $sDefaultRuntimePath));
210     }
211 }
212 
213 Yii::$enableIncludePath = false;
214 Yii::createApplication('LSYii_Application', $config)->run();
215 
216 /* End of file index.php */
217 /* Location: ./index.php */
2018-05-02 12:04:35 Apache/2.4.32 (Win32) OpenSSL/1.0.2n PHP/5.6.34 Yii Framework/1.1.18