Forum GLPI-Project

noximuz

Member

Registered: 2016-03-09

Posts: 21

GLPI 9.2.2 dropdown with translations not shown in non default lang

Here is what we have in Logs:

*** MySQL query error:
  SQL: SELECT '*******' AS currentuser,
                        `glpi_itilcategories`.`entities_id`, `glpi_itilcategories`.`is_recursive`,  `glpi_itilcategories`.`completename` AS `ITEM_0`,
                        `glpi_itilcategories`.`id` AS `ITEM_0_id`,
                        `glpi_itilcategories`.`comment` AS `ITEM_1`, IFNULL(`glpi_itilcategories_trans`.`value`,'__NULL__')  AS `ITEM_1_trans`,  `glpi_itilcategories`.`id` AS id  FROM `glpi_itilcategories` WHERE   (  1 )  ORDER BY ITEM_0
ASC  LIMIT 0, 40
  Error: Unknown column 'glpi_itilcategories_trans.value' in 'field list'
  Backtrace :
  inc/search.class.php:929
  inc/search.class.php:98                            Search::constructDatas()
  inc/search.class.php:81                            Search::showList()
  front/dropdown.common.php:51               Search::show()
  front/itilcategory.php:40                           include()

---

Glpi 9.2.2

noximuz

Member

Registered: 2016-03-09

Posts: 21

Re: GLPI 9.2.2 dropdown with translations not shown in non default lang

The issue appeared after upgrade to 9.2.2

---

Glpi 9.2.2

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: GLPI 9.2.2 dropdown with translations not shown in non default lang

Corrected for next version: https://github.com/glpi-project/glpi/issues/3751

---

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)

noximuz

Member

Registered: 2016-03-09

Posts: 21

Re: GLPI 9.2.2 dropdown with translations not shown in non default lang

Thanks. Please consider adding this small but highly important improvement in next release http://forum.glpi-project.org/viewtopic … 47#p345947

Thank you very much for your support.

---

Glpi 9.2.2