Forum GLPI-Project

jlb59

Member

From: Valenciennes

Registered: 2008-07-29

Posts: 116

installation plugin rack (Gestion de baies) et erreur mysql

Bonjour.

Nous sommes en train de faire des tests de migration de glpi 0.83.5 en 9.1.7
Au niveau du plugin Gestion de baies v1.7.0, nous rencontrons ( visible dans le log sql-error.log sous _log de files dans le  répertoire glpi ) des erreur. 

Quelqu'un aurait il  rencontré le probléme ?  et est ce un probléme  ?  le  plugin rack semble  fonctionner normalement  !

Merci

cordialement

Voici un extrait du log :

  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE `glpi_plugin_rack_content` RENAME `glpi_plugin_racks_racks_items`;
A' at line 2

  Backtrace :
  inc/dbmysql.class.php:517                         
  plugins/racks/hook.php:50                          DBmysql->runFile()
  inc/plugin.class.php:664                           plugin_racks_install()
  :                                                  Plugin->install()
  front/plugin.form.php:49                           call_user_func()
2017-05-19 09:47:17 [10@vlpsogci01-sqlprj]
  *** MySQL query error:
  SQL: ALTER TABLE `glpi_plugin_rack` RENAME `glpi_plugin_racks_racks`;
ALTER TABLE `glpi_plugin_rack_content` RENAME `glpi_plugin_racks_racks_items`;
ALTER TABLE `glpi_plugin_rack_device_spec` RENAME `glpi_plugin_racks_itemspecifications`;
ALTER TABLE `glpi_plugin_rack_config` RENAME `glpi_plugin_racks_configs`;
ALTER TABLE `glpi_dropdown_plugin_rack_room_locations` RENAME `glpi_plugin_racks_roomlocations`;
ALTER TABLE `glpi_dropdown_plugin_rack_ways` RENAME `glpi_plugin_racks_connections`;
ALTER TABLE `glpi_plugin_rack_others` RENAME `glpi_plugin_racks_others`;
ALTER TABLE `glpi_dropdown_plugin_rack_others_type` RENAME `glpi_plugin_racks_othermodels`;
ALTER TABLE `glpi_plugin_rack_profiles` RENAME `glpi_plugin_racks_profiles`;

ALTER TABLE `glpi_plugin_racks_racks`
   CHANGE `ID` `id` int(11) NOT NULL auto_increment,
   CHANGE `name` `name` varchar(255) collate utf8_unicode_ci default NULL,
   CHANGE `FK_entities` `entities_id` int(11) NOT NULL default \'0\',
   CHANGE `recursive` `is_recursive` tinyint(1) NOT NULL default \'0\',
   ADD `serial` varchar(255) collate utf8_unicode_ci default NULL,
   ADD `plugin_racks_rackmodels_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to glpi_plugin_racks_rackmodels (id)\',
   CHANGE `FK_location` `locations_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to glpi_locations (id)\',
   CHANGE `room_location` `plugin_racks_roomlocations_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to glpi_plugin_racks_roomlocations (id)\',
   CHANGE `rack_size` `rack_size` int(11) NOT NULL default \'0\',
   CHANGE `FK_glpi_enterprise` `manufacturers_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to glpi_manufacturers (id)\',
   CHANGE `tech_num` `users_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to glpi_users (id)\',
   CHANGE `FK_groups` `groups_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to glpi_groups (id)\',
   CHANGE `deleted` `is_deleted` tinyint(1) NOT NULL default \'0\',
   CHANGE `notes` `notepad` longtext collate utf8_unicode_ci,
   CHANGE `is_template` `is_template` tinyint(1) NOT NULL default \'0\',
   CHANGE `tplname` `template_name` varchar(255) collate utf8_unicode_ci default NULL,
   ADD `date_mod` datetime default NULL,
   ADD INDEX (`name`),
   ADD INDEX (`entities_id`),
   ADD INDEX (`plugin_racks_roomlocations_id`),
   ADD INDEX (`users_id`),
   ADD INDEX (`groups_id`),
   ADD INDEX (`manufacturers_id`),
   ADD INDEX (`locations_id`),
   ADD INDEX (`is_deleted`),
   ADD INDEX (`is_template`),
   ADD INDEX (`date_mod`);

