CDbException

CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'surveyls_welcometext' at row 28. The SQL statement executed was: ALTER TABLE `lime_surveys_languagesettings` CHANGE `surveyls_welcometext` `surveyls_welcometext` text

/var/www/html/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

#1
+
 /var/www/html/limesurvey/application/helpers/update/updatedb_helper.php(3962): CDbCommand->alterColumn("{{surveys_languagesettings}}", "surveyls_welcometext", "text")
3957                 $sType .= ' NOT NULL';
3958             }
3959             if ($sDefault != 'NULL') {
3960                 $sType .= " DEFAULT '{$sDefault}'";
3961             }
3962             $oDB->createCommand()->alterColumn($sTable, $sColumn, $sType);
3963             break;
3964         case 'dblib':
3965         case 'sqlsrv':
3966         case 'mssql':
3967             dropDefaultValueMSSQL($sColumn, $sTable);
#2
+
 /var/www/html/limesurvey/application/helpers/update/updatedb_helper.php(2417): alterColumn("{{surveys_languagesettings}}", "surveyls_welcometext", "text", true)
2412         if ($iOldDBVersion < 359) {
2413             $oTransaction = $oDB->beginTransaction();
2414             alterColumn('{{notifications}}','message',"text",false);
2415             alterColumn('{{settings_user}}','stg_value',"text",true);
2416             alterColumn('{{surveys_languagesettings}}','surveyls_description',"text",true);
2417             alterColumn('{{surveys_languagesettings}}','surveyls_welcometext',"text",true);
2418             alterColumn('{{surveys_languagesettings}}','surveyls_endtext',"text",true);
2419             alterColumn('{{surveys_languagesettings}}','surveyls_policy_notice',"text",true);
2420             alterColumn('{{surveys_languagesettings}}','surveyls_policy_error',"text",true);
2421             alterColumn('{{surveys_languagesettings}}','surveyls_url',"text",true);
2422             alterColumn('{{surveys_languagesettings}}','surveyls_email_invite',"text",true);
#3
+
 /var/www/html/limesurvey/application/controllers/AdminController.php(126): db_upgrade_all(358, true)
121             $sDBVersion = getGlobalSetting('DBVersion');
122         }
123         if ((int) $sDBVersion < Yii::app()->getConfig('dbversionnumber') && $action != 'databaseupdate') {
124             // Try a silent update first
125             Yii::app()->loadHelper('update/updatedb');
126             if (!db_upgrade_all(intval($sDBVersion), true)) {
127                 $this->redirect(array('/admin/databaseupdate/sa/db'));
128             }
129         }
130 
131 
2019-10-31 11:41:07 Apache/2.4.38 (Debian) Yii Framework/1.1.21