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"
]]>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
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
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 ?
]]>