You are not logged in.
Pages: 1
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
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 219Fatal 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 219Est 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
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
Pages: 1