Forum GLPI-Project

antjac

Member

Registered: 2016-11-23

Posts: 1

[9.1.1] Erreur sur parc Global (colonne manquante)

Bonjour,

En essayant d'ajouter dans la liste globale le champs "Usager", j'ai une erreur SQL : "Champ 'glpi_softwarelicenses.contact' inconnu dans field list"

La requête exécutée est la suivante :

SELECT 'glpi' AS currentuser,
                         `glpi_computers`.`name` AS `ITEM_0`,
                        `glpi_computers`.`id` AS `ITEM_0_id`,
                        
                        `glpi_states`.`completename` AS `ITEM_1`,  `glpi_computers`.`contact` AS `ITEM_2`,  `glpi_computers`.`id` AS id , 'Computer' AS TYPE  FROM `glpi_computers`LEFT JOIN `glpi_states` 
                                          ON (`glpi_computers`.`states_id` = `glpi_states`.`id`
                                              ) WHERE    (  1 )   AND `glpi_computers`.`id` IS NOT NULL  AND `glpi_computers`.`is_deleted` = '0'  AND `glpi_computers`.`is_template` = '0'  UNION SELECT 'glpi' AS currentuser,
                         `glpi_monitors`.`name` AS `ITEM_0`,
                        `glpi_monitors`.`id` AS `ITEM_0_id`,
                        
                        `glpi_states`.`completename` AS `ITEM_1`,  `glpi_monitors`.`contact` AS `ITEM_2`,  `glpi_monitors`.`id` AS id , 'Monitor' AS TYPE  FROM `glpi_monitors`LEFT JOIN `glpi_states` 
                                          ON (`glpi_monitors`.`states_id` = `glpi_states`.`id`
                                              ) WHERE    (  1 )   AND `glpi_monitors`.`id` IS NOT NULL  AND `glpi_monitors`.`is_deleted` = '0'  AND `glpi_monitors`.`is_template` = '0'  UNION SELECT 'glpi' AS currentuser,
                         `glpi_networkequipments`.`name` AS `ITEM_0`,
                        `glpi_networkequipments`.`id` AS `ITEM_0_id`,
                        
                        `glpi_states`.`completename` AS `ITEM_1`,  `glpi_networkequipments`.`contact` AS `ITEM_2`,  `glpi_networkequipments`.`id` AS id , 'NetworkEquipment' AS TYPE  FROM `glpi_networkequipments`LEFT JOIN `glpi_states` 
                                          ON (`glpi_networkequipments`.`states_id` = `glpi_states`.`id`
                                              ) WHERE    (  1 )   AND `glpi_networkequipments`.`id` IS NOT NULL  AND `glpi_networkequipments`.`is_deleted` = '0'  AND `glpi_networkequipments`.`is_template` = '0'  UNION SELECT 'glpi' AS currentuser,
                         `glpi_peripherals`.`name` AS `ITEM_0`,
                        `glpi_peripherals`.`id` AS `ITEM_0_id`,
                        
                        `glpi_states`.`completename` AS `ITEM_1`,  `glpi_peripherals`.`contact` AS `ITEM_2`,  `glpi_peripherals`.`id` AS id , 'Peripheral' AS TYPE  FROM `glpi_peripherals`LEFT JOIN `glpi_states` 
                                          ON (`glpi_peripherals`.`states_id` = `glpi_states`.`id`
                                              ) WHERE    (  1 )   AND `glpi_peripherals`.`id` IS NOT NULL  AND `glpi_peripherals`.`is_deleted` = '0'  AND `glpi_peripherals`.`is_template` = '0'  UNION SELECT 'glpi' AS currentuser,
                         `glpi_phones`.`name` AS `ITEM_0`,
                        `glpi_phones`.`id` AS `ITEM_0_id`,
                        
                        `glpi_states`.`completename` AS `ITEM_1`,  `glpi_phones`.`contact` AS `ITEM_2`,  `glpi_phones`.`id` AS id , 'Phone' AS TYPE  FROM `glpi_phones`LEFT JOIN `glpi_states` 
                                          ON (`glpi_phones`.`states_id` = `glpi_states`.`id`
                                              ) WHERE    (  1 )   AND `glpi_phones`.`id` IS NOT NULL  AND `glpi_phones`.`is_deleted` = '0'  AND `glpi_phones`.`is_template` = '0'  UNION SELECT 'glpi' AS currentuser,
                         `glpi_printers`.`name` AS `ITEM_0`,
                        `glpi_printers`.`id` AS `ITEM_0_id`,
                        
                        `glpi_states`.`completename` AS `ITEM_1`,  `glpi_printers`.`contact` AS `ITEM_2`,  `glpi_printers`.`id` AS id , 'Printer' AS TYPE  FROM `glpi_printers`LEFT JOIN `glpi_states` 
                                          ON (`glpi_printers`.`states_id` = `glpi_states`.`id`
                                              ) WHERE    (  1 )   AND `glpi_printers`.`id` IS NOT NULL  AND `glpi_printers`.`is_deleted` = '0'  AND `glpi_printers`.`is_template` = '0'  UNION SELECT 'glpi' AS currentuser,
                         `glpi_softwarelicenses`.`name` AS `ITEM_0`,
                        `glpi_softwarelicenses`.`id` AS `ITEM_0_id`,
                        
                        `glpi_states`.`completename` AS `ITEM_1`,  `glpi_softwarelicenses`.`contact` AS `ITEM_2`,  `glpi_softwarelicenses`.`id` AS id , 'SoftwareLicense' AS TYPE  FROM `glpi_softwarelicenses`LEFT JOIN `glpi_states` 
                                          ON (`glpi_softwarelicenses`.`states_id` = `glpi_states`.`id`
                                              ) WHERE    (  1 )   AND `glpi_softwarelicenses`.`id` IS NOT NULL  AND `glpi_softwarelicenses`.`is_deleted` = '0'  AND `glpi_softwarelicenses`.`is_template` = '0'  ORDER BY ITEM_0 ASC  LIMIT 0, 20

Pour résoudre le problème, j'ai du ajouter la colonne "contact" dans glpi_softwarelicenses

Last edited by antjac (2016-11-23 11:36:22)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: [9.1.1] Erreur sur parc Global (colonne manquante)

Je confirme ce bug : https://github.com/glpi-project/glpi/issues/1329

---

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)