You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2019-09-25 14:33:44

mboot59
Member
From: Zagreb, Croatia
Registered: 2017-10-20
Posts: 13

after update from 9.4.3 to 9.4.4 assets search does not work

after update from 9.4.3 to 9.4.4 on centos 7 with php 7.2 and mariadb100u-server-10.0.38-1.el7.ius
the default search "items seen" "contains" does not work
i can see all assets with out search and by selecting search on Name i can search

so far i can see this wrong behaviour on "Assets", "Domain", "Groups"

searches on other tables seem to work ok the way it used to be

anyone else seen this ?


glpi 946, plugins webApplications , fusionInventory, domains, appliances, additional fields. (experimented with many other plugins over the years)
authentication with ActiveDirectory. Long term user of glpi from the 8.x versions. centos7/centos8; mariadb

Offline

#2 2019-10-03 13:09:19

mklimasz
Member
Registered: 2017-12-14
Posts: 82

Re: after update from 9.4.3 to 9.4.4 assets search does not work

Interestingly, this very functionality hasn't been working for a while (couple of minutes) on our test environment, then "unlocked" itself (now working ok, and that was the one of testing points). For live environment thou, we still not have the "Items seen" search available after upgrade to 9.4.4 - perhaps some indexing takes place in the background, that we're not aware of? Anyone else notices such behavior?

Offline

#3 2019-10-09 10:18:46

mklimasz
Member
Registered: 2017-12-14
Posts: 82

Re: after update from 9.4.3 to 9.4.4 assets search does not work

