Forum GLPI-Project

FC

Member

Registered: 2012-04-18

Posts: 1

BUG glpi-webapplications-1.8.0.tar.gz

Version : GLPI version 0.83

Le bouton actualiser ne s'affichait pas sur la page d'ajout d'une WebApplication.
Relecture de la doc, vérification des droits dans le profil => Idem, pas de bouton actualiser

Passage en mode Debug => erreur dans le fichier /inc/dbmysql.class.php
Lecture de fichier de log du mysql :

La table "glpi_plugin_webapplications_webapplications" n'existe pas

Petite erreur dans le fichier SQL empty-1.8.0.sql

Execution de la requete suivante et ca marche :

CREATE TABLE `glpi_plugin_webapplications_webapplications` (
    `id` int(11) NOT NULL auto_increment,
    `entities_id` int(11) NOT NULL default '0',
    `is_recursive` tinyint(1) NOT NULL default '0',
    `name` varchar(255) collate utf8_unicode_ci default NULL,
    `address` varchar(255) collate utf8_unicode_ci default NULL,
    `backoffice` varchar(255) collate utf8_unicode_ci default NULL,
    `plugin_webapplications_webapplicationtypes_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_plugin_webapplications_webapplicationtypes (id)',
    `plugin_webapplications_webapplicationservertypes_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_plugin_webapplications_webapplicationservertypes (id)',
    `plugin_webapplications_webapplicationtechnics_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_plugin_webapplications_webapplicationtechnics (id)',
    `version` VARCHAR(255) collate utf8_unicode_ci default NULL,
    `users_id_tech` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_users (id)',
    `groups_id_tech` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_groups (id)',
    `suppliers_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_suppliers (id)',
    `manufacturers_id` int(11) NOT NULL default '0' COMMENT 'RELATION to glpi_manufacturers (id)',
    `locations_id` int(11) NOT NULL DEFAULT '0' COMMENT 'RELATION to glpi_locations (id)',
    `date_mod` datetime default NULL,
    `is_helpdesk_visible` int(11) NOT NULL default '1',
    `notepad` longtext collate utf8_unicode_ci,
    `comment` text collate utf8_unicode_ci,
    `is_deleted` tinyint(1) NOT NULL default '0',
    PRIMARY KEY  (`id`),
    KEY `name` (`name`),
  KEY `entities_id` (`entities_id`),
  KEY `plugin_webapplications_webapplicationtypes_id` (`plugin_webapplications_webapplicationtypes_id`),
  KEY `plugin_webapplications_webapplicationservertypes_id` (`plugin_webapplications_webapplicationservertypes_id`),
  KEY `plugin_webapplications_webapplicationtechnics_id` (`plugin_webapplications_webapplicationtechnics_id`),
----- Suppression
  KEY `users_id` (`users_id`),
  KEY `groups_id` (`groups_id`),
------ Supression
+++++ Ajout
  KEY `users_id_tech` (`users_id_tech`),
  KEY `groups_id_tech` (`groups_id_tech`),
+++++ Ajout
  KEY `suppliers_id` (`suppliers_id`),
  KEY `manufacturers_id` (`manufacturers_id`),
  KEY `locations_id` (`locations_id`),
  KEY date_mod (date_mod),
  KEY is_helpdesk_visible (is_helpdesk_visible),
  KEY `is_deleted` (`is_deleted`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Cela fonctionne maintenant (Pour Moi)

tsmr

GLPI-DEV

From: Rennes

Registered: 2005-08-26

Posts: 11,632

Website

Re: BUG glpi-webapplications-1.8.0.tar.gz

Corrigé. Merci

https://forge.indepnet.net/projects/web … isions/148

---

Xavier Caillaud
Blog GLPI Infotel