Forum GLPI-Project

fathi.bennasr

Member

From: Tunis

Registered: 2014-04-02

Posts: 54

9.1 multiple alter in glpi_slalevels - Erreur durant l'éxecution de la

Bonjour,

J'ai profité de samedi pour mettre à jour mon glpi de la version 0.95 vers 9.1 et voilà le résultat :-)

Pouvez-vous m'aider ?
Merci.

GLPI SETUP

Mise à jour
Connexion à la base de données réussie

Changement de la structure de la base de données - glpi_slalevels (2 secondes)
Mise à jour en 9.1

Traitement en cours...

glpi_objectlocks table already exists. A backup have been done to backup_glpi_objectlocks.

glpi_networkportfiberchannels table already exists. A backup have been done to backup_glpi_networkportfiberchannels.

glpi_operatingsystemarchitectures table already exists. A backup have been done to backup_glpi_operatingsystemarchitectures.

glpi_tasktemplates table already exists. A backup have been done to backup_glpi_tasktemplates.

glpi_budgettypes table already exists. A backup have been done to backup_glpi_budgettypes.

glpi_apiclients table already exists. A backup have been done to backup_glpi_apiclients.

glpi_computerantiviruses table already exists. A backup have been done to backup_glpi_computerantiviruses.

glpi_slts table already exists. A backup have been done to backup_glpi_slts.

You can delete backup tables if you have no need of them.
PHP Notice: Undefined index: definition_time in /var/www/clients/client5/web31/web/install/update_0905_91.php at line 745
PHP Notice: Undefined index: end_of_working_day in /var/www/clients/client5/web31/web/install/update_0905_91.php at line 745
9.1 multiple alter in glpi_slalevels - Erreur durant l'éxecution de la requête : ALTER TABLE `glpi_slalevels` CHANGE `slas_id` `slts_id` INT(11) NOT NULL DEFAULT '0' , DROP INDEX `slas_id` , ADD INDEX `slts_id` (`slts_id`) - L'erreur est Incorrect key file for table 'glpi_slalevels'; try to repair it

mon sql-errors.log contient les lignes suivantes:

2016-09-24 09:10:34 [@dev.sncft.com.tn]
  *** MySQL query error:
  SQL: ALTER TABLE `glpi_slalevels` CHANGE `slas_id` `slts_id` INT(11) NOT NULL DEFAULT \'0\'  ,
DROP INDEX `slas_id` ,
ADD INDEX `slts_id` (`slts_id`)
  Error: Incorrect key file for table 'glpi_slalevels'; try to repair it
  Backtrace :
  inc/dbmysql.class.php:208
  inc/migration.class.php:579                        DBmysql->queryOrDie()
  inc/migration.class.php:592                        Migration->migrationOneTable()
  install/update_0905_91.php:857                     Migration->executeMigration()
  install/update.php:795                             update0905to91()
  install/update.php:954                             updateDbUpTo031()

mon migration_to_9.1.log contient les lignes suivantes:

