Topic: [Beta 0.84] Rapports / FusionInventory / Compteurs d'impression

Bonjour,

Ce rapport ne fonctionne plus :

Erreur MySQL : Unknown column 'glpi_networkports.ip' in 'field list'

Cdt.

Re: [Beta 0.84] Rapports / FusionInventory / Compteurs d'impression

Tu peux mettre un ticket sur la forge (en anglais) s'il te plait?

Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com

3 (edited by Romain.I 2013-02-21 14:56:38)

Re: [Beta 0.84] Rapports / FusionInventory / Compteurs d'impression

Fait.

http://forge.fusioninventory.org/issues/1965

Re: [Beta 0.84] Rapports / FusionInventory / Compteurs d'impression

Apparement ça ne fonctionne plus, j'ai cette erreur dans sql-errors.log quand je vis sur le rapport :

2013-02-26 11:58:51
*** MySQL query error: 
***
SQL: SELECT \'glpi\' AS currentuser,
                         `glpi_printers`.`name` AS ITEM_0,
                        `glpi_printers`.`id` AS ITEM_0_2,
                        `glpi_plugin_fusioninventory_printerlogs`.`id` AS ITEM_1,
              `glpi_states`.`name` AS ITEM_2,
              `glpi_printers`.`serial` AS ITEM_3,
               `glpi_networkports`.`ip`  AS ITEM_4,  (
                  (SELECT pages_total FROM glpi_plugin_fusioninventory_printerlogs 
                     WHERE printers_id = glpi_printers.id
                        AND date <= \'2013-02-26 23:59:59\' 
                     ORDER BY date DESC LIMIT 1)
                  -
                  (SELECT pages_total FROM glpi_plugin_fusioninventory_printerlogs 
                     WHERE printers_id = glpi_printers.id
                        AND date >= \'2012-08-22 00:00:00\'  ORDER BY date  LIMIT 1)
                  )  AS ITEM_5,  `glpi_locations`.`name` AS ITEM_6,
                        `glpi_locations`.`id` AS ITEM_6_2,
                         `glpi_printertypes`.`name` AS ITEM_7,
                        `glpi_printertypes`.`id` AS ITEM_7_2,
                        `glpi_plugin_fusioninventory_printers`.`id` AS id  FROM `glpi_plugin_fusioninventory_printers`LEFT JOIN `glpi_printers` 
                                          ON (`glpi_plugin_fusioninventory_printers`.`printers_id` = `glpi_printers`.`id`
                                              ) LEFT JOIN `glpi_plugin_fusioninventory_printerlogs` 
                  ON (`glpi_plugin_fusioninventory_printerlogs`.`printers_id` = `glpi_printers`.`id`)  LEFT JOIN `glpi_states` 
                  ON (`glpi_printers`.`states_id` = `glpi_states`.`id`)  LEFT JOIN `glpi_networkports` 
                  ON (`glpi_printers`.`id` = `glpi_networkports`.`items_id` AND `glpi_networkports`.`itemtype` = \'Printer\') LEFT JOIN `glpi_plugin_fusioninventory_printerlogs`  AS glpi_plugin_fusioninventory_printerlogs_id
                                          ON (`glpi_plugin_fusioninventory_printers`.`id` = `glpi_plugin_fusioninventory_printerlogs_id`.`id`
                                              ) LEFT JOIN `glpi_locations` 
                  ON (`glpi_printers`.`locations_id` = `glpi_locations`.`id`)  LEFT JOIN `glpi_printertypes` 
                  ON (`glpi_printers`.`printertypes_id` = `glpi_printertypes`.`id`)  GROUP BY `glpi_plugin_fusioninventory_printers`.`id` ORDER BY ITEM_0 ASC  LIMIT 0, 5000
Error: Unknown column 'glpi_networkports.ip' in 'field list'
Backtrace :
/var/www/glpi2/inc/search.class.php&nbsp;:790        DBmysql->query()
/var/www/glpi2/inc/search.class.php&nbsp;:63        Search::showList()
/var/www/glpi2/plugins/fusioninventory/front/printerlogreport.php&nbsp;:76        Search::show()
/var/www/glpi2/plugins/fusioninventory/front/printerlogreport.php

Re: [Beta 0.84] Rapports / FusionInventory / Compteurs d'impression

Pour historique des ports switch :

Not Found

The requested URL /glpi2/plugins/fusioninventory/report/switch_ports.history.php was not found on this server.

Pour le rapport "Nombres de jours depuis le dernier inventaire" :

2013-02-26 12:05:39
*** MySQL query error: 
***
SQL: SELECT * FROM (
SELECT `name`, `last_fusioninventory_update`, `serial`, `otherserial`,
   `networkequipmentmodels_id`, `glpi_networkequipments`.`id` as `network_id`, 0 as `printer_id`,
   `plugin_fusioninventory_snmpmodels_id`, `plugin_fusioninventory_configsecurities_id`, `ip` FROM `glpi_plugin_fusioninventory_networkequipments`
JOIN `glpi_networkequipments` on `networkequipments_id` = `glpi_networkequipments`.`id`
WHERE ((NOW() > ADDDATE(last_fusioninventory_update, INTERVAL 10 DAY) OR last_fusioninventory_update IS NULL)
   )
UNION
SELECT `glpi_printers`.`name`, `last_fusioninventory_update`, `serial`, `otherserial`,
   `printermodels_id`, 0 as `network_id`, `glpi_printers`.`id` as `printer_id`,
   `plugin_fusioninventory_snmpmodels_id`, `plugin_fusioninventory_configsecurities_id`, `ip`
   FROM `glpi_plugin_fusioninventory_printers`
JOIN `glpi_printers` on `printers_id` = `glpi_printers`.`id`
LEFT JOIN `glpi_networkports` on `glpi_networkports`.`items_id` = `glpi_printers`.`id`
WHERE (NOW() > ADDDATE(last_fusioninventory_update, INTERVAL 10 DAY) OR last_fusioninventory_update IS NULL)
AND `glpi_networkports`.`items_id`=\'Printer\' ) as `table`

ORDER BY last_fusioninventory_update DESC
Error: Unknown column 'ip' in 'field list'
Backtrace :
/var/www/glpi2/plugins/fusioninventory/report/not_queried_recently.php&nbsp;:141        DBmysql->query()
/var/www/glpi2/plugins/fusioninventory/report/not_queried_recently.php

Re: [Beta 0.84] Rapports / FusionInventory / Compteurs d'impression

cré des tickets s'il te plait wink

Co-leader, official developper
DCS official PARTNER: dcs.glpi@dcsit-group.com