You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2018-11-21 17:12:16

kali24
Member
Registered: 2009-09-21
Posts: 84

Upgrade 9.3.2

Bonjour à tous,

Nous sommes en train de mettre à jour notre plateforme GLPI 9.1.1 vers la toute derniere version 9.3.2.

Pour ce faire, nous avons effectué une fresh install sur un nouveau serveur.

Si la montée de version se basse bien jusqu'en 9.2.4 ( 9.1.1 vers 9.1.7 vers 9.2.1 vers 9.2.4 ), la migration vers la v 9.3 ne se finalise pas.

La procédure de migration se stoppe sur ce message.

Changement de la structure de la base de données - glpi_computermodels (0 seconde)
9.3 multiple alter in glpi_computermodels - Erreur durant l'éxecution de la requête : ALTER TABLE `glpi_computermodels` ADD `weight` int(11) NOT NULL DEFAULT '0' AFTER `product_number` , ADD `required_units` int(11) NOT NULL DEFAULT '1' AFTER `weight` , ADD `depth` float NOT NULL DEFAULT 1 AFTER `required_units` , ADD `power_connections` int(11) NOT NULL DEFAULT '0' AFTER `depth` , ADD `power_consumption` int(11) NOT NULL DEFAULT '0' AFTER `power_connections` , ADD `is_half_rack` tinyint(1) NOT NULL DEFAULT '0' AFTER `power_consumption` , ADD `picture_front` TEXT COLLATE utf8_unicode_ci DEFAULT NULL AFTER `is_half_rack` , ADD `picture_rear` TEXT COLLATE utf8_unicode_ci DEFAULT NULL AFTER `picture_front` - L'erreur est Unknown column 'product_number' in 'glpi_computermodels'


L'execution de "cliupdate.php" me renvoie ceci


Config::getCache() in /var/www/html/glpi-9.3/inc/config.class.php line 2928
Service with name "Zend\Cache\Storage\Adapter\Apcu" could not be created. Reason: ext/apcu is disabled - see 'apc.enabled' and 'apc.enable_cli' Database version seems correct (10.1.37) - Perfect!
Current GLPI version         : 9.2.4
New GLPI version             : 9.3.0
Current GLPI database version: 9.2.3
New GLPI database version    : 9.3
Default GLPI Language        : fr_FR

========================================== Update to 9.3 ===========================================
DBmysql::query() in /var/www/html/glpi-9.3/inc/dbmysql.class.php line 180
  *** MySQL query error:
  SQL: ALTER TABLE `glpi_computermodels` ADD `weight` int(11) NOT NULL DEFAULT '0'   AFTER `product_number` ,
ADD `required_units` int(11) NOT NULL DEFAULT '1'   AFTER `weight` ,
ADD `depth` float NOT NULL DEFAULT 1   AFTER `required_units` ,
ADD `power_connections` int(11) NOT NULL DEFAULT '0'   AFTER `depth` ,
ADD `power_consumption` int(11) NOT NULL DEFAULT '0'   AFTER `power_connections` ,
ADD `is_half_rack` tinyint(1) NOT NULL DEFAULT '0'   AFTER `power_consumption` ,
ADD `picture_front` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `is_half_rack` ,
ADD `picture_rear` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `picture_front`
  Error: Unknown column 'product_number' in 'glpi_computermodels'
  Backtrace :
  inc/dbmysql.class.php:209
  inc/migration.class.php:657                        DBmysql->queryOrDie()
  inc/migration.class.php:691                        Migration->migrationOneTable()
  install/update_92_93.php:853                       Migration->executeMigration()
  inc/update.class.php:422                           update92to93()
  scripts/cliupdate.php:156                          Update->doUpdates()
PHP Fatal error:  Uncaught RuntimeException: 9.3 multiple alter in glpi_computermodels - Error during the database query: ALTER TABLE `glpi_computermodels` ADD `weight` int(11) NOT NULL DEFAULT '0'   AFTER `product_number` ,
ADD `required_units` int(11) NOT NULL DEFAULT '1'   AFTER `weight` ,
ADD `depth` float NOT NULL DEFAULT 1   AFTER `required_units` ,
ADD `power_connections` int(11) NOT NULL DEFAULT '0'   AFTER `depth` ,
ADD `power_consumption` int(11) NOT NULL DEFAULT '0'   AFTER `power_connections` ,
ADD `is_half_rack` tinyint(1) NOT NULL DEFAULT '0'   AFTER `power_consumption` ,
ADD `picture_front` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `is_half_rack` ,
ADD `picture_rear` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `picture_front`  - Error is Unknown column 'product_number' in 'glpi_computermodels' in /var/www/html/glpi-9.3/inc/dbmysql.class.php:219
Stack trace:
#0 /var/www/html/glpi-9.3/inc/migration.class.php(657): DBmysql->queryOrDie('ALTER TABLE `gl...', '9.3 multiple al...')
#1 /var/www/html/glpi-9 in /var/www/html/glpi-9.3/inc/dbmysql.class.php on line 219

