You are not logged in.
Bonjour
J'ai voulu ajouter l'affichage du champ architecture dans le listing des ordinateurs.
Mais depuis tout à disparu et je n'ai plus acces à la gestion de l'affichage des champs
J'ai fait raz sur les critères de recherche, pas mieux
Une idée ?
Offline
voila l'erreur qui apparaît dans le log mysql:
Error: Expression #18 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'glpi.glpi_plugin_fusioninventory_computerarchs_300d909c05837cff22d0d2b838b7861e.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Offline
l'erreur avec la totalité de la requete :
2016-06-08 09:25:02 [2@octopus]
*** MySQL query error:
SQL: SELECT \'glpi\' AS currentuser,
`glpi_computers`.`name` AS `ITEM_0`,
`glpi_computers`.`id` AS `ITEM_0_id`,
`glpi_states`.`completename` AS `ITEM_1`, `glpi_manufacturers`.`name` AS `ITEM_2`, `glpi_computers`.`serial` AS `ITEM_3`, `glpi_computertypes`.`name` AS `ITEM_4`, `glpi_computermodels`.`name` AS `ITEM_5`, `glpi_operatingsystems`.`name` AS `ITEM_6`, `glpi_locations`.`completename` AS `ITEM_7`, `glpi_computers`.`date_mod` AS `ITEM_8`, IFNULL(GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`designation`, \'__NULL__\'),
\'$#$\',`glpi_deviceprocessors_7083fb7d2b7a8b8abd619678acc5b604`.`id`) SEPARATOR \'$$##$$\'),
\'__NULL__$#$\')
AS `ITEM_9`,
IFNULL(GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_computerdisks`.`freesize`, \'__NULL__\'),
\'$#$\',`glpi_computerdisks`.`id`) SEPARATOR \'$$##$$\'),
\'__NULL__$#$\')
AS `ITEM_10`,
IFNULL(GROUP_CONCAT(DISTINCT CONCAT(IFNULL(`glpi_computerdisks`.`totalsize`, \'__NULL__\'),
\'$#$\',`glpi_computerdisks`.`id`) SEPARATOR \'$$##$$\'),
\'__NULL__$#$\')
AS `ITEM_11`,
`glpi_operatingsystemversions`.`name` AS `ITEM_12`, `glpi_computers`.`os_licenseid` AS `ITEM_13`, `glpi_operatingsystemservicepacks`.`name` AS `ITEM_14`, `glpi_plugin_fusioninventory_computerarchs_300d909c05837cff22d0d2b838b7861e`.`name` AS `ITEM_15`, `glpi_computers`.`id` AS id FROM `glpi_computers`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_operatingsystems`
ON (`glpi_computers`.`operatingsystems_id` = `glpi_operatingsystems`.`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_computerdisks`
ON (`glpi_computers`.`id` = `glpi_computerdisks`.`computers_id`
)LEFT JOIN `glpi_operatingsystemversions`
ON (`glpi_computers`.`operatingsystemversions_id` = `glpi_operatingsystemversions`.`id`
)LEFT JOIN `glpi_operatingsystemservicepacks`
ON (`glpi_computers`.`operatingsystemservicepacks_id` = `glpi_operatingsystemservicepacks`.`id`
) LEFT JOIN `glpi_plugin_fusioninventory_inventorycomputercomputers`
ON (`glpi_computers`.`id` = `glpi_plugin_fusioninventory_inventorycomputercomputers`.`computers_id`
)LEFT JOIN `glpi_plugin_fusioninventory_computerarchs` AS `glpi_plugin_fusioninventory_computerarchs_300d909c05837cff22d0d2b838b7861e`
ON (`glpi_plugin_fusioninventory_inventorycomputercomputers`.`plugin_fusioninventory_computerarchs_id` = `glpi_plugin_fusioninventory_computerarchs_300d909c05837cff22d0d2b838b7861e`.`id`
) WHERE `glpi_computers`.`is_deleted` = \'0\' AND `glpi_computers`.`is_template` = \'0\' GROUP BY `glpi_computers`.`id` ORDER BY ITEM_0 ASC LIMIT 0, 200
Error: Expression #18 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'glpi.glpi_plugin_fusioninventory_computerarchs_300d909c05837cff22d0d2b838b7861e.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
Backtrace :
inc/search.class.php:903
inc/search.class.php:98 Search::constructDatas()
inc/search.class.php:81 Search::showList()
front/computer.php:44 Search::show()
Offline
Je ne sais pas du tout si c'est normal, mais je serai toi je tenterai ça (après un backup, bien sur).
Remplacer ça :
SET sql_mode = 'ONLY_FULL_GROUP_BY';
par ça :
SET sql_mode = ''
GLPI 0.90.2
Debian 8 up to date
Offline
je mets ca ou ?
Offline
Dans la console de MySQL, mais fait une sauvegarde avant.
Offline
ca ne semble pas faire grand chose,
mysql> SET sql_mode = '';
Query OK, 0 rows affected, 1 warning (0,00 sec)
Offline
Je susis en ubuntu 16.04...
J'ai ajouter la ligne sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
dans /etc/mysql/mysql.conf.d/mysqld.cnf
et redémarrer mysql, j'ai retrouvé mes petits...
Offline
Je susis en ubuntu 16.04...
Information utile ^^
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Effectivement, comme ONLY_FULL_GROUP_BY n'est pas présent, plus de raison que ça bug (on peut le voir grace à ça dans ton log : which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by).
GLPI 0.90.2
Debian 8 up to date
Offline