Forum GLPI-Project

rui.santos

Member

Registered: 2018-01-21

Posts: 3

BUG Computers

Hello,

when i check the computer  list , is empty . 

This problem its apening when upgrade for the version 9.2.1

Now I use the last GLPI version  9.2.2, and the problem is the same

I have this debug :

1    SELECT `glpi_plugins`.*
FROM `glpi_plugins`
WHERE `glpi_plugins`.`directory` = 'fusioninventory'    0.000    
2    SELECT `glpi_plugins`.*
FROM `glpi_plugins`
WHERE `glpi_plugins`.`directory` = 'fusioninventory'    0.000    
3    SELECT TABLE_NAME
FROM information_schema.`TABLES`
WHERE TABLE_SCHEMA = 'glpi' AND TABLE_TYPE = 'BASE TABLE' AND TABLE_NAME LIKE '%glpi_plugin_fusioninventory_configs%'    0.001    
4    SELECT *
FROM `glpi_plugin_fusioninventory_configs`    0.000    
5    SELECT `savedsearches_id`
FROM `glpi_savedsearches_users`
WHERE `users_id` = 7 AND `itemtype` = 'Computer'    0.000    Table 'glpi.glpi_savedsearches_users' doesn't exist
6    SELECT *
FROM `glpi_plugin_fusioninventory_collects`
WHERE ( 1 )    0.000    
7    SHOW COLUMNS
FROM `glpi_computers`    0.001    
8    SELECT *
FROM `glpi_displaypreferences`
WHERE `itemtype` = 'Computer' AND (`users_id` = '7' OR `users_id` = '0')
ORDER BY `users_id`, `rank`    0.000    
9    SELECT *
FROM `glpi_plugin_fusioninventory_agentmodules`    0.000    
10    SELECT *
FROM `glpi_plugin_fusioninventory_agentmodules`    0.000    
11    SET SESSION group_concat_max_len = 16384;    0.000    
12    SELECT 'Rui.Santos' AS currentuser, `glpi_computers`.`entities_id`, `glpi_computers`.`is_recursive`, `glpi_computers`.`name` AS `ITEM_0`, `glpi_computers`.`id` AS `ITEM_0_id`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_ipaddresses_0cc35feab42e5909929ff742b4834540`.`name`, '__NULL__'), '$#$',`glpi_ipaddresses_0cc35feab42e5909929ff742b4834540`.`id`) SEPARATOR '$$##$$') AS `ITEM_1`, `glpi_users`.`name` AS `ITEM_2`, `glpi_users`.`realname` AS `ITEM_2_realname`, `glpi_users`.`id` AS `ITEM_2_id`, `glpi_users`.`firstname` AS `ITEM_2_firstname`, `glpi_states`.`completename` AS `ITEM_3`, `glpi_manufacturers`.`name` AS `ITEM_4`, `glpi_computers`.`serial` AS `ITEM_5`, `glpi_computertypes`.`name` AS `ITEM_6`, `glpi_computermodels`.`name` AS `ITEM_7`, `glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`.`name` AS `ITEM_8`, `glpi_locations`.`completename` AS `ITEM_9`, `glpi_computers`.`date_mod` AS `ITEM_10`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`designation`, '__NULL__'), '$#$',`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id`) SEPARATOR '$$##$$') AS `ITEM_11`, `glpi_computers`.`id` AS `ITEM_12`, `glpi_plugin_fusioninventory_inventorycomputercomputers`.`operatingsystem_installationdate` AS `ITEM_13`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_networkports`.`mac`, '__NULL__'), '$#$',`glpi_networkports`.`id`) SEPARATOR '$$##$$') AS `ITEM_14`, `glpi_computers`.`id` AS id
FROM `glpi_computers`
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_users` ON (`glpi_computers`.`users_id` = `glpi_users`.`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_computertypes` ON (`glpi_computers`.`computertypes_id` = `glpi_computertypes`.`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_items_deviceprocessors` ON (`glpi_computers`.`id` = `glpi_items_deviceprocessors`.`items_id` AND `glpi_items_deviceprocessors`.`itemtype` = 'Computer' )
LEFT JOIN `glpi_deviceprocessors` AS `glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604` ON (`glpi_items_deviceprocessors`.`deviceprocessors_id` = `glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id` )
LEFT JOIN `glpi_plugin_fusioninventory_inventorycomputercomputers` ON (`glpi_computers`.`id` = `glpi_plugin_fusioninventory_inventorycomputercomputers`.`computers_id` )
LEFT JOIN `glpi_networkports` ON (`glpi_computers`.`id` = `glpi_networkports`.`items_id` AND `glpi_networkports`.`itemtype` = 'Computer' )
WHERE `glpi_computers`.`is_deleted` = '0' AND `glpi_computers`.`is_template` = '0' AND ( (`glpi_computers`.`name` LIKE '%rui%' ) ) GROUP BY `glpi_computers`.`id`
ORDER BY ITEM_0 ASC    0.000    Table 'glpi.glpi_items_operatingsystems' doesn't exist
13    SHOW WARNINGS

Can you help ?

Best regards .

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: BUG Computers

Delete your bookmark on computers (in your settings) and try again

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

rui.santos

Member

Registered: 2018-01-21

Posts: 3

Re: BUG Computers

where are the bookmark ?  I dont have any bookmark ....

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: BUG Computers

In the display you want, don't select operating system.
You have the error in the trace posted: table glpi_items_operatingsystems' doesn't exist.

Look at your database if the table still exist

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)