You are not logged in.
Bonjour
Suite à une migration (GLPI 9.1.6 => 9.5.3, Databases 1.9.0=>2.3.1), j'ai identifié un problème sur L'ecran Parc=>Global si le plugin Databases est activé.
Cet écran Parc=>Global devient vide.
En mode debug, une erreur SQL est indiquée.
SQL Error "1054": Unknown column 'glpi_plugin_databases_databases.serial' in 'field list' in query "SELECT DISTINCT `glpi_computers`. ... "
Je met '...' , car la requête est monstrueuse , et doit contenir une bonne dizaine d'union , dont une se porte sur un select sur la table glpi_plugin_databases.
Evidemment en base la table en question glpi_plugin_databases_databases, ne contient pas de champ 'serial' .
Quelqu'un a t'il se problème ? Si négatif, quelle version de GLPI et Databases est utilisée ?
SELECT DISTINCT `glpi_plugin_databases_databases`.`id` AS id, '*********' AS currentuser, `glpi_plugin_databases_databases`.`name` AS `ITEM_AllAssets_1`, `glpi_plugin_databases_databases`.`id` AS `ITEM_AllAssets_1_id`, `glpi_entities`.`completename` AS `ITEM_AllAssets_80`, `glpi_states`.`completename` AS `ITEM_AllAssets_31`, `glpi_plugin_databases_databases`.`id` AS `ITEM_AllAssets_2`, `glpi_locations`.`completename` AS `ITEM_AllAssets_3`,
`glpi_plugin_databases_databases`.`serial` AS `ITEM_AllAssets_5`,
`glpi_plugin_databases_databases`.`otherserial` AS `ITEM_AllAssets_6`, `glpi_manufacturers`.`name` AS `ITEM_AllAssets_23`, `glpi_users`.`name` AS `ITEM_AllAssets_70`, `glpi_users`.`realname` AS `ITEM_AllAssets_70_realname`, `glpi_users`.`id` AS `ITEM_AllAssets_70_id`, `glpi_users`.`firstname` AS `ITEM_AllAssets_70_firstname`, `glpi_plugin_databases_databases`.`comment` AS `ITEM_AllAssets_16`, `glpi_plugin_databases_databases`.`date_mod` AS `ITEM_AllAssets_19`, `glpi_groups`.`completename` AS `ITEM_AllAssets_71`, `glpi_users_users_id_tech`.`name` AS `ITEM_AllAssets_24`, `glpi_users_users_id_tech`.`realname` AS `ITEM_AllAssets_24_realname`, `glpi_users_users_id_tech`.`id` AS `ITEM_AllAssets_24_id`, `glpi_users_users_id_tech`.`firstname` AS `ITEM_AllAssets_24_firstname`, GROUP_CONCAT(DISTINCT CONCAT(`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`name`, '$#$' , `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id`) ORDER BY `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id` SEPARATOR '$$##$$') AS `ITEM_AllAssets_29`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_budgets_93d644b41c3544155af36e354b01ba13`.`name`, '__NULL__'), '$#$',`glpi_budgets_93d644b41c3544155af36e354b01ba13`.`id`) ORDER BY `glpi_budgets_93d644b41c3544155af36e354b01ba13`.`id` SEPARATOR '$$##$$') AS `ITEM_AllAssets_50`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`num`, '__NULL__'), '$#$',`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id`) ORDER BY `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id` SEPARATOR '$$##$$') AS `ITEM_AllAssets_30`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`duration`, '__NULL__'), '$#$',`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id`) ORDER BY `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id` SEPARATOR '$$##$$') AS `ITEM_AllAssets_130`, GROUP_CONCAT(DISTINCT ADDDATE(`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`begin_date`, INTERVAL (`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`duration` ) MONTH) SEPARATOR '$$##$$') AS `ITEM_AllAssets_134`, (SUM(`glpi_contractcosts_8c799389c5430add67bdf72b7ce194bd`.`cost`) / COUNT(`glpi_contractcosts_8c799389c5430add67bdf72b7ce194bd`.`id`)) * COUNT(DISTINCT `glpi_contractcosts_8c799389c5430add67bdf72b7ce194bd`.`id`) AS `ITEM_AllAssets_136`, GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_infocoms`.`value`, '__NULL__'), '$#$',`glpi_infocoms`.`id`) ORDER BY `glpi_infocoms`.`id` SEPARATOR '$$##$$') AS `ITEM_AllAssets_54`, 'PluginDatabasesDatabase' AS TYPE FROM `glpi_plugin_databases_databases`LEFT JOIN `glpi_entities` ON (`glpi_plugin_databases_databases`.`entities_id` = `glpi_entities`.`id` )LEFT JOIN `glpi_states` ON (`glpi_plugin_databases_databases`.`states_id` = `glpi_states`.`id` )LEFT JOIN `glpi_locations` ON (`glpi_plugin_databases_databases`.`locations_id` = `glpi_locations`.`id` )LEFT JOIN `glpi_manufacturers` ON (`glpi_plugin_databases_databases`.`manufacturers_id` = `glpi_manufacturers`.`id` )LEFT JOIN `glpi_users` ON (`glpi_plugin_databases_databases`.`users_id` = `glpi_users`.`id` )LEFT JOIN `glpi_groups` ON (`glpi_plugin_databases_databases`.`groups_id` = `glpi_groups`.`id` )LEFT JOIN `glpi_users` AS `glpi_users_users_id_tech` ON (`glpi_plugin_databases_databases`.`users_id_tech` = `glpi_users_users_id_tech`.`id` ) LEFT JOIN `glpi_contracts_items` ON (`glpi_plugin_databases_databases`.`id` = `glpi_contracts_items`.`items_id` AND `glpi_contracts_items`.`itemtype` = 'PluginDatabasesDatabase' ) LEFT JOIN `glpi_contracts` AS `glpi_contracts_75a921d1c48c76553dc0a9e69050f745` ON (`glpi_contracts_items`.`contracts_id` = `glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id` ) LEFT JOIN `glpi_infocoms` ON (`glpi_plugin_databases_databases`.`id` = `glpi_infocoms`.`items_id` AND `glpi_infocoms`.`itemtype` = 'PluginDatabasesDatabase' ) LEFT JOIN `glpi_budgets` AS `glpi_budgets_93d644b41c3544155af36e354b01ba13` ON (`glpi_infocoms`.`budgets_id` = `glpi_budgets_93d644b41c3544155af36e354b01ba13`.`id` ) LEFT JOIN `glpi_contractcosts` AS `glpi_contractcosts_8c799389c5430add67bdf72b7ce194bd` ON (`glpi_contracts_75a921d1c48c76553dc0a9e69050f745`.`id` = `glpi_contractcosts_8c799389c5430add67bdf72b7ce194bd`.`contracts_id` ) WHERE ( `glpi_plugin_databases_databases`.`entities_id` IN ('6') OR (`glpi_plugin_databases_databases`.`is_recursive`='1' AND `glpi_plugin_databases_databases`.`entities_id` IN (0)) ) AND `glpi_plugin_databases_databases`.`id` IS NOT NULL AND `glpi_plugin_databases_databases`.`is_deleted` = 0 GROUP BY `glpi_plugin_databases_databases`.`id`
Cordialement
Offline
Corrigé avec la version 2.3.2.
Merci pour la livraison de cette version.
Offline