deletion of the old directory, keeping the config.php file
after decompressing the new version of LimeSurvey, updating the proposed database (600 to 604) and crashing.

The database contains nothing (no old questionnaires, no user accounts, no label , no specific theme)

modification of the config file to activate the debug mode (2 and 1). The content is:

CDbException

CDbCommand n'a pas pu exécuter la commande SQL: SQLSTATE[25P02]: In failed sql transaction: 7 ERREUR: la transaction est annulée, les commandes sont ignorées jusqu'à la fin du bloc
de la transaction. The SQL statement executed was: UPDATE "lime_boxes" SET "desc"=:desc, "buttontext"=:buttontext WHERE title = 'Create survey' AND page = 'welcome'. Bound with :desc='Create a new survey from scratch. Or simply copy or import an existing survey.', :buttontext='Create survey'

/var/www/html/limesurvey/vendor/yiisoft/yii/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
+
/var/www/html/limesurvey/vendor/yiisoft/yii/framework/db/CDbCommand.php(1313): CDbCommand->execute()
#1
–
/var/www/html/limesurvey/application/helpers/update/updates/Update_601.php(37): CDbCommand->update()

32 '{{boxes}}',
33 [
34 'desc' => 'Create a new survey from scratch. Or simply copy or import an existing survey.',
35 'buttontext' => 'Create survey'
36 ],
37 "title = 'Create survey' AND page = 'welcome'"
38 );
39 }
40
41 public function updateSurveyList()
42 {

#2
–
/var/www/html/limesurvey/application/helpers/update/updates/Update_601.php(19): LimeSurvey\Helpers\Update\Update_601->updateCreateSurvey()

14 try {
15 $this->db->createCommand()->addColumn('{{boxes}}', 'buttontext', 'string(255)');
16 } catch (Exception $e) {
17 // Column already exists - ignore
18 }
19 $this->updateCreateSurvey();
20 $this->updateSurveyList();
21 $this->updateGlobalSettings();
22 $this->updateComfortUpdate();
23 $this->updateLimeStore();
24 $this->updateThemes();

#3
–
/var/www/html/limesurvey/application/helpers/update/DatabaseUpdateBase.php(47): LimeSurvey\Helpers\Update\Update_601->up()

42 */
43 public function safeUp()
44 {
45 $transaction = $this->db->beginTransaction();
46 try {
47 $this->up();
48 $this->updateVersion();
49 $transaction->commit();
50 } catch (Throwable $e) {
51 $transaction->rollback();
52 throw $e;

#4
+
/var/www/html/limesurvey/application/helpers/update/updatedb_helper.php(88): LimeSurvey\Helpers\Update\DatabaseUpdateBase->safeUp()
#5
+
/var/www/html/limesurvey/application/controllers/AdminController.php(166): db_upgrade_all()
#6
+
/var/www/html/limesurvey/vendor/yiisoft/yii/framework/web/CWebApplication.php(282): AdminController->run()
#7
+
/var/www/html/limesurvey/vendor/yiisoft/yii/framework/web/CWebApplication.php(141): CWebApplication->runController()
#8
+
/var/www/html/limesurvey/vendor/yiisoft/yii/framework/base/CApplication.php(185): CWebApplication->processRequest()
#9
+
/var/www/html/limesurvey/index.php(161): CApplication->run()