CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column '711522X461X6155' at row 1. The SQL statement executed was: UPDATE lime_survey_711522 SET `lastpage`=0, `711522X461X6155`='CESTFOUTUCOMPLETEMENT' WHERE ID=1

/mnt/data/shnoulle/nginx/www/master/framework/db/CDbCommand.php(543)

531         {
532             if($this->_connection->enableProfiling)
533                 Yii::endProfile('system.db.CDbCommand.query('.$this->getText().$par.')','system.db.CDbCommand.query');
534 
535             $errorInfo=$e instanceof PDOException ? $e->errorInfo : null;
536             $message=$e->getMessage();
537             Yii::log(Yii::t('yii','CDbCommand::{method}() failed: {error}. The SQL statement executed was: {sql}.',
538                 array('{method}'=>$method, '{error}'=>$message, '{sql}'=>$this->getText().$par)),CLogger::LEVEL_ERROR,'system.db.CDbCommand');
539 
540             if(YII_DEBUG)
541                 $message.='. The SQL statement executed was: '.$this->getText().$par;
542 
543             throw new CDbException(Yii::t('yii','CDbCommand failed to execute the SQL statement: {error}',
544                 array('{error}'=>$message)),(int)$e->getCode(),$errorInfo);
545         }
546     }
547 
548     /**
549      * Builds a SQL SELECT statement from the given query specification.
550      * @param array $query the query specification in name-value pairs. The following
551      * query options are supported: {@link select}, {@link distinct}, {@link from},
552      * {@link where}, {@link join}, {@link group}, {@link having}, {@link order},
553      * {@link limit}, {@link offset} and {@link union}.
554      * @throws CDbException if "from" key is not present in given query parameter
555      * @return string the SQL statement

Stack Trace

#1
+
 /mnt/data/shnoulle/nginx/www/master/application/helpers/expressions/em_manager_helper.php(5578): CDbCommand->query()
5573 
5574                     //If the responses already have been submitted once they are marked as completed already, so they shouldn't be changed.
5575                     $oSurveyResponse = SurveyDynamic::model($this->sid)->findByAttributes(['id' => $_SESSION[$this->sessid]['srid']]);
5576                     $result = true;
5577                     if ($oSurveyResponse->submitdate == null || Survey::model()->findByPk($this->sid)->alloweditaftercompletion == 'Y') {
5578                         $result = !Yii::app()->db->createCommand($query)->query();
5579                         //$result = !dbExecuteAssoc($query);
5580                     }
5581 
5582                     if ($result)
5583                     {
#2
+
 /mnt/data/shnoulle/nginx/www/master/application/helpers/expressions/em_manager_helper.php(5303): LimeExpressionManager->_UpdateValuesInDatabase()
5298                             continue;
5299                         }
5300                         else
5301                         {
5302                             // display new group
5303                             $message .= $LEM->_UpdateValuesInDatabase();
5304                             $LEM->runtimeTimings[] = array(__METHOD__,(microtime(true) - $now));
5305                             $LEM->lastMoveResult = array(
5306                                 'finished'=>false,
5307                                 'message'=>$message,
5308                                 'gseq'=>$LEM->currentGroupSeq,
#3
+
 /mnt/data/shnoulle/nginx/www/master/application/helpers/SurveyRuntimeHelper.php(835): LimeExpressionManager::NavigateForwards()
830                     $this->aMoveResult = false; // so display welcome page again
831                 }
832             }
833 
834             if ($this->sMove == "movenext") {
835                 $this->aMoveResult = LimeExpressionManager::NavigateForwards();
836             }
837 
838             if (($this->sMove == 'movesubmit')) {
839                 if ($this->sSurveyMode == 'survey') {
840                     $this->aMoveResult = LimeExpressionManager::NavigateForwards();
2019-03-29 18:35:46 nginx/1.14.2 Yii Framework/1.1.20