You are not logged in.
Pages: 1
Topic closed
Lors d’une recherche de ticket (menu ticket, fitrage : element visualisés contien xxxxx, el lorsque la colonne « Dernière modification par » a été ajouté.
La liste retournée est vide.
(fresh install Version 9.4.4 sur centos 7 prérequis respectés.)
Voici le contenu de sql-errors.log
message : Error: Unknown column 'glpi_users.realname' in 'where clause'
[root@t-testlinux _log]# cat sql-errors.log
[2019-11-08 15:26:49] glpisqllog.ERROR: DBmysql::query() in /var/www/html/glpi_verif/inc/dbmysql.class.php line 188
*** MySQL query error:
SQL: SELECT DISTINCT `glpi_tickets`.`id` AS id, 'glpi' AS currentuser,
`glpi_tickets`.`id` AS `ITEM_Ticket_2`, `glpi_tickets`.`name` AS `ITEM_Ticket_1`,
`glpi_tickets`.`id` AS `ITEM_Ticket_1_id`,
`glpi_tickets`.`id` AS `ITEM_Ticket_1_id`, `glpi_tickets`.`content` AS `ITEM_Ticket_1_content`, `glpi_tickets`.`status` AS `ITEM_Ticket_1_status`, `glpi_tickets`.`status` AS `ITEM_Ticket_12`, `glpi_tickets`.`date_mod` AS `ITEM_Ticket_19`, `glpi_tickets`.`date` AS `ITEM_Ticket_15`, `glpi_tickets`.`priority` AS `ITEM_Ticket_3`, GROUP_CONCAT(DISTINCT `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`id` SEPARATOR '$$##$$')
AS `ITEM_Ticket_4`,
GROUP_CONCAT(DISTINCT CONCAT(`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`users_id`, ' ',
`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`alternative_email`)
SEPARATOR '$$##$$') AS `ITEM_Ticket_4_2`,
GROUP_CONCAT(DISTINCT `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`id` SEPARATOR '$$##$$')
AS `ITEM_Ticket_5`,
GROUP_CONCAT(DISTINCT CONCAT(`glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`users_id`, ' ',
`glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`alternative_email`)
SEPARATOR '$$##$$') AS `ITEM_Ticket_5_2`,
`glpi_itilcategories`.`completename` AS `ITEM_Ticket_7`, `glpi_tickets`.`time_to_resolve` AS `ITEM_Ticket_18`, `glpi_tickets`.`status` AS `ITEM_Ticket_18_status`, `glpi_users_users_id_lastupdater`.`name` AS `ITEM_Ticket_64`,
`glpi_users_users_id_lastupdater`.`realname` AS `ITEM_Ticket_64_realname`,
`glpi_users_users_id_lastupdater`.`id` AS `ITEM_Ticket_64_id`,
`glpi_users_users_id_lastupdater`.`firstname` AS `ITEM_Ticket_64_firstname` FROM `glpi_tickets` LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`
ON (`glpi_tickets`.`id` = `glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`tickets_id`
AND `glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`type` = 1 )LEFT JOIN `glpi_users` AS `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`
ON (`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`users_id` = `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`id`
) LEFT JOIN `glpi_tickets_users` AS `glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`
ON (`glpi_tickets`.`id` = `glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`tickets_id`
AND `glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`type` = 2 )LEFT JOIN `glpi_users` AS `glpi_users_f201be21cd638ee780d08cba4ceff0d4`
ON (`glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`users_id` = `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`id`
)LEFT JOIN `glpi_itilcategories`
ON (`glpi_tickets`.`itilcategories_id` = `glpi_itilcategories`.`id`
)LEFT JOIN `glpi_users` AS `glpi_users_users_id_lastupdater`
ON (`glpi_tickets`.`users_id_lastupdater` = `glpi_users_users_id_lastupdater`.`id`
) WHERE `glpi_tickets`.`is_deleted` = 0 AND ( ( (`glpi_tickets`.`id` LIKE '%tes%' ) OR (`glpi_tickets`.`name` LIKE '%tes%' ) OR (`glpi_tickets`.`status` LIKE '%tes%' ) OR (CONVERT(`glpi_tickets`.`date_mod` USING utf8) LIKE '%tes%' ) OR (CONVERT(`glpi_tickets`.`date` USING utf8) LIKE '%tes%' ) OR (((`glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`realname` LIKE '%tes%'
OR `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`firstname` LIKE '%tes%'
OR `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`name` LIKE '%tes%'
OR CONCAT(`glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`realname`, ' ', `glpi_users_a5e2026cbcb683e774f93a59e24a62a4`.`firstname`) LIKE '%tes%' )
) OR (`glpi_tickets_users_d1524bb2ea1d461ab90aed3b5f0e7e60`.`alternative_email` LIKE '%tes%' )) OR (((`glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`realname` LIKE '%tes%'
OR `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`firstname` LIKE '%tes%'
OR `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`name` LIKE '%tes%'
OR CONCAT(`glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`realname`, ' ', `glpi_users_f201be21cd638ee780d08cba4ceff0d4`.`firstname`) LIKE '%tes%' )
) OR (`glpi_tickets_users_819efb92c8b927b345e489211ec8e43b`.`alternative_email` LIKE '%tes%' )) OR (`glpi_itilcategories`.`completename` LIKE '%tes%' ) OR (CONVERT(`glpi_tickets`.`time_to_resolve` USING utf8) LIKE '%tes%' ) OR (((`glpi_users`.`realname` LIKE '%tes%'
OR `glpi_users`.`firstname` LIKE '%tes%'
OR `glpi_users`.`name` LIKE '%tes%'
OR CONCAT(`glpi_users`.`realname`, ' ', `glpi_users`.`firstname`) LIKE '%tes%' )
) )) ) GROUP BY `glpi_tickets`.`id` ORDER BY ITEM_Ticket_19 DESC
Error: Unknown column 'glpi_users.realname' in 'where clause'
Backtrace :
inc/search.class.php:1246
inc/search.class.php:98 Search::constructData()
inc/search.class.php:80 Search::showList()
front/ticket.php:45 Search::show()
{"user":"2@t-testlinux"}
Last edited by mikelledelangelo (2019-11-08 17:56:11)
Offline
Bonjour,
J'ai eu le même type de problème après migration 9.4.4, voir les liens suivants :
https://github.com/glpi-project/glpi/issues/6398
https://patch-diff.githubusercontent.co … 6388.patch
ou
https://github.com/glpi-project/glpi/ra … .class.php
Offline
Pages: 1
Topic closed