root@dev:/var/www/glpi.intranet.tn/web/files/_log # tail -n 64 migration_to_9.1.log
0 seconde for "Ajout date_mod à glpi_tasktemplates" @ 2016-09-24 08:40:26 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:40:26 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_tasktemplates" @ 2016-09-24 08:40:26 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:40:26 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_networkportfiberchannels" @ 2016-09-24 08:40:27 [@dev.sncft.com.tn]
1 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:40:27 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_networkportfiberchannels" @ 2016-09-24 08:40:27 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:40:27 [@dev.sncft.com.tn]
0 seconde for "Migration de données - glpi_displaypreferences" @ 2016-09-24 08:41:56 [@dev.sncft.com.tn]
1 seconde for "Ajout de - Object Locks à la base de données" @ 2016-09-24 08:41:56 [@dev.sncft.com.tn]
0 seconde for "date_mod et date_creation" @ 2016-09-24 08:41:56 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_tasktemplates" @ 2016-09-24 08:41:56 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:41:56 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_tasktemplates" @ 2016-09-24 08:41:56 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:41:56 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_networkportfiberchannels" @ 2016-09-24 08:41:56 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:41:56 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_networkportfiberchannels" @ 2016-09-24 08:41:57 [@dev.sncft.com.tn]
1 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:41:57 [@dev.sncft.com.tn]
0 seconde for "Migration de données - glpi_displaypreferences" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
1 seconde for "Ajout de - Object Locks à la base de données" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "date_mod et date_creation" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_tasktemplates" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_tasktemplates" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_networkportfiberchannels" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_networkportfiberchannels" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:48:51 [@dev.sncft.com.tn]
0 seconde for "Migration de données - glpi_displaypreferences" @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
0 seconde for "Ajout de - Object Locks à la base de données" @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
0 seconde for "date_mod et date_creation" @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_tasktemplates" @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_tasktemplates" @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_networkportfiberchannels" @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_networkportfiberchannels" @ 2016-09-24 08:49:25 [@dev.sncft.com.tn]
1 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:49:25 [@dev.sncft.com.tn]
0 seconde for "Migration de données - glpi_displaypreferences" @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
0 seconde for "Ajout de - Object Locks à la base de données" @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
0 seconde for "date_mod et date_creation" @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_tasktemplates" @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_tasktemplates" @ 2016-09-24 08:50:32 [@dev.sncft.com.tn]
1 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 08:50:32 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_networkportfiberchannels" @ 2016-09-24 08:50:32 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:50:32 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_networkportfiberchannels" @ 2016-09-24 08:50:32 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 08:50:32 [@dev.sncft.com.tn]
0 seconde for "Migration de données - glpi_displaypreferences" @ 2016-09-24 09:10:33 [@dev.sncft.com.tn]
1 seconde for "Ajout de - Object Locks à la base de données" @ 2016-09-24 09:10:33 [@dev.sncft.com.tn]
0 seconde for "date_mod et date_creation" @ 2016-09-24 09:10:33 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_tasktemplates" @ 2016-09-24 09:10:33 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 09:10:33 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_tasktemplates" @ 2016-09-24 09:10:34 [@dev.sncft.com.tn]
1 seconde for "Changement de la structure de la base de données - glpi_tasktemplates" @ 2016-09-24 09:10:34 [@dev.sncft.com.tn]
0 seconde for "Ajout date_mod à glpi_networkportfiberchannels" @ 2016-09-24 09:10:34 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 09:10:34 [@dev.sncft.com.tn]
0 seconde for "Ajout date_creation à glpi_networkportfiberchannels" @ 2016-09-24 09:10:34 [@dev.sncft.com.tn]
0 seconde for "Changement de la structure de la base de données - glpi_networkportfiberchannels" @ 2016-09-24 09:10:34 [@dev.sncft.com.tn]

