You are not logged in.

Announcement

 Téléchargez la dernière version stable de GLPI      -     Et vous, que pouvez vous faire pour le projet GLPI ? :  Contribuer
 Download last stable version of GLPI                      -     What can you do for GLPI ? :  Contribute

#1 2018-03-23 14:22:52

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

Offline

#2 2018-03-25 11:46:37

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

Offline

#3 2018-04-04 17:00:03

yllen
GLPI-DEV
From: Sillery (51)
Registered: 2008-01-14
Posts: 15,273

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


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)

Offline

#4 2018-04-15 21:38:20

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

Offline

Board footer

Powered by FluxBB