To follow up on the subject (witch may be associated with issue #6388): originally the following error appeared in the console (Unknown column 'glpi_groups.completename' in 'where clause'), after applying most recent bugfix pack, it changed to (Unknown column 'glpi_groups_groups_id_tech.completename' in 'where clause'). It is very strange, as the originally observed error tries to reffer to an existing table (glpi_groups.completename exists and can be accessed), while the (supposedly) corrected code points to a non-existent table (glpi_groups_groups_id_tech).

Offline

#4 2019-10-10 14:12:55

mklimasz
Member
Registered: 2017-12-14
Posts: 82

Re: after update from 9.4.3 to 9.4.4 assets search does not work

[UPDATE] Problem disappears when either "Technician in Charge of the Hardware", or "Group in Charge of the Hardware" are removed from the view (Global View configuration, columns to display). This workaround has been identified as a result of issue #6397 analysis.

Offline

#5 2019-10-11 09:36:47

mboot59
Member
From: Zagreb, Croatia
Registered: 2017-10-20
Posts: 13

Re: after update from 9.4.3 to 9.4.4 assets search does not work

in my case i also happens with the following field:

Unknown column 'glpi_plugin_fusioninventory_inventorycomputercomputers.last_fusioninventory_update' in 'where clause'

but its good to know that removing that field from the display list makes it work again

SELECT DISTINCT `glpi_computers`.`id` AS id, 'mboot' 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_states`.`completename` AS `ITEM_Computer_31`, `glpi_manufacturers`.`name` AS `ITEM_Computer_23`, `glpi_computermodels`.`name` AS `ITEM_Computer_40`, `glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`.`name` AS `ITEM_Computer_45`, `glpi_locations`.`completename` AS `ITEM_Computer_3`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_ipaddresses_0cc35feab42e5909929ff742b4834540`.`name`, '__NULL__'), '$#$',`glpi_ipaddresses_0cc35feab42e5909929ff742b4834540`.`id`)
ORDER BY `glpi_ipaddresses_0cc35feab42e5909929ff742b4834540`.`id` SEPARATOR '$$##$$') AS `ITEM_Computer_126`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_plugin_fields_domainmemberfielddropdowns_466343bd88a8a16a635f9ef2206a41a2`.`completename`, '__NULL__'), '$#$',`glpi_plugin_fields_domainmemberfielddropdowns_466343bd88a8a16a635f9ef2206a41a2`.`id`)
ORDER BY `glpi_plugin_fields_domainmemberfielddropdowns_466343bd88a8a16a635f9ef2206a41a2`.`id` SEPARATOR '$$##$$') AS `ITEM_Computer_76665`, `glpi_plugin_fusioninventory_inventorycomputercomputers_id`.`last_fusioninventory_update` AS `ITEM_Computer_5150`
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_manufacturers` ON (`glpi_computers`.`manufacturers_id` = `glpi_manufacturers`.`id` )
LEFT JOIN `glpi_computermodels` ON (`glpi_computers`.`computermodels_id` = `glpi_computermodels`.`id` )
LEFT JOIN `glpi_items_operatingsystems` ON (`glpi_computers`.`id` = `glpi_items_operatingsystems`.`items_id` AND `glpi_items_operatingsystems`.`itemtype` = 'Computer' )
LEFT JOIN `glpi_operatingsystems` AS `glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090` ON (`glpi_items_operatingsystems`.`operatingsystems_id` = `glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`.`id` )
LEFT JOIN `glpi_locations` ON (`glpi_computers`.`locations_id` = `glpi_locations`.`id` )
LEFT JOIN `glpi_ipaddresses` AS `glpi_ipaddresses_0cc35feab42e5909929ff742b4834540` ON (`glpi_computers`.`id` = `glpi_ipaddresses_0cc35feab42e5909929ff742b4834540`.`mainitems_id` AND `glpi_ipaddresses_0cc35feab42e5909929ff742b4834540`.`mainitemtype` = 'Computer' AND `glpi_ipaddresses_0cc35feab42e5909929ff742b4834540`.`is_deleted` = 0 )
LEFT JOIN `glpi_plugin_fields_computerdomainmembers` ON (`glpi_computers`.`id` = `glpi_plugin_fields_computerdomainmembers`.`items_id` AND `glpi_plugin_fields_computerdomainmembers`.`itemtype` = 'Computer' )
LEFT JOIN `glpi_plugin_fields_domainmemberfielddropdowns` AS `glpi_plugin_fields_domainmemberfielddropdowns_466343bd88a8a16a635f9ef2206a41a2` ON (`glpi_plugin_fields_computerdomainmembers`.`plugin_fields_domainmemberfielddropdowns_id` = `glpi_plugin_fields_domainmemberfielddropdowns_466343bd88a8a16a635f9ef2206a41a2`.`id` )
LEFT JOIN `glpi_plugin_fusioninventory_inventorycomputercomputers` AS glpi_plugin_fusioninventory_inventorycomputercomputers_id ON (`glpi_computers`.`id` = `glpi_plugin_fusioninventory_inventorycomputercomputers_id`.`computers_id` )
WHERE `glpi_computers`.`is_deleted` = 0 AND `glpi_computers`.`is_template` = 0 AND ( ( (`glpi_computers`.`name` LIKE '%R430%' ) OR (`glpi_entities`.`completename` LIKE '%R430%' ) OR (`glpi_states`.`completename` LIKE '%R430%' ) OR (`glpi_manufacturers`.`name` LIKE '%R430%' ) OR (`glpi_computermodels`.`name` LIKE '%R430%' ) OR (`glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`.`name` LIKE '%R430%' ) OR (`glpi_locations`.`completename` LIKE '%R430%' ) OR (`glpi_ipaddresses_0cc35feab42e5909929ff742b4834540`.`name` LIKE '%R430%' ) OR (`glpi_plugin_fields_domainmemberfielddropdowns_466343bd88a8a16a635f9ef2206a41a2`.`completename` LIKE '%R430%' ) OR (CONVERT(`glpi_plugin_fusioninventory_inventorycomputercomputers`.`last_fusioninventory_update` USING utf8) LIKE '%R430%' )) ) GROUP BY `glpi_computers`.`id`
ORDER BY ITEM_Computer_1 ASC


glpi 946, plugins webApplications , fusionInventory, domains, appliances, additional fields. (experimented with many other plugins over the years)
authentication with ActiveDirectory. Long term user of glpi from the 8.x versions. centos7/centos8; mariadb

Offline

#6 2019-10-11 10:20:47

