You are not logged in.
Hi
Debug mode enabled:
Assets > Software > Toggle browse switch > I see the warnings:
SQL Warnings: 1260: Row 956 was cut by GROUP_CONCAT() in query "SELECT DISTINCT `glpi_softwares`.`id` AS id, 'user' AS currentuser, `glpi_softwares`.`entities_id`, `glpi_softwares`.`is_recursive`, `glpi_softwares`.`name` AS `ITEM_Software_1`, `glpi_softwares`.`id` AS `ITEM_Software_1_id`, `glpi_manufacturers`.`name` AS `ITEM_Software_23`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_softwareversions`.`name`, '__NULL__'), '$#$',`glpi_softwareversions`.`id`) ORDER BY `glpi_softwareversions`.`id` SEPARATOR '$$##$$') AS `ITEM_Software_5`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_operatingsystems_0a35c270152be19b5c8a485502badcd7`.`name`, '__NULL__'), '$#$',`glpi_operatingsystems_0a35c270152be19b5c8a485502badcd7`.`id`) ORDER BY `glpi_operatingsystems_0a35c270152be19b5c8a485502badcd7`.`id` SEPARATOR '$$##$$') AS `ITEM_Software_4`, COUNT(DISTINCT `glpi_items_softwareversions_37010ce8f4633da91ded3e0a4c256dc9`.`id`) AS `ITEM_Software_72`, FLOOR(SUM(`glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`number`) * COUNT(DISTINCT `glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`id`) / COUNT(`glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`id`)) AS `ITEM_Software_163`, MIN(`glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`number`) AS `ITEM_Software_163_min`, `glpi_softwarecategories`.`completename` AS `ITEM_Software_62`, `glpi_softwares`.`comment` AS `ITEM_Software_16`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`comment`, '__NULL__'), '$#$',`glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`id`) ORDER BY `glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`id` SEPARATOR '$$##$$') AS `ITEM_Software_165`, `glpi_softwares`.`date_mod` AS `ITEM_Software_19`, `glpi_items_softwareversions_65f50a68dce7dc96c5d9edcbb29b8e92`.`date_install` AS `ITEM_Software_73` FROM `glpi_softwares`LEFT JOIN `glpi_manufacturers` ON (`glpi_softwares`.`manufacturers_id` = `glpi_manufacturers`.`id` ) LEFT JOIN `glpi_softwareversions` ON (`glpi_softwares`.`id` = `glpi_softwareversions`.`softwares_id` )LEFT JOIN `glpi_operatingsystems` AS `glpi_operatingsystems_0a35c270152be19b5c8a485502badcd7` ON (`glpi_softwareversions`.`operatingsystems_id` = `glpi_operatingsystems_0a35c270152be19b5c8a485502badcd7`.`id` ) LEFT JOIN `glpi_items_softwareversions` AS `glpi_items_softwareversions_37010ce8f4633da91ded3e0a4c256dc9` ON (`glpi_softwareversions`.`id` = `glpi_items_softwareversions_37010ce8f4633da91ded3e0a4c256dc9`.`softwareversions_id` AND `glpi_items_softwareversions_37010ce8f4633da91ded3e0a4c256dc9`.`is_deleted_item` = '0' AND `glpi_items_softwareversions_37010ce8f4633da91ded3e0a4c256dc9`.`is_deleted` = '0' AND `glpi_items_softwareversions_37010ce8f4633da91ded3e0a4c256dc9`.`is_template_item` = '0' ) LEFT JOIN `glpi_softwarelicenses` AS `glpi_softwarelicenses_6427cab6934982da77f819e079502198` ON (`glpi_softwares`.`id` = `glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`softwares_id` AND `glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`is_template` = '0' AND ((`glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`expire` IS NULL) OR (`glpi_softwarelicenses_6427cab6934982da77f819e079502198`.`expire` > NOW())) )LEFT JOIN `glpi_softwarecategories` ON (`glpi_softwares`.`softwarecategories_id` = `glpi_softwarecategories`.`id` ) LEFT JOIN `glpi_items_softwareversions` AS `glpi_items_softwareversions_65f50a68dce7dc96c5d9edcbb29b8e92` ON (`glpi_softwareversions`.`id` = `glpi_items_softwareversions_65f50a68dce7dc96c5d9edcbb29b8e92`.`softwareversions_id` AND `glpi_items_softwareversions_65f50a68dce7dc96c5d9edcbb29b8e92`.`is_deleted_item` = 0 AND `glpi_items_softwareversions_65f50a68dce7dc96c5d9edcbb29b8e92`.`is_deleted` = 0 AND `glpi_items_softwareversions_65f50a68dce7dc96c5d9edcbb29b8e92`.`is_template_item` = 0 ) WHERE `glpi_softwares`.`is_deleted` = 0 AND `glpi_softwares`.`is_template` = 0 GROUP BY `glpi_softwares`.`id` ORDER BY `id`
Do you also have this warning?
Chrome browser.
--
GLPI 10.0.7
GLPI-Inventory 1.2.1
Ubuntu Server 20.04 LTS
Offline