You are not logged in.
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
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
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
[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
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
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
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
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