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-08-17 17:25:06

rui.santos
Member
Registered: 2018-01-21
Posts: 3

Artigos / Computadores Pesquisa

Olá ,


Quando clico na lista de computadores , aparece-me vazia . tenho este problema desde que miguei para a versão 9.2.1  e agora na 9.2.4 está igual ....



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

Podem ajudar  ?

Obrigado.

Offline

#2 2018-09-04 21:41:08

joseleno.bruno
Member
Registered: 2018-08-23
Posts: 10

Re: Artigos / Computadores Pesquisa

Confirme se a versão do plugin do fusion inventory que ta instalada é compativel com a versão que atualizou

no site do glpi ele relata essa versoes

Outra possibilidade é as tabelas não foram exportada, nesse link ele explica https://www.youtube.com/watch?v=CP5j2GjFDcY

Offline

#3 2018-09-04 21:41:52

joseleno.bruno
Member
Registered: 2018-08-23
Posts: 10

Re: Artigos / Computadores Pesquisa

Confirme se a versão do plugin do fusion inventory que ta instalada é compativel com a versão que atualizou

no site do glpi ele relata essa versoes

Outra possibilidade é as tabelas não foram exportada, nesse link ele explica https://www.youtube.com/watch?v=CP5j2GjFDcY

Offline

Board footer

Powered by FluxBB