Fatal error: Uncaught RuntimeException: 9.3 multiple alter in glpi_computermodels - Error during the database query: ALTER TABLE `glpi_computermodels` ADD `weight` int(11) NOT NULL DEFAULT '0'   AFTER `product_number` ,
ADD `required_units` int(11) NOT NULL DEFAULT '1'   AFTER `weight` ,
ADD `depth` float NOT NULL DEFAULT 1   AFTER `required_units` ,
ADD `power_connections` int(11) NOT NULL DEFAULT '0'   AFTER `depth` ,
ADD `power_consumption` int(11) NOT NULL DEFAULT '0'   AFTER `power_connections` ,
ADD `is_half_rack` tinyint(1) NOT NULL DEFAULT '0'   AFTER `power_consumption` ,
ADD `picture_front` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `is_half_rack` ,
ADD `picture_rear` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `picture_front`  - Error is Unknown column 'product_number' in 'glpi_computermodels' in /var/www/html/glpi-9.3/inc/dbmysql.class.php:219
Stack trace:
#0 /var/www/html/glpi-9.3/inc/migration.class.php(657): DBmysql->queryOrDie('ALTER TABLE `gl...', '9.3 multiple al...')
#1 /var/www/html/glpi-9 in /var/www/html/glpi-9.3/inc/dbmysql.class.php on line 219


Est ce un bug ? Je n'arrive malheureusement pas à trouver d'infos quant à une possible résolution.

Merci beaucoup pour vos réponses ! et encore bravo pour pour vos efforts sur GLPI,on en s'en passe plus.


Debian Squeeze / Glpi 9.1.1 / Fusioninventory 9.1+1.1 / Agent fusion 2.3.18
PHP 5.4.45-0+deb7u6
Zend Engine v2.4.0

Offline

#2 2018-11-21 17:20:47

kali24
Member
Registered: 2009-09-21
Posts: 84

Re: Upgrade 9.3.2

kali24 wrote:

Bonjour à tous,

Nous sommes en train de mettre à jour notre plateforme GLPI 9.1.1 vers la toute dernière version 9.3.2.

Pour ce faire, nous avons effectué une fresh install sur un nouveau serveur.

Si la montée de version se passe bien jusqu'en 9.2.4 ( 9.1.1 vers 9.1.7 vers 9.2.1 vers 9.2.4 ), la migration vers la v 9.3 ne se finalise pas.

La procédure de migration se stoppe sur ce message.

Changement de la structure de la base de données - glpi_computermodels (0 seconde)
9.3 multiple alter in glpi_computermodels - Erreur durant l'éxecution de la requête : ALTER TABLE `glpi_computermodels` ADD `weight` int(11) NOT NULL DEFAULT '0' AFTER `product_number` , ADD `required_units` int(11) NOT NULL DEFAULT '1' AFTER `weight` , ADD `depth` float NOT NULL DEFAULT 1 AFTER `required_units` , ADD `power_connections` int(11) NOT NULL DEFAULT '0' AFTER `depth` , ADD `power_consumption` int(11) NOT NULL DEFAULT '0' AFTER `power_connections` , ADD `is_half_rack` tinyint(1) NOT NULL DEFAULT '0' AFTER `power_consumption` , ADD `picture_front` TEXT COLLATE utf8_unicode_ci DEFAULT NULL AFTER `is_half_rack` , ADD `picture_rear` TEXT COLLATE utf8_unicode_ci DEFAULT NULL AFTER `picture_front` - L'erreur est Unknown column 'product_number' in 'glpi_computermodels'


L’exécution de "cliupdate.php" me renvoie ceci


Config::getCache() in /var/www/html/glpi-9.3/inc/config.class.php line 2928
Service with name "Zend\Cache\Storage\Adapter\Apcu" could not be created. Reason: ext/apcu is disabled - see 'apc.enabled' and 'apc.enable_cli' Database version seems correct (10.1.37) - Perfect!
Current GLPI version         : 9.2.4
New GLPI version             : 9.3.0
Current GLPI database version: 9.2.3
New GLPI database version    : 9.3
Default GLPI Language        : fr_FR

========================================== Update to 9.3 ===========================================
DBmysql::query() in /var/www/html/glpi-9.3/inc/dbmysql.class.php line 180
  *** MySQL query error:
  SQL: ALTER TABLE `glpi_computermodels` ADD `weight` int(11) NOT NULL DEFAULT '0'   AFTER `product_number` ,
