CDbException

CDbCommand failed to execute the SQL statement: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'group_name' at row 1. The SQL statement executed was: INSERT INTO `limeliste_groups` (`sid`, `group_name`, `group_order`, `randomization_group`, `description`, `language`, `grelevance`) VALUES (:yp0, :yp1, :yp2, :yp3, :yp4, :yp5, :yp6)

/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_master/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

#2
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_master/application/models/QuestionGroup.php(172): CActiveRecord->save()
167     {
168         $group = new self;
169         foreach ($data as $k => $v) {
170             $group->$k = $v;
171         }
172         if (!$group->save()) {
173             return false;
174         } else {
175             return $group->gid;
176         }
177     }
#3
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_master/application/helpers/admin/import_helper.php(1011): QuestionGroup->insertRecords(array("sid" => "210", "group_name" => "N3.4.1 Les applications et outils bureautiques (repertoire, orga...", "group_order" => "2", "description" => "", ...))
1006             if (isset($aGIDReplacements[$oldgid])) {
1007                 switchMSSQLIdentityInsert('groups', true);
1008                 $insertdata['gid'] = $aGIDReplacements[$oldgid];
1009             }
1010 
1011             $newgid = QuestionGroup::model()->insertRecords($insertdata) or safeDie(gT("Error").": Failed to insert data [3]<br />");
1012             if (!isset($aGIDReplacements[$oldgid])) {
1013                 $aGIDReplacements[$oldgid] = $newgid; // add old and new qid to the mapping array
1014                 $results['groups']++;
1015             } else {
1016                 switchMSSQLIdentityInsert('groups', false);
#4
+
 /home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_master/application/helpers/admin/import_helper.php(705): XMLImportSurvey("/home/sondages.pro/htdocs/limesurvey_GIT/LimeSurvey_master/tmp/5...", null, null, null, ...)
700     } else {
701         $sExtension = "";
702     }
703     switch ($sExtension) {
704         case 'lss':
705             $aImportResults = XMLImportSurvey($sFullFilePath, null, $sNewSurveyName, $DestSurveyID, $bTranslateLinksFields);
706             if (!empty($aImportResults['newsid'])) {
707                 TemplateConfiguration::checkAndcreateSurveyConfig($aImportResults['newsid']);
708             }
709             return $aImportResults;
710         case 'txt':
2018-10-06 11:09:12 Apache/2.2.22 (Debian) Yii Framework/1.1.19