mon php-errors.log contient les lignes suivantes (la premièere ligne ayant disparu après que j'eusse ajouté /usr/sbin/getenforce à la liste des répertoires autorisés par open_basedir):

Test
2016-09-24 08:50:26 [@dev.sncft.com.tn]
  *** PHP Warning(2): file_exists(): open_basedir restriction in effect. File(/usr/sbin/getenforce) is not within the allowed path(s): (/var/www/clients/client5/web31/web:/var/www/clients/client5/web31/tmp:/var/www/glpi.intranet.tn/web:/srv/www/glpi.intranet.tn/web:/usr/share/php5:/tmp:/usr/share/phpmyadmin:/etc/phpmyadmin:/var/lib/phpmyadmin)
  Backtrace :
  :
  inc/toolbox.class.php:1109                         file_exists()
  inc/toolbox.class.php:1088                         Toolbox::checkSELinux()
  config/config.php:230                              Toolbox::commonCheckForUseGLPI()
  inc/includes.php:58                                include_once()
  index.php:56                                       include()
2016-09-24 08:50:32 [@dev.sncft.com.tn]
  *** PHP Notice(8): Undefined index: definition_time
  Backtrace :
  inc/toolbox.class.php:592
  install/update_0905_91.php:745                     Toolbox::userErrorHandlerDebug()
  install/update.php:795                             update0905to91()
  install/update.php:954                             updateDbUpTo031()
2016-09-24 08:50:32 [@dev.sncft.com.tn]
  *** PHP Notice(8): Undefined index: end_of_working_day
  Backtrace :
  inc/toolbox.class.php:592
  install/update_0905_91.php:745                     Toolbox::userErrorHandlerDebug()
  install/update.php:795                             update0905to91()
  install/update.php:954                             updateDbUpTo031()
2016-09-24 09:10:34 [@dev.sncft.com.tn]
  *** PHP Notice(8): Undefined index: definition_time
  Backtrace :
  inc/toolbox.class.php:592
  install/update_0905_91.php:745                     Toolbox::userErrorHandlerDebug()
  install/update.php:795                             update0905to91()
  install/update.php:954                             updateDbUpTo031()
2016-09-24 09:10:34 [@dev.sncft.com.tn]
  *** PHP Notice(8): Undefined index: end_of_working_day
  Backtrace :
  inc/toolbox.class.php:592
  install/update_0905_91.php:745                     Toolbox::userErrorHandlerDebug()
  install/update.php:795                             update0905to91()
  install/update.php:954                             updateDbUpTo031()

et mon warning_during_migration_to_9.1.log contient les lignes suivantes:

glpi_objectlocks table already exists. A backup have been done to backup_glpi_objectlocks. @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
glpi_networkportfiberchannels table already exists. A backup have been done to backup_glpi_networkportfiberchannels. @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
glpi_operatingsystemarchitectures table already exists. A backup have been done to backup_glpi_operatingsystemarchitectures. @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
glpi_tasktemplates table already exists. A backup have been done to backup_glpi_tasktemplates. @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
glpi_budgettypes table already exists. A backup have been done to backup_glpi_budgettypes. @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
glpi_apiclients table already exists. A backup have been done to backup_glpi_apiclients. @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
glpi_computerantiviruses table already exists. A backup have been done to backup_glpi_computerantiviruses. @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
glpi_slts table already exists. A backup have been done to backup_glpi_slts. @ 2016-09-24 08:49:24 [@dev.sncft.com.tn]
You can delete backup tables if you have no need of them. @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
glpi_objectlocks table already exists. A backup have been done to backup_glpi_objectlocks. @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
glpi_networkportfiberchannels table already exists. A backup have been done to backup_glpi_networkportfiberchannels. @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
glpi_operatingsystemarchitectures table already exists. A backup have been done to backup_glpi_operatingsystemarchitectures. @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
glpi_tasktemplates table already exists. A backup have been done to backup_glpi_tasktemplates. @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
glpi_budgettypes table already exists. A backup have been done to backup_glpi_budgettypes. @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
glpi_apiclients table already exists. A backup have been done to backup_glpi_apiclients. @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
glpi_computerantiviruses table already exists. A backup have been done to backup_glpi_computerantiviruses. @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
glpi_slts table already exists. A backup have been done to backup_glpi_slts. @ 2016-09-24 08:50:31 [@dev.sncft.com.tn]
You can delete backup tables if you have no need of them. @ 2016-09-24 09:10:32 [@dev.sncft.com.tn]
glpi_objectlocks table already exists. A backup have been done to backup_glpi_objectlocks. @ 2016-09-24 09:10:32 [@dev.sncft.com.tn]
glpi_networkportfiberchannels table already exists. A backup have been done to backup_glpi_networkportfiberchannels. @ 2016-09-24 09:10:32 [@dev.sncft.com.tn]
glpi_operatingsystemarchitectures table already exists. A backup have been done to backup_glpi_operatingsystemarchitectures. @ 2016-09-24 09:10:32 [@dev.sncft.com.tn]
glpi_tasktemplates table already exists. A backup have been done to backup_glpi_tasktemplates. @ 2016-09-24 09:10:32 [@dev.sncft.com.tn]
glpi_budgettypes table already exists. A backup have been done to backup_glpi_budgettypes. @ 2016-09-24 09:10:32 [@dev.sncft.com.tn]
glpi_apiclients table already exists. A backup have been done to backup_glpi_apiclients. @ 2016-09-24 09:10:32 [@dev.sncft.com.tn]
glpi_computerantiviruses table already exists. A backup have been done to backup_glpi_computerantiviruses. @ 2016-09-24 09:10:32 [@dev.sncft.com.tn]
glpi_slts table already exists. A backup have been done to backup_glpi_slts. @ 2016-09-24 09:10:32 [@dev.sncft.com.tn]
You can delete backup tables if you have no need of them. @

---

Rocky Linux 8 - php-7.4.27 + memcached - MariaDB-server-10.6.5 - GLPI 9.5.6 + Fusioninventory 9.5+3.0
ocsinventory-server-2.9.2

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: 9.1 multiple alter in glpi_slalevels - Erreur durant l'éxecution de la

Plusieures corrections ont été effectuées dans le cas où vous jouer plusieurs fois la migration (https://github.com/glpi-project/glpi/issues/1079)

Par contre je ne comprend pas l'erreur sur la table glpi_slas, car les champs indiqués manquants sont bien présents en 0.90.5

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)