fusioninventory-for-glpi
fusioninventory-for-glpi copied to clipboard
fusioninventory
[GLPI 9.5.7] Dynamic Groups : unable to filter by Software
With GLPI 9.5.7 and FusionInventory 9.5+3.0, dynamic groups are broken when filtering by software. Version is replaced par serial number.
With GLPI 9.5.6
With GLPI 9.5.7
I not have this problem.
Can you give me the request (field fields_array) in table glpi_softwareversions of the database, related to this group?
could you be more specific ? i don't understand what to do with fields_array
on GLPI 9.5.6, the request is :
SELECT DISTINCT glpi_computers.id AS id, 'ppenin' AS currentuser, glpi_computers.entities_id, glpi_computers.is_recursive, glpi_computers.name AS ITEM_Computer_1, glpi_computers.id AS ITEM_Computer_1_id, glpi_entities.completename AS ITEM_Computer_80, glpi_computers.id AS ITEM_Computer_2, glpi_states.completename AS ITEM_Computer_31, GROUP_CONCAT(DISTINCT CONCAT(glpi_softwares.name, '$#$' , glpi_softwares.id)
ORDER BY glpi_softwares.id SEPARATOR '$$##$$') AS ITEM_Software_1, GROUP_CONCAT(DISTINCT CONCAT(glpi_softwares.name, ' - ', glpi_softwareversions_Software.name, '$#$', glpi_softwareversions_Software.id) SEPARATOR '$$##$$') AS ITEM_Software_5
FROM glpi_computers
LEFT JOIN glpi_entities ON (glpi_computers.entities_id = glpi_entities.id )
LEFT JOIN glpi_states ON (glpi_computers.states_id = glpi_states.id )
LEFT JOIN glpi_items_softwareversions AS glpi_items_softwareversions_Software ON (glpi_items_softwareversions_Software.items_id = glpi_computers.id AND glpi_items_softwareversions_Software.itemtype = 'Computer' AND glpi_items_softwareversions_Software.is_deleted = 0)
LEFT JOIN glpi_softwareversions AS glpi_softwareversions_Software ON (glpi_items_softwareversions_Software.softwareversions_id = glpi_softwareversions_Software.id)
LEFT JOIN glpi_softwares ON (glpi_softwareversions_Software.softwares_id = glpi_softwares.id)
LEFT JOIN glpi_softwarelicenses AS glpi_softwarelicenses_Software ON (glpi_softwares.id = glpi_softwarelicenses_Software.softwares_id)
WHERE glpi_computers.is_deleted = 0 AND glpi_computers.is_template = 0 AND ( (glpi_computers.name LIKE '%E0%' ) AND (glpi_states.id = '2') AND ((glpi_computers.name NOT LIKE '%D1%' OR glpi_computers.name IS NULL) ) AND ((glpi_computers.name NOT LIKE '%L1%' OR glpi_computers.name IS NULL) ) AND (glpi_softwares.name LIKE '%Citrix Workspace (DV)%' ) AND (glpi_softwareversions_Software.id <> '43339' OR glpi_softwareversions_Software.id IS NULL) AND ((glpi_computers.name NOT LIKE '%FILE01%' OR glpi_computers.name IS NULL) ) ) GROUP BY glpi_computers.id
ORDER BY ITEM_Computer_1 ASC
with debug mode, an error is displayed in 9.5.6 but not blocking PHP Warning (2): Invalid argument supplied for foreach() in /var/www/html/glpi/plugins/fusioninventory/inc/computer.class.php at line 77
I have the same problem, would like to know if there exists already a fix. GLPI version 9.5.7 Thanks.
any news about this issue ? additional information is needed ?
@ppenin, as there is no news from the author, you can try to replace the /inc/search.class.php file with the same file from GLPI 9.5.6. Seems that there were changes that affects the plugin.
Here you can see the changes that they did: https://github.com/glpi-project/glpi/pull/9560/files
The attached file is from 9.5.6 version, you can use it I think, or at least to check if works on your side too search.class.php.zip .
I have tried many things and not reproduce this problem :(
In my case, it was an upgrade of GLPI 9.5.6 to GLPI 9.5.7, after the upgrade the problem appeared.
I ugraded FI 9.5+3.0 to 9.5+4.0 with the rigth procedure : success.
I upgraded GLPI from 9.5.6 to 9.5.7 : success but dynamic groups FI are broken when filtering by software. Version is replaced par serial number.
Hello @alexlesan,
i upgraded GLPI from 9.5.6 to 9.5.7 and replaced /inc/search.class.php file from GLPI 9.5.6 : dynamic groups when filtering by software work well !
Therefore, there is a php warning about ./fusioninventory/inc/computer.class.php
Bonjour, je relance ce problème, il m'arrive exactement la même chose sur la version 10 de GLPI. Le plus intrigant, c'est que cela ne le fait pas sur tout les groupe. Sur certains, la règle reste bien sur les logiciel avec la bonne liste.
J'ai l'impression qu'à partir du moment où le critère logiciel est en premier, cela ne marche pas C'est une piste mais assez compliqué a tester car en plus si je supprime le critère logiciel, cela me supprime tout les critère. Le comportement est assez étrange.