ADD `required_units` int(11) NOT NULL DEFAULT '1'   AFTER `weight` ,
ADD `depth` float NOT NULL DEFAULT 1   AFTER `required_units` ,
ADD `power_connections` int(11) NOT NULL DEFAULT '0'   AFTER `depth` ,
ADD `power_consumption` int(11) NOT NULL DEFAULT '0'   AFTER `power_connections` ,
ADD `is_half_rack` tinyint(1) NOT NULL DEFAULT '0'   AFTER `power_consumption` ,
ADD `picture_front` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `is_half_rack` ,
ADD `picture_rear` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `picture_front`
  Error: Unknown column 'product_number' in 'glpi_computermodels'
  Backtrace :
  inc/dbmysql.class.php:209
  inc/migration.class.php:657                        DBmysql->queryOrDie()
  inc/migration.class.php:691                        Migration->migrationOneTable()
  install/update_92_93.php:853                       Migration->executeMigration()
  inc/update.class.php:422                           update92to93()
  scripts/cliupdate.php:156                          Update->doUpdates()
PHP Fatal error:  Uncaught RuntimeException: 9.3 multiple alter in glpi_computermodels - Error during the database query: ALTER TABLE `glpi_computermodels` ADD `weight` int(11) NOT NULL DEFAULT '0'   AFTER `product_number` ,
ADD `required_units` int(11) NOT NULL DEFAULT '1'   AFTER `weight` ,
ADD `depth` float NOT NULL DEFAULT 1   AFTER `required_units` ,
ADD `power_connections` int(11) NOT NULL DEFAULT '0'   AFTER `depth` ,
ADD `power_consumption` int(11) NOT NULL DEFAULT '0'   AFTER `power_connections` ,
ADD `is_half_rack` tinyint(1) NOT NULL DEFAULT '0'   AFTER `power_consumption` ,
ADD `picture_front` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `is_half_rack` ,
ADD `picture_rear` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `picture_front`  - Error is Unknown column 'product_number' in 'glpi_computermodels' in /var/www/html/glpi-9.3/inc/dbmysql.class.php:219
Stack trace:
#0 /var/www/html/glpi-9.3/inc/migration.class.php(657): DBmysql->queryOrDie('ALTER TABLE `gl...', '9.3 multiple al...')
#1 /var/www/html/glpi-9 in /var/www/html/glpi-9.3/inc/dbmysql.class.php on line 219

Fatal error: Uncaught RuntimeException: 9.3 multiple alter in glpi_computermodels - Error during the database query: ALTER TABLE `glpi_computermodels` ADD `weight` int(11) NOT NULL DEFAULT '0'   AFTER `product_number` ,
ADD `required_units` int(11) NOT NULL DEFAULT '1'   AFTER `weight` ,
ADD `depth` float NOT NULL DEFAULT 1   AFTER `required_units` ,
ADD `power_connections` int(11) NOT NULL DEFAULT '0'   AFTER `depth` ,
ADD `power_consumption` int(11) NOT NULL DEFAULT '0'   AFTER `power_connections` ,
ADD `is_half_rack` tinyint(1) NOT NULL DEFAULT '0'   AFTER `power_consumption` ,
ADD `picture_front` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `is_half_rack` ,
ADD `picture_rear` TEXT COLLATE utf8_unicode_ci DEFAULT NULL   AFTER `picture_front`  - Error is Unknown column 'product_number' in 'glpi_computermodels' in /var/www/html/glpi-9.3/inc/dbmysql.class.php:219
Stack trace:
#0 /var/www/html/glpi-9.3/inc/migration.class.php(657): DBmysql->queryOrDie('ALTER TABLE `gl...', '9.3 multiple al...')
#1 /var/www/html/glpi-9 in /var/www/html/glpi-9.3/inc/dbmysql.class.php on line 219


Est ce un bug ? Je n'arrive malheureusement pas à trouver d'infos quant à une possible résolution.

Merci beaucoup pour vos réponses ! et encore bravo pour pour vos efforts sur GLPI,on ne s'en passe plus.


Debian Squeeze / Glpi 9.1.1 / Fusioninventory 9.1+1.1 / Agent fusion 2.3.18
PHP 5.4.45-0+deb7u6
Zend Engine v2.4.0

Offline

#3 2018-11-26 13:16:42

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,278

Re: Upgrade 9.3.2

Le champ product_number a été ajouté en version 9.2.

dans la table glpi_configs, changer la valeur de la version en 9.1.7.1 et relancer la migration afin qu'il refasse la migration de la 9.2


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)

Offline

Board footer

Powered by FluxBB