You are not logged in.
- Topics: Active | Unanswered
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
Download last stable version of GLPI - What can you do for GLPI ? : Contribute
Pages: 1
#1 2015-12-02 16:54:09
- Yacine31
- Member
- Registered: 2015-10-19
- Posts: 44
Bug d'affichage dans le parc global
Bonjour,
J'ai voulu rajouter les colonnes Utilisateur et Usager dans le visualisation du parc global
et depuis plus rien ne s'affiche.
Quelqu'un a une idée ?
Merci d'avance.
Glpi 0.85.4
Offline
#2 2015-12-09 16:41:14
- Yacine31
- Member
- Registered: 2015-10-19
- Posts: 44
Re: Bug d'affichage dans le parc global
Problème résolu.
En regardant dans les log sql, j'ai vu que le problème venait d'un champs inconnu.
En fait, j'ai crée un champs et il fallait le rajouter "à la mano" à chaque objet... Pas très pratique...
Glpi 0.85.4
Offline
#3 2015-12-10 16:47:15
- orthagh
- Administrator
- From: TECLIB - CAEN
- Registered: 2010-11-30
- Posts: 662
- Website
Re: Bug d'affichage dans le parc global
Pouvez-vous préciser votre version glpi et l'erreur sql que vous avez trouvé ?
Offline
#4 2015-12-10 17:29:09
- Yacine31
- Member
- Registered: 2015-10-19
- Posts: 44
Re: Bug d'affichage dans le parc global
Bonjour,
La version de GLPI est la 0.85.4 (cf ma signature)
Voici les log sql :
2015-12-09 15:17:54 [1171@SUPPORT]
*** MySQL query error:
SQL: SELECT \'mourchid\' AS currentuser,
`glpi_computers`.`name` AS `ITEM_0`,
`glpi_computers`.`id` AS `ITEM_0_id`,
`glpi_entities`.`completename` AS `ITEM_1`, `glpi_states`.`completename` AS `ITEM_2`, `glpi_users`.`name` AS `ITEM_3`,
`glpi_users`.`realname` AS `ITEM_3_realname`,
`glpi_users`.`id` AS `ITEM_3_id`,
`glpi_users`.`firstname` AS `ITEM_3_firstname`,
`glpi_computers`.`contact` AS `ITEM_4`, `glpi_computers`.`id` AS id , \'Computer\' AS TYPE 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_users`
ON (`glpi_computers`.`users_id` = `glpi_users`.`id`
) WHERE ( 1 ) AND `glpi_computers`.`id` IS NOT NULL AND `glpi_computers`.`is_deleted` = \'0\' AND `glpi_computers`.`is_template` = \'0\' UNION SELECT \'mourchid\' AS currentuser,
`glpi_monitors`.`name` AS `ITEM_0`,
`glpi_monitors`.`id` AS `ITEM_0_id`,
`glpi_entities`.`completename` AS `ITEM_1`, `glpi_states`.`completename` AS `ITEM_2`, `glpi_users`.`name` AS `ITEM_3`,
`glpi_users`.`realname` AS `ITEM_3_realname`,
`glpi_users`.`id` AS `ITEM_3_id`,
`glpi_users`.`firstname` AS `ITEM_3_firstname`,
`glpi_monitors`.`contact` AS `ITEM_4`, `glpi_monitors`.`id` AS id , \'Monitor\' AS TYPE FROM `glpi_monitors`LEFT JOIN `glpi_entities`
ON (`glpi_monitors`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_states`
ON (`glpi_monitors`.`states_id` = `glpi_states`.`id`
)LEFT JOIN `glpi_users`
ON (`glpi_monitors`.`users_id` = `glpi_users`.`id`
) WHERE ( 1 ) AND `glpi_monitors`.`id` IS NOT NULL AND `glpi_monitors`.`is_deleted` = \'0\' AND `glpi_monitors`.`is_template` = \'0\' UNION SELECT \'mourchid\' AS currentuser,
`glpi_networkequipments`.`name` AS `ITEM_0`,
`glpi_networkequipments`.`id` AS `ITEM_0_id`,
`glpi_entities`.`completename` AS `ITEM_1`, `glpi_states`.`completename` AS `ITEM_2`, `glpi_users`.`name` AS `ITEM_3`,
`glpi_users`.`realname` AS `ITEM_3_realname`,
`glpi_users`.`id` AS `ITEM_3_id`,
`glpi_users`.`firstname` AS `ITEM_3_firstname`,
`glpi_networkequipments`.`contact` AS `ITEM_4`, `glpi_networkequipments`.`id` AS id , \'NetworkEquipment\' AS TYPE FROM `glpi_networkequipments`LEFT JOIN `glpi_entities`
ON (`glpi_networkequipments`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_states`
ON (`glpi_networkequipments`.`states_id` = `glpi_states`.`id`
)LEFT JOIN `glpi_users`
ON (`glpi_networkequipments`.`users_id` = `glpi_users`.`id`
) WHERE ( 1 ) AND `glpi_networkequipments`.`id` IS NOT NULL AND `glpi_networkequipments`.`is_deleted` = \'0\' AND `glpi_networkequipments`.`is_template` = \'0\' UNION SELECT \'mourchid\' AS currentuser,
`glpi_phones`.`name` AS `ITEM_0`,
`glpi_phones`.`id` AS `ITEM_0_id`,
`glpi_entities`.`completename` AS `ITEM_1`, `glpi_states`.`completename` AS `ITEM_2`, `glpi_users`.`name` AS `ITEM_3`,
`glpi_users`.`realname` AS `ITEM_3_realname`,
`glpi_users`.`id` AS `ITEM_3_id`,
`glpi_users`.`firstname` AS `ITEM_3_firstname`,
`glpi_phones`.`contact` AS `ITEM_4`, `glpi_phones`.`id` AS id , \'Phone\' AS TYPE FROM `glpi_phones`LEFT JOIN `glpi_entities`
ON (`glpi_phones`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_states`
ON (`glpi_phones`.`states_id` = `glpi_states`.`id`
)LEFT JOIN `glpi_users`
ON (`glpi_phones`.`users_id` = `glpi_users`.`id`
) WHERE ( 1 ) AND `glpi_phones`.`id` IS NOT NULL AND `glpi_phones`.`is_deleted` = \'0\' AND `glpi_phones`.`is_template` = \'0\' UNION SELECT \'mourchid\' AS currentuser,
`glpi_printers`.`name` AS `ITEM_0`,
`glpi_printers`.`id` AS `ITEM_0_id`,
`glpi_entities`.`completename` AS `ITEM_1`, `glpi_states`.`completename` AS `ITEM_2`, `glpi_users`.`name` AS `ITEM_3`,
`glpi_users`.`realname` AS `ITEM_3_realname`,
`glpi_users`.`id` AS `ITEM_3_id`,
`glpi_users`.`firstname` AS `ITEM_3_firstname`,
`glpi_printers`.`contact` AS `ITEM_4`, `glpi_printers`.`id` AS id , \'Printer\' AS TYPE FROM `glpi_printers`LEFT JOIN `glpi_entities`
ON (`glpi_printers`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_states`
ON (`glpi_printers`.`states_id` = `glpi_states`.`id`
)LEFT JOIN `glpi_users`
ON (`glpi_printers`.`users_id` = `glpi_users`.`id`
) WHERE ( 1 ) AND `glpi_printers`.`id` IS NOT NULL AND `glpi_printers`.`is_deleted` = \'0\' AND `glpi_printers`.`is_template` = \'0\' UNION SELECT \'mourchid\' AS currentuser,
`glpi_plugin_genericobject_badges`.`name` AS `ITEM_0`,
`glpi_plugin_genericobject_badges`.`id` AS `ITEM_0_id`,
`glpi_entities`.`completename` AS `ITEM_1`, `glpi_states`.`completename` AS `ITEM_2`, `glpi_users`.`name` AS `ITEM_3`,
`glpi_users`.`realname` AS `ITEM_3_realname`,
`glpi_users`.`id` AS `ITEM_3_id`,
`glpi_users`.`firstname` AS `ITEM_3_firstname`,
`glpi_plugin_genericobject_badges`.`contact` AS `ITEM_4`, `glpi_plugin_genericobject_badges`.`id` AS id , \'PluginGenericobjectBadge\' AS TYPE FROM `glpi_plugin_genericobject_badges`LEFT JOIN `glpi_entities`
ON (`glpi_plugin_genericobject_badges`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_states`
ON (`glpi_plugin_genericobject_badges`.`states_id` = `glpi_states`.`id`
)LEFT JOIN `glpi_users`
ON (`glpi_plugin_genericobject_badges`.`users_id` = `glpi_users`.`id`
) WHERE ( 1 ) AND `glpi_plugin_genericobject_badges`.`id` IS NOT NULL AND `glpi_plugin_genericobject_badges`.`is_deleted` = \'0\' AND `glpi_plugin_genericobject_badges`.`is_template` = \'0\' UNION SELECT \'mourchid\' AS currentuser,
`glpi_plugin_genericobject_borneportatives`.`name` AS `ITEM_0`,
`glpi_plugin_genericobject_borneportatives`.`id` AS `ITEM_0_id`,
`glpi_entities`.`completename` AS `ITEM_1`, `glpi_states`.`completename` AS `ITEM_2`, `glpi_users`.`name` AS `ITEM_3`,
`glpi_users`.`realname` AS `ITEM_3_realname`,
`glpi_users`.`id` AS `ITEM_3_id`,
`glpi_users`.`firstname` AS `ITEM_3_firstname`,
`glpi_plugin_genericobject_borneportatives`.`contact` AS `ITEM_4`, `glpi_plugin_genericobject_borneportatives`.`id` AS id , \'PluginGenericobjectBorneportative\' AS TYPE FROM `glpi_plugin_genericobject_borneportatives`LEFT JOIN `glpi_entities`
ON (`glpi_plugin_genericobject_borneportatives`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_states`
ON (`glpi_plugin_genericobject_borneportatives`.`states_id` = `glpi_states`.`id`
)LEFT JOIN `glpi_users`
ON (`glpi_plugin_genericobject_borneportatives`.`users_id` = `glpi_users`.`id`
) WHERE ( 1 ) AND `glpi_plugin_genericobject_borneportatives`.`id` IS NOT NULL AND `glpi_plugin_genericobject_borneportatives`.`is_deleted` = \'0\' AND `glpi_plugin_genericobject_borneportatives`.`is_template` = \'0\' UNION SELECT \'mourchid\' AS currentuser,
`glpi_plugin_genericobject_faxes`.`name` AS `ITEM_0`,
`glpi_plugin_genericobject_faxes`.`id` AS `ITEM_0_id`,
`glpi_entities`.`completename` AS `ITEM_1`, `glpi_states`.`completename` AS `ITEM_2`, `glpi_users`.`name` AS `ITEM_3`,
`glpi_users`.`realname` AS `ITEM_3_realname`,
`glpi_users`.`id` AS `ITEM_3_id`,
`glpi_users`.`firstname` AS `ITEM_3_firstname`,
`glpi_plugin_genericobject_faxes`.`contact` AS `ITEM_4`, `glpi_plugin_genericobject_faxes`.`id` AS id , \'PluginGenericobjectFax\' AS TYPE FROM `glpi_plugin_genericobject_faxes`LEFT JOIN `glpi_entities`
ON (`glpi_plugin_genericobject_faxes`.`entities_id` = `glpi_entities`.`id`
)LEFT JOIN `glpi_states`
ON (`glpi_plugin_genericobject_faxes`.`states_id` = `glpi_states`.`id`
)LEFT JOIN `glpi_users`
ON (`glpi_plugin_genericobject_faxes`.`users_id` = `glpi_users`.`id`
) WHERE ( 1 ) AND `glpi_plugin_genericobject_faxes`.`id` IS NOT NULL AND `glpi_plugin_genericobject_faxes`.`is_deleted` = \'0\' AND `glpi_plugin_genericobject_faxes`.`is_template` = \'0\' ORDER BY ITEM_0 ASC LIMIT 0, 15
Error: Unknown column 'glpi_plugin_genericobject_borneportatives.contact' in 'field list'
Backtrace :
inc\search.class.php:888
inc\search.class.php:93 Search::constructDatas()
inc\search.class.php:77 Search::showList()
front\allassets.php:42 Search::show()Last edited by Yacine31 (2015-12-10 17:29:28)
Glpi 0.85.4
Offline
#5 2015-12-11 13:42:55
- yllen
- GLPI-DEV
- From: Sillery (51)
- Registered: 2008-01-14
- Posts: 15,278
Re: Bug d'affichage dans le parc global
C'est un problème du plugin Genericobject. Je déplace dans la bonne section
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)
Offline
Pages: 1