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
Guest
Registered: 2017-10-20
Posts: 5

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 ?

Offline

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

mklimasz
Guest
Registered: 2017-12-14
Posts: 17

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
Guest
Registered: 2017-12-14
Posts: 17

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
Guest
Registered: 2017-12-14
Posts: 17

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
Guest
Registered: 2017-10-20
Posts: 5

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

Offline

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

mboot59
Guest
Registered: 2017-10-20
Posts: 5

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

Offline

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

mklimasz
Guest
Registered: 2017-12-14
Posts: 17

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

Board footer

Powered by FluxBB