You are not logged in.
Pessoal, bom dia.
Após instalar o Plugin Connections estou enfrentando a seguinte dificuldade. Quando o Plugin Connections ativado, seleciono Ativos/Dispositivos de rede, e nenhum item é exibido na relação dos Dispositivos de rede. Porem, quando desativo o Plugin Connections e seleciono Ativos/Dispositivos de rede todos os meus itens cadastrados nesta categoria são exibidos. Alguém sabe o porque Dispositivos de rede não são exibidos quando este plugin é ativo.
GLPI
GLPI version 9.3.3
PLUGIN
Connections 0.90-1.7.3 GPLv2+ Instalado / não ativado Xavier Caillaud, Jean Marc GRISARD, TECLIB'
LOG (files/_log/sql-errors.log)
====================================================================
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_networkequipments`.`id` AS id, 'fernando.cunha' AS currentuser,
`glpi_networkequipments`.`entities_id`, `glpi_networkequipments`.`is_recursive`, `glpi_networkequipments`.`name` AS `ITEM_0`,
`glpi_networkequipments`.`id` AS `ITEM_0_id`,
`glpi_networkequipmenttypes`.`name` AS `ITEM_1`, `glpi_states`.`completename` AS `ITEM_2`, `glpi_manufacturers`.`name` AS `ITEM_3`, `glpi_networkequipmentmodels`.`name` AS `ITEM_4`, `glpi_networkequipments`.`serial` AS `ITEM_5`, `glpi_locations`.`completename` AS `ITEM_6`, `glpi_networkequipments`.`otherserial` AS `ITEM_7`, `glpi_networkequipments`.`date_mod` AS `ITEM_8`, GROUP_CONCAT(DISTINCT CONCAT(`glpi_plugin_connections_connections`.`name`, '$#$' ,
`glpi_plugin_connections_connections`.`id`)
SEPARATOR '$$##$$') AS `ITEM_9`,
GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_plugin_connections_connectiontypes`.`name`, '__NULL__'),
'$#$',`glpi_plugin_connections_connectiontypes`.`id`) SEPARATOR '$$##$$')
AS `ITEM_10`,
GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_infocoms`.`immo_number`, '__NULL__'),
'$#$',`glpi_infocoms`.`id`) SEPARATOR '$$##$$')
AS `ITEM_11`,
GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_suppliers_93d644b41c3544155af36e354b01ba13`.`name`, '__NULL__'),
'$#$',`glpi_suppliers_93d644b41c3544155af36e354b01ba13`.`id`) SEPARATOR '$$##$$')
AS `ITEM_12`,
GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_infocoms`.`delivery_number`, '__NULL__'),
'$#$',`glpi_infocoms`.`id`) SEPARATOR '$$##$$')
AS `ITEM_13`,
GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_infocoms`.`buy_date`, '__NULL__'),
'$#$',`glpi_infocoms`.`id`) SEPARATOR '$$##$$')
AS `ITEM_14`,
GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_infocoms`.`warranty_date`, '__NULL__'),
'$#$',`glpi_infocoms`.`id`) SEPARATOR '$$##$$')
AS `ITEM_15`,
GROUP_CONCAT(DISTINCT ADDDATE(`glpi_infocoms`.`warranty_date`,
INTERVAL (`glpi_infocoms`.`warranty_duration` ) MONTH)
SEPARATOR '$$##$$') AS `ITEM_16` FROM `glpi_networkequipments`LEFT JOIN `glpi_networkequipmenttypes`
ON (`glpi_networkequipments`.`networkequipmenttypes_id` = `glpi_networkequipmenttypes`.`id`
)LEFT JOIN `glpi_states`
ON (`glpi_networkequipments`.`states_id` = `glpi_states`.`id`
)LEFT JOIN `glpi_manufacturers`
ON (`glpi_networkequipments`.`manufacturers_id` = `glpi_manufacturers`.`id`
)LEFT JOIN `glpi_networkequipmentmodels`
ON (`glpi_networkequipments`.`networkequipmentmodels_id` = `glpi_networkequipmentmodels`.`id`
)LEFT JOIN `glpi_locations`
ON (`glpi_networkequipments`.`locations_id` = `glpi_locations`.`id`
) LEFT JOIN `glpi_plugin_connections_connections_items` ON (`glpi_networkequipments`.`id` = `glpi_plugin_connections_connections_items`.`items_id` AND `glpi_plugin_connections_connections_items`.`itemtype` = 'NetworkEquipment') LEFT JOIN `glpi_plugin_connections_connections` ON (`glpi_plugin_connections_connections`.`id` = `glpi_plugin_connections_connections_items`.`plugin_connections_connections_id`) LEFT JOIN `glpi_plugin_connections_connections_items` ON (`glpi_networkequipments`.`id` = `glpi_plugin_connections_connections_items`.`items_id` AND `glpi_plugin_connections_connections_items`.`itemtype` = 'NetworkEquipment') LEFT JOIN `glpi_plugin_connections_connections` ON (`glpi_plugin_connections_connections`.`id` = `glpi_plugin_connections_connections_items`.`plugin_connections_connections_id`) LEFT JOIN `glpi_plugin_connections_connectiontypes` ON (`glpi_plugin_connections_connectiontypes`.`id` = `glpi_plugin_connections_connections`.`plugin_connections_connectiontypes_id`) LEFT JOIN `glpi_infocoms`
ON (`glpi_networkequipments`.`id` = `glpi_infocoms`.`items_id`
AND `glpi_infocoms`.`itemtype` = 'NetworkEquipment'
) LEFT JOIN `glpi_suppliers` AS `glpi_suppliers_93d644b41c3544155af36e354b01ba13`
ON (`glpi_infocoms`.`suppliers_id` = `glpi_suppliers_93d644b41c3544155af36e354b01ba13`.`id`
) WHERE `glpi_networkequipments`.`is_deleted` = 0 AND `glpi_networkequipments`.`is_template` = 0 GROUP BY `glpi_networkequipments`.`id` ORDER BY ITEM_0 ASC LIMIT 0, 200
Error: Not unique table/alias: 'glpi_plugin_connections_connections_items'
Backtrace :
inc/search.class.php:1146
inc/search.class.php:98 Search::constructData()
inc/search.class.php:80 Search::showList()
front/networkequipment.php:39 Search::show()
{"user":"611@SERVER_GLPI"}
====================================================================
Offline