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 2018-03-03 19:30:36

rui.santos
Guest
Registered: 2018-01-21
Posts: 2

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 .

Offline

#2 2018-03-12 12:33:57

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 14,127

Re: BUG Computers

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


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

Offline

#3 2018-03-12 14:35:09

rui.santos
Guest
Registered: 2018-01-21
Posts: 2

Re: BUG Computers

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

Offline

#4 2018-03-12 17:51:30

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 14,127

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
PHP 5.6 - PHP 7 - MySQL 5.6  + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

Offline

Board footer

Powered by FluxBB