mboot59
Member
From: Zagreb, Croatia
Registered: 2017-10-20
Posts: 13

Re: after update from 9.4.3 to 9.4.4 assets search does not work

similar on groups it chokes on the additional field i created called groupmail

Unknown column 'glpi_plugin_fields_groupgroupmails.groupmailfield' in 'where clause'

SELECT DISTINCT `glpi_groups`.`id` AS id, 'mboot' AS currentuser, `glpi_groups`.`entities_id`, `glpi_groups`.`is_recursive`, `glpi_groups`.`completename` AS `ITEM_Group_1`, `glpi_groups`.`id` AS `ITEM_Group_1_id`, `glpi_entities`.`completename` AS `ITEM_Group_80`, `glpi_groups`.`ldap_group_dn` AS `ITEM_Group_5`, `glpi_plugin_fields_groupgroupmails_groupmailfield`.`groupmailfield` AS `ITEM_Group_76665`, `glpi_groups`.`is_task` AS `ITEM_Group_72`, `glpi_groups`.`is_itemgroup` AS `ITEM_Group_17`, `glpi_groups`.`is_usergroup` AS `ITEM_Group_15`, `glpi_groups`.`ldap_value` AS `ITEM_Group_4`
FROM `glpi_groups`
LEFT JOIN `glpi_entities` ON (`glpi_groups`.`entities_id` = `glpi_entities`.`id` )
LEFT JOIN `glpi_plugin_fields_groupgroupmails` AS `glpi_plugin_fields_groupgroupmails_groupmailfield` ON (`glpi_groups`.`id` = `glpi_plugin_fields_groupgroupmails_groupmailfield`.`items_id` AND `glpi_plugin_fields_groupgroupmails_groupmailfield`.`itemtype` = 'Group' )
WHERE ( 1 ) AND ( ( (`glpi_groups`.`completename` LIKE '%black%' ) OR (`glpi_entities`.`completename` LIKE '%black%' ) OR (`glpi_groups`.`ldap_group_dn` LIKE '%black%' ) OR (`glpi_plugin_fields_groupgroupmails`.`groupmailfield` LIKE '%black%' ) OR (`glpi_groups`.`is_task` LIKE '%black%' ) OR (`glpi_groups`.`is_itemgroup` LIKE '%black%' ) OR (`glpi_groups`.`is_usergroup` LIKE '%black%' ) OR (`glpi_groups`.`ldap_value` LIKE '%black%' )) )
ORDER BY ITEM_Group_1 ASC


glpi 946, plugins webApplications , fusionInventory, domains, appliances, additional fields. (experimented with many other plugins over the years)
authentication with ActiveDirectory. Long term user of glpi from the 8.x versions. centos7/centos8; mariadb

Offline

#7 2019-10-11 15:57:02

mklimasz
Member
Registered: 2017-12-14
Posts: 82

Re: after update from 9.4.3 to 9.4.4 assets search does not work

There must have been a significant change into the search routines in 9.4.4, as it manifests itself in many ways (additional fields, additional tables, also - complex searches containing multiple clauses, searches depending on the view...). I only hope this is reversible, or can easily be repaired (thou, when I look at the proposed bugfixes and magic needed to even understand the code - I doubt it can be easy in any way...)

Offline

#8 2019-10-19 21:45:03

NIYALI
Member
Registered: 2019-10-18
Posts: 10

Re: after update from 9.4.3 to 9.4.4 assets search does not work

mklimasz wrote:

There must have been a significant change into the search routines in 9.4.4, as it manifests itself in many ways (additional fields, additional tables, also - complex searches containing https://rufus.vip/ https://www.ucbrowser.pro/ https://filezilla.software/multiple clauses, searches depending on the view...). I only hope this is reversible, or can easily be repaired (thou, when I look at the proposed bugfixes and magic needed to even understand the code - I doubt it can be easy in any way...)

so far i can see this wrong behaviour on "Assets", "Domain", "Groups"

Last edited by NIYALI (2019-10-20 23:11:45)

Offline

Board footer

Powered by FluxBB