ALTER TABLE `glpi_plugin_racks_racks_items`
   CHANGE `ID` `id` int(11) NOT NULL auto_increment,
   CHANGE `FK_rack` `plugin_racks_racks_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to glpi_plugin_racks_racks (id)\',
   CHANGE `FK_face` `faces_id` int(11) NOT NULL default \'0\',
   CHANGE `FK_spec` `plugin_racks_itemspecifications_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to glpi_plugin_racks_itemspecifications (id)\',
   CHANGE `FK_device` `items_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to various tables, according to itemtype (id)\',
   CHANGE `device_type` `itemtype` varchar(100) collate utf8_unicode_ci NOT NULL COMMENT \'see .class.php file\',
   ADD UNIQUE `unicity` (`plugin_racks_racks_id`,`itemtype`,`items_id`),
   ADD INDEX `FK_device` (`items_id`,`itemtype`),
   ADD INDEX `item` (`itemtype`,`items_id`),
   ADD INDEX (`plugin_racks_racks_id`),
   ADD INDEX (`faces_id`),
   ADD INDEX (`plugin_racks_itemspecifications_id`);

ALTER TABLE `glpi_plugin_racks_itemspecifications`
   CHANGE `ID` `id` int(11) NOT NULL auto_increment,
   CHANGE `FK_model` `model_id` int(11) NOT NULL default \'0\',
   CHANGE `device_type` `itemtype` varchar(100) collate utf8_unicode_ci NOT NULL COMMENT \'see .class.php file\';

ALTER TABLE `glpi_plugin_racks_profiles`
   CHANGE `ID` `id` int(11) NOT NULL auto_increment,
   ADD `profiles_id` int(11) NOT NULL default \'0\' COMMENT \'RELATION to glpi_profiles (id)\',
   CHANGE `rack` `racks` char(1) collate utf8_unicode_ci default NULL,
   ADD INDEX (`profiles_id`);

ALTER TABLE `glpi_plugin_racks_configs`
   CHANGE `ID` `id` int(11) NOT NULL auto_increment,
   CHANGE `unit` `unit` int(11) NOT NULL default \'0\';

ALTER TABLE `glpi_plugin_racks_roomlocations`
   CHANGE `ID` `id` int(11) NOT NULL auto_increment,
   CHANGE `FK_entities` `entities_id` int(11) NOT NULL default \'0\',
   CHANGE `name` `name` varchar(255) collate utf8_unicode_ci default NULL,
   CHANGE `parentID` `plugin_racks_roomlocations_id` int(11) NOT NULL default \'0\',
   CHANGE `comments` `comment` text collate utf8_unicode_ci,
   DROP INDEX `name`,
   DROP INDEX `parentID`,
   DROP INDEX `FK_entities`,
   ADD INDEX (`name`),
   ADD INDEX (`plugin_racks_roomlocations_id`),
   ADD INDEX (`entities_id`),
   ADD UNIQUE (`entities_id`,`plugin_racks_roomlocations_id`,`name`);

ALTER TABLE `glpi_plugin_racks_connections`
   CHANGE `ID` `id` int(11) NOT NULL auto_increment,
   CHANGE `name` `name` varchar(255) collate utf8_unicode_ci default NULL,
   CHANGE `comments` `comment` text collate utf8_unicode_ci;

ALTER TABLE `glpi_plugin_racks_others`
   CHANGE `ID` `id` int(11) NOT NULL auto_increment,
   CHANGE `FK_entities` `entities_id` int(11) NOT NULL default \'0\',
   CHANGE `name` `name` varchar(255) collate utf8_unicode_ci default NULL,
   CHANGE `model` `plugin_racks_othermodels_id` int(11) NOT NULL default \'0\',
   ADD INDEX (`entities_id`),
   ADD INDEX (`plugin_racks_othermodels_id`);

ALTER TABLE `glpi_plugin_racks_othermodels`
   CHANGE `ID` `id` int(11) NOT NULL auto_increment,
   CHANGE `name` `name` varchar(255) collate utf8_unicode_ci default NULL,
   CHANGE `comments` `comment` text collate utf8_unicode_ci;

---

REDHAT 8.6 sur ESX vmware, glpi 10.0.10, OCS 2.3.1
Plugin : Import OCSNG,  Injection de fichiers , Impression pdf , uninstal,  rapport, comportement, OAUTH.
35000 utilisateurs , 2.5 millions de tickets

amma35

Moderator

Registered: 2017-02-08

Posts: 58

Re: installation plugin rack (Gestion de baies) et erreur mysql

Bonjour,

Le bug a été corrigé dans cette issue (https://github.com/InfotelGLPI/racks/issues/40).

Il faudrait apporter la correction présent dans ce commit https://github.com/InfotelGLPI/racks/co … 81f3407a43 dans le fichier plugins/racks/hook.php

---

Infotel
Blog GLPI Infotel