Forum GLPI-Project

ddurieux

Plugins Dev

From: Propières, France

Registered: 2005-06-17

Posts: 7,521

Bug Plugin (HOOK)

Alors sur Tracker , j'ai un bug on dirait :

j'ai dans mon hook.php :

    $sopt[PLUGIN_TRACKER_MAC_UNKNOWN][4]['table'] = 'glpi_networking_ports';
    $sopt[PLUGIN_TRACKER_MAC_UNKNOWN][4]['field'] = 'ifmac';
    $sopt[PLUGIN_TRACKER_MAC_UNKNOWN][4]['linkfield'] = 'ID';
    $sopt[PLUGIN_TRACKER_MAC_UNKNOWN][4]['name'] = $LANG["networking"][15];

Du coup, je me retrouve avec la requete suivante quand je liste mes matériels inconnus :

SELECT glpi_plugin_tracker_unknown_device.name AS ITEM_0, GROUP_CONCAT( DISTINCT glpi_networking_ports.ifmac SEPARATOR '$$$$') AS ITEM_2, glpi_plugin_tracker_unknown_device.ID AS ID
FROM glpi_plugin_tracker_unknown_device
LEFT JOIN glpi_networking_ports ON (glpi_plugin_tracker_unknown_device.ID = glpi_networking_ports.on_device AND glpi_networking_ports.device_type='5153')
ORDER BY ITEM_0 ASC LIMIT 0, 10

et ça me sort un truc superbizarre :
Si je fais la requete MySQL directement dans la base j'ai comme résultat une seule ligne avec :

ITEM_0     :
ITEM_2     : 2009-06-25 15:58:11
ITEM_3     : 00:80:64:70:dc:89$$$$00:00:74:b3:ec:bd$$$$00:1e:4f:d5:44:29$$$$00:00:74:b4:04:c8$$$$00:00:74:b4:01:aa$$$$00:00:74:ab:43:9e$$$$00:1c:23:33:92:90$$$$00:80:64:70:dc:1f$$$$00:20:4a:8a:a7:a6$$$$00:00:74:b3:ed:99$$$$00:16:35:6d:b2:fd$$$$00:11:32:01:8d:4a$$$$00:80:64:70:4b:5b$$$$00:00:74:b4:01:b6$$$$00:80:64:5e:17:57$$$$00:30:6e:c9:88:61$$$$00:00:74:b4:04:73$$$$00:19:b9:6e:4d:28$$$$00:40:68:5b:d2:f4$$$$00:80:64:5e:86:7a$$$$00:40:68:5b:bf:b3$$$$00:1c:23:1f:f0:97$$$$00:00:74:cc:14:f3$$$$00:00:74:cc:2a:40$$$$00:02:a5:30:53:91$$$$00:20:4a:b1:3f:49$$$$00:50:da:5c:0b:69$$$$00:1d:b3:17:87:4e$$$$00:80:64:5e:86:8a$$$$00:80:64:5e:86:2b$$$$00:00:74:ce:22:0d$$$$00:1e:4f:d4:ce:31$$$$00:00:74:b3:ed:bb$$$$00:08:02:be:f3:9d$$$$00:00:74:ce:22:75$$$$00:1a:a0:ca:bf:a0$$$$00:00:74:b3:ed:cc$$$$00:20:4a:b0:40:eb$$$$00:19:aa:ab:4d:b9$$$$00:00:74:b4:01:56$$$$00:00:74:b4:04:83$$$$00:00:74:b4:04:d9$$$$00:00:74:ce:2a:d0$$$$00:08:c7:19:93:5f$$$$00:80:64:70:94:e9$$$$00:03:22:04:b3:e2$$$$00:80:64:70:a3:fa$$$$00:00:74:b3:ac:cb$$$$00:08:02:e3:05:9
ITEM_4     :
ID : 1

Dans GLPI, j'ai Dix ligne avec seule la première de remplie (alors que mes tables sont bien fournies).

Quelqu'un à une idée de pourquoi ça fait ça?

ddurieux

Plugins Dev

From: Propières, France

Registered: 2005-06-17

Posts: 7,521

Re: Bug Plugin (HOOK)

résolu grâce à Remi (il faut rajouter le forcegroupby)

remi

GLPI-DEV

From: Champagne

Registered: 2007-04-28

Posts: 7,127

Website

Re: Bug Plugin (HOOK)

Je ferme

---

Dév. Fedora 29 - PHP 5.6/7.0/7.1/7.2/7.3/7.4 - MariaDB 10.3 - GLPI master
Certifié ITILv3 - RPM pour Fedora, RHEL et CentOS sur https://blog.remirepo.net/