Probleme avec le plugin Applicatifs et GLPI 0805

adtoto94 · 2011-11-16 17:31:08

Bonjour,

Depuis que j'ai migré vers GLPI 0805 et installé le plugin applicatifs, dans le module téléphone, les données sont invisibles.

si je désactive ce plugin et là, je retrouve mes données.

Est ce qu'un a eu ce pb et a pu résoudre ce pb

voila ce que j'ai dans les logs:

*** MySQL query error :
***
SQL: SELECT \'glpi\' AS currentuser, `glpi_phones`.`name` AS ITEM_0,
`glpi_phones`.`id` AS ITEM_0_2, `glpi_entities`.`completename` AS ITEM_1,
`glpi_entities`.`id` AS ITEM_1_2, `glpi_states`.`name` AS ITEM_2, `glpi_manufacturers`.`name` AS ITEM_3, `glpi_locations`.`completename` AS ITEM_4, `glpi_phonetypes`.`name` AS ITEM_5, `glpi_phonemodels`.`name` AS ITEM_6, `glpi_phones`.`contact` AS ITEM_7, `glpi_phones`.`contact_num` AS ITEM_8, `glpi_phones`.`serial` AS ITEM_9, `glpi_phones`.`otherserial` AS ITEM_10, `glpi_phones`.`date_mod` AS ITEM_11, `glpi_users`.`name` AS ITEM_12,
`glpi_users`.`realname` AS ITEM_12_2,
`glpi_users`.`id` AS ITEM_12_3,
`glpi_users`.`firstname` AS ITEM_12_4, `glpi_groups`.`name` AS ITEM_13, `glpi_phones`.`comment` AS ITEM_14, `glpi_phones`.`notepad` AS ITEM_15, `glpi_phones`.`brand` AS ITEM_16, `glpi_users_users_id_tech`.`name` AS ITEM_17,
`glpi_users_users_id_tech`.`realname` AS ITEM_17_2,
`glpi_users_users_id_tech`.`id` AS ITEM_17_3,
`glpi_users_users_id_tech`.`firstname` AS ITEM_17_4, `glpi_phonepowersupplies`.`name` AS ITEM_18, COUNT(DISTINCT `glpi_tickets_items_id`.`id`) AS ITEM_19, GROUP_CONCAT(DISTINCT CONCAT(`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`name`, \'$$\' ,
`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id`) SEPARATOR \'$$$$\')
AS ITEM_20, GROUP_CONCAT(DISTINCT `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`num` SEPARATOR \'$$$$\') AS ITEM_21, GROUP_CONCAT(DISTINCT `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`duration` SEPARATOR \'$$$$\') AS ITEM_22, GROUP_CONCAT(DISTINCT `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`begin_date` SEPARATOR \'$$$$\') AS ITEM_23, GROUP_CONCAT(DISTINCT `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`accounting_number` SEPARATOR \'$$$$\') AS ITEM_24, GROUP_CONCAT(DISTINCT
CONCAT(`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`begin_date`,
\',\',
`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`duration`
) SEPARATOR \'$$$$\')
AS ITEM_25, GROUP_CONCAT(DISTINCT `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`notice` SEPARATOR \'$$$$\') AS ITEM_26, GROUP_CONCAT(DISTINCT `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`cost` SEPARATOR \'$$$$\') AS ITEM_27, GROUP_CONCAT(DISTINCT `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`billing` SEPARATOR \'$$$$\') AS ITEM_28, GROUP_CONCAT(DISTINCT `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`renewal` SEPARATOR \'$$$$\') AS ITEM_29, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`immo_number` SEPARATOR \'$$$$\') AS ITEM_30, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`order_number` SEPARATOR \'$$$$\') AS ITEM_31, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`delivery_number` SEPARATOR \'$$$$\') AS ITEM_32, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`bill` SEPARATOR \'$$$$\') AS ITEM_33, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`buy_date` SEPARATOR \'$$$$\') AS ITEM_34, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`use_date` SEPARATOR \'$$$$\') AS ITEM_35, GROUP_CONCAT(DISTINCT `glpi_budgets_93d644b41c3544155af36e354b01ba13`.`name` SEPARATOR \'$$$$\') AS ITEM_36, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`warranty_duration` SEPARATOR \'$$$$\') AS ITEM_37, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`warranty_info` SEPARATOR \'$$$$\') AS ITEM_38, GROUP_CONCAT(DISTINCT
CONCAT(`glpi_infocoms`.`warranty_date`,
\',\',
`glpi_infocoms`.`warranty_duration`
) SEPARATOR \'$$$$\')
AS ITEM_39, GROUP_CONCAT(DISTINCT `glpi_suppliers_93d644b41c3544155af36e354b01ba13`.`name` SEPARATOR \'$$$$\') AS ITEM_40, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`value` SEPARATOR \'$$$$\') AS ITEM_41, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`warranty_value` SEPARATOR \'$$$$\') AS ITEM_42, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`alert` SEPARATOR \'$$$$\') AS ITEM_43, GROUP_CONCAT(DISTINCT `glpi_infocoms`.`comment` SEPARATOR \'$$$$\') AS ITEM_44, GROUP_CONCAT(DISTINCT CONCAT(`glpi_plugin_order_orders`.`name`, \'$$\' ,
`glpi_plugin_order_orders`.`id`) SEPARATOR \'$$$$\')
AS ITEM_45, GROUP_CONCAT(DISTINCT CONCAT(`glpi_plugin_order_orders`.`num_order`, \'$$\' ,
`glpi_plugin_order_orders`.`id`) SEPARATOR \'$$$$\')
AS ITEM_46, GROUP_CONCAT(DISTINCT CONCAT(`glpi_plugin_appliances_appliances`.`name`, \'$$\' ,
`glpi_plugin_appliances_appliances`.`id`) SEPARATOR \'$$$$\')
AS ITEM_47, GROUP_CONCAT(DISTINCT `glpi_plugin_appliances_appliancetypes`.`name` SEPARATOR \'$$$$\') AS ITEM_48, GROUP_CONCAT(DISTINCT CONCAT(`glpi_plugin_webapplications_webapplications`.`name`, \'$$\' ,
`glpi_plugin_webapplications_webapplications`.`id`) SEPARATOR \'$$$$\')
AS ITEM_49, GROUP_CONCAT(DISTINCT `glpi_plugin_webapplications_webapplicationtypes`.`name` SEPARATOR \'$$$$\') AS ITEM_50, `glpi_phones`.`id` AS id FROM `glpi_phones`LEFT JOIN `glpi_entities`
ON (`glpi_phones`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_states`
ON (`glpi_phones`.`states_id` = `glpi_states`.`id`
)LEFT JOIN `glpi_manufacturers`
ON (`glpi_phones`.`manufacturers_id` = `glpi_manufacturers`.`id`
)LEFT JOIN `glpi_locations`
ON (`glpi_phones`.`locations_id` = `glpi_locations`.`id`
)LEFT JOIN `glpi_phonetypes`
ON (`glpi_phones`.`phonetypes_id` = `glpi_phonetypes`.`id`
)LEFT JOIN `glpi_phonemodels`
ON (`glpi_phones`.`phonemodels_id` = `glpi_phonemodels`.`id`
)LEFT JOIN `glpi_users`
ON (`glpi_phones`.`users_id` = `glpi_users`.`id`
)LEFT JOIN `glpi_groups`
ON (`glpi_phones`.`groups_id` = `glpi_groups`.`id`
)LEFT JOIN `glpi_users` AS glpi_users_users_id_tech
ON (`glpi_phones`.`users_id_tech` = `glpi_users_users_id_tech`.`id`
)LEFT JOIN `glpi_phonepowersupplies`
ON (`glpi_phones`.`phonepowersupplies_id` = `glpi_phonepowersupplies`.`id`
) LEFT JOIN `glpi_tickets` AS glpi_tickets_items_id
ON (`glpi_phones`.`id` = `glpi_tickets_items_id`.`items_id`
AND `glpi_tickets_items_id`.`itemtype` = \'Phone\'
) LEFT JOIN `glpi_contracts_items`
ON (`glpi_phones`.`id` = `glpi_contracts_items`.`items_id`
AND `glpi_contracts_items`.`itemtype` = \'Phone\'
) LEFT JOIN `glpi_contracts` AS glpi_contracts_75a921d1c48c76553dc0a9e69050f745
ON (`glpi_contracts_items`.`contracts_id` = `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id`
) LEFT JOIN `glpi_infocoms`
ON (`glpi_phones`.`id` = `glpi_infocoms`.`items_id`
AND `glpi_infocoms`.`itemtype` = \'Phone\'
) LEFT JOIN `glpi_budgets` AS glpi_budgets_93d644b41c3544155af36e354b01ba13
ON (`glpi_infocoms`.`budgets_id` = `glpi_budgets_93d644b41c3544155af36e354b01ba13`.`id`
)LEFT JOIN `glpi_suppliers` AS glpi_suppliers_93d644b41c3544155af36e354b01ba13
ON (`glpi_infocoms`.`suppliers_id` = `glpi_suppliers_93d644b41c3544155af36e354b01ba13`.`id`
) LEFT JOIN `glpi_plugin_order_orders_items` ON (`glpi_phones`.`id` = `glpi_plugin_order_orders_items`.`items_id` AND `glpi_plugin_order_orders_items`.`itemtype` = \'Phone\') LEFT JOIN `glpi_plugin_order_orders` ON (`glpi_plugin_order_orders`.`id` = `glpi_plugin_order_orders_items`.`plugin_order_orders_id`) LEFT JOIN `glpi_plugin_appliances_appliances_items`
ON (`glpi_phones`.`id` = `glpi_plugin_appliances_appliances_items`.`items_id`
AND `glpi_plugin_appliances_appliances_items`.`itemtype` = \'Phone\')
LEFT JOIN `glpi_plugin_appliances_appliances`
ON (`glpi_plugin_appliances_appliances`.`id`
= `glpi_plugin_appliances_appliances_items`.`plugin_appliances_appliances_id`) LEFT JOIN `glpi_plugin_appliances_appliances_items`
ON (`glpi_phones`.`id` = `glpi_plugin_appliances_appliances_items`.`items_id`
AND `glpi_plugin_appliances_appliances_items`.`itemtype` = \'Phone\')
LEFT JOIN `glpi_plugin_appliances_appliances`
ON (`glpi_plugin_appliances_appliances`.`id`
= `glpi_plugin_appliances_appliances_items`.`plugin_appliances_appliances_id`) LEFT JOIN `glpi_plugin_appliances_appliancetypes`
ON (`glpi_plugin_appliances_appliancetypes`.`id`
= `glpi_plugin_appliances_appliances`.`plugin_appliances_appliancetypes_id`) LEFT JOIN `glpi_plugin_webapplications_webapplications_items` ON (`glpi_phones`.`id` = `glpi_plugin_webapplications_webapplications_items`.`items_id` AND `glpi_plugin_webapplications_webapplications_items`.`itemtype`= \'Phone\') LEFT JOIN `glpi_plugin_webapplications_webapplications` ON (`glpi_plugin_webapplications_webapplications`.`id` = `glpi_plugin_webapplications_webapplications_items`.`plugin_webapplications_webapplications_id`) LEFT JOIN `glpi_plugin_webapplications_webapplicationtypes` ON (`glpi_plugin_webapplications_webapplicationtypes`.`id` = `glpi_plugin_webapplications_webapplications`.`plugin_webapplications_webapplicationtypes_id`) WHERE `glpi_phones`.`is_deleted` = \'0\' AND `glpi_phones`.`is_template` = \'0\' GROUP BY `glpi_phones`.`id` ORDER BY ITEM_0 ASC LIMIT 0, 100
Error: Not unique table/alias: 'glpi_plugin_appliances_appliances_items'
Backtrace :
C:\xampp\htdocs\glpi\inc\search.class.php :739 DBmysql->query()
C:\xampp\htdocs\glpi\inc\search.class.php :49 Search::showList()
C:\xampp\htdocs\glpi\front\phone.php :45 Search::show()
C:/xampp/htdocs/glpi/front/phone.php

Merci d'avance

A.D.

yllen · 2011-11-16 18:57:38

Version du plugin appliance utilisée ?

adtoto94 · 2011-11-17 11:19:44

Bonjour,

j'utilise le plugin apllicatifs 1.7.0

Bonne journée

remi · 2011-11-18 10:32:01

Reproduit...

Cela arrive quand on affiche 2 colonnes (nom + type).

Solution de contournement : revenir à la vue standard.

Pour suivi : https://forge.indepnet.net/issues/3259

remi · 2011-11-18 15:24:12

correction à tester. (lien sur les corrections dans le bug)

adtoto94 · 2012-01-03 10:17:09

Bonjour,

Avec le correctif, ça marche

Merci encore

Forum GLPI-Project

Announcement

#1 2011-11-16 17:31:08

Probleme avec le plugin Applicatifs et GLPI 0805

#2 2011-11-16 18:57:38

Re: Probleme avec le plugin Applicatifs et GLPI 0805

#3 2011-11-17 11:19:44

Re: Probleme avec le plugin Applicatifs et GLPI 0805

#4 2011-11-18 10:32:01

Re: Probleme avec le plugin Applicatifs et GLPI 0805

#5 2011-11-18 15:24:12

Re: Probleme avec le plugin Applicatifs et GLPI 0805

#6 2012-01-03 10:17:09

Re: Probleme avec le plugin Applicatifs et GLPI 0805

Board footer