CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column '721221X2043X31723' at row 1. The SQL statement executed was: UPDATE `lime_survey_721221` SET `lastpage`=:yp0, `721221X2043X31723`=:yp1 WHERE `lime_survey_721221`.`id`=2

/mnt/data/shnoulle/nginx/www/3LTS/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

#1
+
 /mnt/data/shnoulle/nginx/www/3LTS/application/helpers/expressions/em_manager_helper.php(5589): CActiveRecord->updateByPk("2", array("lastpage" => 1, "721221X2043X31723" => "AZDJKQHSUHSU"))
5584                         LimeExpressionManager::addFrontendFlashMessage('error', $message, $this->sid);
5585                         return;
5586                     }
5587                     //If the responses already have been submitted once they are marked as completed already, so they shouldn't be changed.
5588                     if ($oResponse->submitdate == null || Survey::model()->findByPk($this->sid)->alloweditaftercompletion == 'Y') {
5589                         Response::model($this->sid)->updateByPk($oResponse->id,$aResponseAttributes);
5590                         /* See https://www.php.net/manual/en/pdostatement.rowcount.php :
5591                          * this behaviour is not guaranteed for all databases and should not be relied on for portable applications.
5592                          */
5593                         // Action in case its saved with success : to be move in Response::aferSave ?
5594                         // Save Timings if needed
#2
+
 /mnt/data/shnoulle/nginx/www/3LTS/application/helpers/expressions/em_manager_helper.php(5067): LimeExpressionManager->_UpdateValuesInDatabase()
5062                     $LEM->updatedValues[$knownVar['sgqa']]=array(
5063                         'type'=>$knownVar['type'],
5064                         'value'=>$value,
5065                     );
5066                 }
5067                 $LEM->_UpdateValuesInDatabase();
5068             }
5069 
5070             return array(
5071             'hasNext'=>true,
5072             'hasPrevious'=>false,
#3
+
 /mnt/data/shnoulle/nginx/www/3LTS/application/helpers/SurveyRuntimeHelper.php(665): LimeExpressionManager::StartSurvey("721221", "survey", array("active" => true, "allowsave" => true, "anonymized" => false, "assessments" => false, ...), false, ...)
660             if ($this->iSurveyid != LimeExpressionManager::getLEMsurveyId()) {
661                 LimeExpressionManager::SetDirtyFlag();
662             }
663 
664             // Init $LEM states.
665             LimeExpressionManager::StartSurvey($this->iSurveyid, $this->sSurveyMode, $this->aSurveyOptions, false, $this->LEMdebugLevel);
666             $_SESSION[$this->LEMsessid]['step'] = 0;
667 
668             // Welcome page.
669             if ($this->sSurveyMode == 'survey') {
670                 LimeExpressionManager::JumpTo(1, false, false, true);
2020-07-10 06:27:05 nginx/1.18.0 Yii Framework/1.1.22-dev