glpi-monitoring-0.90+1.1 and glpi 0.90.2 | error on item tab

[Jm0u]

2016-04-07 09:29:01 [28@] *** PHP Notice(8): Undefined index: rows Backtrace : plugins/monitoring/inc/service.class.php:651
plugins/monitoring/inc/service.class.php:614 PluginMonitoringService->listByHost() plugins/monitoring/inc/host.class.php:222 PluginMonitoringService->manageServices() inc/commonglpi.class.php:469 PluginMonitoringHost::displayTabContentForItem() ajax/common.tabs.php:91 CommonGLPI::displayStandardTab() 2016-04-07 09:29:01 [28@] *** PHP Warning(2): Invalid argument supplied for foreach() Backtrace : plugins/monitoring/inc/service.class.php:651
plugins/monitoring/inc/service.class.php:614 PluginMonitoringService->listByHost() plugins/monitoring/inc/host.class.php:222 PluginMonitoringService->manageServices() inc/commonglpi.class.php:469 PluginMonitoringHost::displayTabContentForItem() ajax/common.tabs.php:91 CommonGLPI::displayStandardTab() 2016-04-07 09:29:01 [28@] *** PHP Notice(8): Undefined index: rows Backtrace : plugins/monitoring/inc/service.class.php:706
plugins/monitoring/inc/service.class.php:614 PluginMonitoringService->listByHost() plugins/monitoring/inc/host.class.php:222 PluginMonitoringService->manageServices() inc/commonglpi.class.php:469 PluginMonitoringHost::displayTabContentForItem() ajax/common.tabs.php:91 CommonGLPI::displayStandardTab() 2016-04-07 09:29:01 [28@] *** PHP Warning(2): Invalid argument supplied for foreach() Backtrace : plugins/monitoring/inc/service.class.php:706
plugins/monitoring/inc/service.class.php:614 PluginMonitoringService->listByHost() plugins/monitoring/inc/host.class.php:222 PluginMonitoringService->manageServices() inc/commonglpi.class.php:469 PluginMonitoringHost::displayTabContentForItem() ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()

[Jm0u]

2016-04-07 09:29:01 [28@] *** MySQL query error: SQL: SELECT 'jmou' AS currentuser, CONCAT_WS('', glpi_computers.name, glpi_printers.name, glpi_networkequipments.name) AS ITEM_0, glpi_plugin_monitoring_components.name AS ITEM_1, glpi_plugin_monitoring_components.id AS ITEM_1_id,

                    `glpi_plugin_monitoring_services`.`state` AS `ITEM_2`,  `glpi_plugin_monitoring_services`.`state_type` AS `ITEM_3`,  `glpi_plugin_monitoring_services`.`last_check` AS `ITEM_4`,  `glpi_plugin_monitoring_services`.`event` AS `ITEM_5`,  `glpi_plugin_monitoring_services`.`is_acknowledged` AS `ITEM_6`,  `glpi_plugin_monitoring_hosts`.`is_acknowledged` AS `ITEM_7`,   `glpi_plugin_monitoring_componentscatalogs`.`name` AS `ITEM_8`,
                    `glpi_plugin_monitoring_componentscatalogs`.`id` AS `ITEM_8_id`,

                     `glpi_plugin_monitoring_services`.`name` AS `ITEM_9`,
                    `glpi_plugin_monitoring_services`.`id` AS `ITEM_9_id`,

                    `glpi_plugin_monitoring_componentscatalogs_hosts`.`id` AS `ITEM_10`,   `glpi_networkequipments`.`id` AS `ITEM_11`,
                    `glpi_networkequipments`.`id` AS `ITEM_11_id`,

                    `glpi_plugin_monitoring_services`.`id` AS id  FROM `glpi_plugin_monitoring_services`
           LEFT JOIN `glpi_plugin_monitoring_componentscatalogs_hosts`
              ON `plugin_monitoring_componentscatalogs_hosts_id` = `glpi_plugin_monitoring_componentscatalogs_hosts`.`id`
           LEFT JOIN `glpi_computers`
              ON `glpi_plugin_monitoring_componentscatalogs_hosts`.`items_id` = `glpi_computers`.`id`
                    AND `glpi_plugin_monitoring_componentscatalogs_hosts`.`itemtype`=\'Computer\'
           LEFT JOIN `glpi_printers`
              ON `glpi_plugin_monitoring_componentscatalogs_hosts`.`items_id` = `glpi_printers`.`id`
                 AND `glpi_plugin_monitoring_componentscatalogs_hosts`.`itemtype`=\'Printer\'
           LEFT JOIN `glpi_networkequipments`
              ON `glpi_plugin_monitoring_componentscatalogs_hosts`.`items_id` = `glpi_networkequipments`.`id`
                 AND `glpi_plugin_monitoring_componentscatalogs_hosts`.`itemtype`=\'NetworkEquipment\' LEFT JOIN `glpi_plugin_monitoring_components` 
                                      ON (`glpi_plugin_monitoring_services`.`plugin_monitoring_components_id` = `glpi_plugin_monitoring_components`.`id`
                                          )
           LEFT JOIN `glpi_plugin_monitoring_hosts`
              ON `glpi_plugin_monitoring_componentscatalogs_hosts`.`items_id` = `glpi_plugin_monitoring_hosts`.`items_id`
                    AND `glpi_plugin_monitoring_componentscatalogs_hosts`.`itemtype`=`glpi_plugin_monitoring_hosts`.`itemtype` 
           LEFT JOIN `glpi_plugin_monitoring_componentscatalogs`
              ON (`glpi_plugin_monitoring_componentscatalogs_hosts`.`plugin_monitoring_componentscalalog_id` = `glpi_plugin_monitoring_componentscatalogs`.`id`) LEFT JOIN `glpi_networkequipments` 
                                      ON (`glpi_plugin_monitoring_services`.`networkequipments_id` = `glpi_networkequipments`.`id`
                                          ) WHERE   (  1 )  AND (    (`glpi_networkequipments`.`id` = \'10\')  ) ORDER BY ITEM_0 ASC 

Error: Not unique table/alias: 'glpi_networkequipments' Backtrace : inc/search.class.php:903
plugins/monitoring/inc/service.class.php:646 Search::constructDatas() plugins/monitoring/inc/service.class.php:614 PluginMonitoringService->listByHost() plugins/monitoring/inc/host.class.php:222 PluginMonitoringService->manageServices() inc/commonglpi.class.php:469 PluginMonitoringHost::displayTabContentForItem() ajax/common.tabs.php:91 CommonGLPI::displayStandardTab()

[Jm0u]

une idée pour corriger la requête? :+1:

[ddurieux]

Je vais regarder