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 2020-09-07 12:15:25

guillaume.herve
Member
Registered: 2016-08-24
Posts: 25

[GLPI 9.5.1] 0 ordinateurs à l'affichage

Bonjour,

Depuis le passage en 9.5.1, le tableau de bord m'affiche 389 PC, mais quand je clique dessus (ou par le menu Parc / Ordinateurs), je n'ai rien dans la liste.
Même les recherches ne donnent rien.
Les autres composants du Parc s'affichent bien.

Offline

#2 2020-09-07 21:43:48

guillaume.herve
Member
Registered: 2016-08-24
Posts: 25

Re: [GLPI 9.5.1] 0 ordinateurs à l'affichage

Un collègue avec un profil admin (j'étais en super-admin), a cette erreur SQL :

SQL Error "1064": You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'glpi_items_devicememories``.`size`) / COUNT(``glpi_items_devicememories``.`id`))' at line 12 in query "SELECT DISTINCT `glpi_computers`.`id` AS id, 'gherve' 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_computers`.`serial` AS `ITEM_Computer_5`, `glpi_computertypes`.`name` AS `ITEM_Computer_4`, `glpi_computermodels`.`name` AS `ITEM_Computer_40`, `glpi_operatingsystems_9719987b154aaf3b42c3db32aef59090`.`name` AS `ITEM_Computer_45`, `glpi_locations`.`completename` AS `ITEM_Computer_3`, `glpi_computers`.`date_mod` AS `ITEM_Computer_19`, `glpi_plugin_fusioninventory_agents`.`last_contact` AS `ITEM_Computer_5197`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`designation`, '__NULL__'), '$#$',`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id`) ORDER BY `glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id` SEPARATOR '$$##$$') AS `ITEM_Computer_17`, `glpi_users`.`name` AS `ITEM_Computer_70`, `glpi_users`.`realname` AS `ITEM_Computer_70_realname`, `glpi_users`.`id` AS `ITEM_Computer_70_id`, `glpi_users`.`firstname` AS `ITEM_Computer_70_firstname`, `glpi_computers`.`contact` AS `ITEM_Computer_7`, (SUM(``glpi_items_devicememories``.`size`) / COUNT(``glpi_items_devicememories``.`id`)) * COUNT(DISTINCT ``glpi_items_devicememories``.`id`) AS `ITEM_Computer_111` 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_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_plugin_fusioninventory_agents` ON (`glpi_computers`.`id`=`glpi_plugin_fusioninventory_agents`.`computers_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_users` ON (`glpi_computers`.`users_id` = `glpi_users`.`id` ) LEFT JOIN `glpi_items_devicememories` ON (`glpi_computers`.`id` = `glpi_items_devicememories`.`items_id` AND `glpi_items_devicememories`.`itemtype` = 'Computer' ) WHERE `glpi_computers`.`is_deleted` = 0 AND `glpi_computers`.`is_template` = 0 GROUP BY `glpi_computes`.`id`

Last edited by guillaume.herve (2020-09-09 09:13:34)

Offline

#3 2020-09-07 21:56:38

guillaume.herve
Member
Registered: 2016-08-24
Posts: 25

Re: [GLPI 9.5.1] 0 ordinateurs à l'affichage

J'ai mis la requête à plat, et il y a 2 erreurs.
Ligne 23 : il y a 2 fois des quotes qui entoure le champ glpi_items_devicememories
dans :

(SUM(``glpi_items_devicememories``.`size`) / COUNT(``glpi_items_devicememories``.`id`)) * COUNT(DISTINCT ``glpi_items_devicememories``.`id`) AS `ITEM_Computer_111` 

Puis une erreur dan le GROUP BY à la fin :

GROUP BY `glpi_computes`.`id` 

Il manque un r à computers

Comment peut-on la corriger ?

Last edited by guillaume.herve (2020-09-09 09:10:04)

Offline

#4 2020-09-09 09:16:37

guillaume.herve
Member
Registered: 2016-08-24
Posts: 25

Re: [GLPI 9.5.1] 0 ordinateurs à l'affichage

Bonjour,

Pour ajouter un peu d'infos, j'ai le tableau de bord qu'en Super-Admin.
Mais quelque soit mon profil, la liste est vide.
Pas d'erreur.
Mon collègue lui a l'erreur SQL, peu importe son profil...

Offline

#5 2020-09-16 16:36:45

guillaume.herve
Member
Registered: 2016-08-24
Posts: 25

Re: [GLPI 9.5.1] 0 ordinateurs à l'affichage

Un petit UP

Offline

Board footer

Powered by FluxBB