ajouter de champ dans l'affichage > plus rien

isanaud · 2016-06-08 09:13:09

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 ?

isanaud · 2016-06-08 09:27:12

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

isanaud · 2016-06-08 09:29:06

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()

KarsFSF · 2016-06-08 09:30:12

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 = ''

isanaud · 2016-06-08 09:51:37

je mets ca ou ?

jean-charles.lamer · 2016-06-08 10:15:29

Dans la console de MySQL, mais fait une sauvegarde avant.

isanaud · 2016-06-08 11:02:49

ca ne semble pas faire grand chose,

mysql> SET sql_mode = '';
Query OK, 0 rows affected, 1 warning (0,00 sec)

isanaud · 2016-06-08 11:08:36

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...

KarsFSF · 2016-06-08 11:17:39

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).

Forum GLPI-Project

Announcement

#1 2016-06-08 09:13:09

ajouter de champ dans l'affichage > plus rien

#2 2016-06-08 09:27:12

Re: ajouter de champ dans l'affichage > plus rien

#3 2016-06-08 09:29:06

Re: ajouter de champ dans l'affichage > plus rien

#4 2016-06-08 09:30:12

Re: ajouter de champ dans l'affichage > plus rien

#5 2016-06-08 09:51:37

Re: ajouter de champ dans l'affichage > plus rien

#6 2016-06-08 10:15:29

Re: ajouter de champ dans l'affichage > plus rien

#7 2016-06-08 11:02:49

Re: ajouter de champ dans l'affichage > plus rien

#8 2016-06-08 11:08:36

Re: ajouter de champ dans l'affichage > plus rien

#9 2016-06-08 11:17:39

Re: ajouter de champ dans l'affichage > plus rien

Board footer