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 2020-01-07 20:31:21

mecmav
Member
From: Brasil
Registered: 2019-03-22
Posts: 304

Items of locations don't displayed

Hi,

I have a GLPI 9.4.2 working fine, and have many assets on many various locations.

When I select any location in "Setup > Dropdowns > Locations" and go to "Items" in the left side of screen, the items are showed (assets and tickets).
Now, when I try apply a filter by type (computer, ticket, etc...) in the dropdown menu, nothing happen.

Is that a bug of this version?


Below, my config:

 
GLPI 9.4.2 ( => /var/www/glpi)
Installation mode: TARBALL

Server
 
Operating system: Linux myserver 4.15.0-66-generic #75-Ubuntu SMP Tue Oct 1 05:24:09 UTC 2019 x86_64
PHP 7.2.24-0ubuntu0.18.04.1 apache2handler (Core, PDO, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apache2handler, apc,
	apcu, bz2, calendar, ctype, curl, date, dom, exif, fileinfo, filter, ftp, gd, gettext, hash, iconv, imap, intl, json, ldap,
	libxml, mbstring, memcache, mysqli, mysqlnd, openssl, pcre, pdo_mysql, posix, pspell, readline, recode, session, shmop, sockets,
	sodium, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib)
Setup: max_execution_time="0" memory_limit="128M" post_max_size="16M" safe_mode="" session.save_handler="files"
	upload_max_filesize="12M" 
Software: Apache/2.4.29 (Ubuntu) (Apache/2.4.29 (Ubuntu) Server at detsed-glpi-01.detran.ms.gov.br Port 80)
	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36
Server Software: (Ubuntu)
	Server Version: 5.7.27-0ubuntu0.18.04.1
	Server SQL Mode: 
	Host info: Localhost via UNIX socket
	
mysqli extension is installed
ctype extension is installed
fileinfo extension is installed
json extension is installed
mbstring extension is installed
iconv extension is installed
zlib extension is installed
curl extension is installed
gd extension is installed
simplexml extension is installed
xml extension is installed
ldap extension is installed
imap extension is installed
Zend OPcache extension is installed
APCu extension is installed
xmlrpc extension is installed
CAS extension is installed
exif extension is installed
Database version seems correct (5.7.27) - Perfect!Database version seems correct (5.7.27) - Perfect!
OK/var/www/glpi/files/_log : OK
OK/var/www/glpi/config : OK
OK/var/www/glpi/files : OK
OK/var/www/glpi/files/_dumps : OK
OK/var/www/glpi/files/_sessions : OK
OK/var/www/glpi/files/_cron : OK
OK/var/www/glpi/files/_graphs : OK
OK/var/www/glpi/files/_lock : OK
OK/var/www/glpi/files/_plugins : OK
OK/var/www/glpi/files/_tmp : OK
OK/var/www/glpi/files/_cache : OK
OK/var/www/glpi/files/_rss : OK
OK/var/www/glpi/files/_uploads : OK
OK/var/www/glpi/files/_pictures : OK
Web access to files directory is protectedWeb access to files directory is protected : OK

Libraries
 
htmLawed version 1.2.4 in (/var/www/glpi/lib/htmlawed)
phpmailer/phpmailer version 6.0.7 in (/var/www/glpi/vendor/phpmailer/phpmailer/src)
simplepie/simplepie version 1.5.2 in (/var/www/glpi/vendor/simplepie/simplepie/library)
tecnickcom/tcpdf version 6.2.26 in (/var/www/glpi/vendor/tecnickcom/tcpdf)
michelf/php-markdown in (/var/www/glpi/vendor/michelf/php-markdown/Michelf)
true/punycode in (/var/www/glpi/vendor/true/punycode/src)
iamcal/lib_autolink in (/var/www/glpi/vendor/iamcal/lib_autolink)
sabre/vobject in (/var/www/glpi/vendor/sabre/vobject/lib)
zendframework/zend-cache in (/var/www/glpi/vendor/zendframework/zend-cache/src)
zendframework/zend-i18n in (/var/www/glpi/vendor/zendframework/zend-i18n/src)
zendframework/zend-serializer in (/var/www/glpi/vendor/zendframework/zend-serializer/src)
monolog/monolog in (/var/www/glpi/vendor/monolog/monolog/src/Monolog)
sebastian/diff in (/var/www/glpi/vendor/sebastian/diff/src)
elvanto/litemoji in (/var/www/glpi/vendor/elvanto/litemoji/src)
symfony/console in (/var/www/glpi/vendor/symfony/console)
leafo/scssphp in (/var/www/glpi/vendor/leafo/scssphp/src)
phpCas version 1.3.3 in (/usr/share/php)

LDAP directories
 

SQL replicas
 
Not active

Notifications


Mails receivers
 

Plugins list
 
	news                 Name: Alertas                        Version: 1.5.4      State: Enabled
	behaviors            Name: Comportamental                 Version: 2.2.1      State: Enabled
	addressing           Name: Endereçamento IP               Version: 2.8.0      State: Enabled
	escalade             Name: Escalonamento                  Version: 2.4.4      State: Enabled
	datainjection        Name: File injection                 Version: 2.7.0      State: Enabled
	fusioninventory      Name: FusionInventory                Version: 9.4+1.1    State: Enabled
	mod                  Name: GLPI Modifications             Version: 1.3.2      State: Enabled
	pdf                  Name: Imprimir em PDF                Version: 1.6.0      State: Enabled
	tasklists            Name: Kanban                         Version: 1.5.0      State: Enabled
	timelineticket       Name: Linha do tempo dos chamados    Version: 9.4+1.0    State: Enabled
	mreporting           Name: Mais Relatórios                Version: 1.6.1      State: Enabled
	satisfaction         Name: Mais satisfação                Version: 1.4.0      State: Not activated
	metabase             Name: metabase                       Version: 1.0.0      State: Enabled
	mydashboard          Name: Meu Painel                     Version: 1.7.6      State: Enabled
	os                   Name: Os                             Version: 0.1.1      State: Enabled
	dashboard            Name: Painel                         Version: 0.9.7      State: Enabled
	reports              Name: Relatórios                     Version: 1.13.1     State: Enabled
	telegrambot          Name: TelegramBot                    Version: 2.0.0      State: Enabled
	treeview             Name: Visão em Árvore PSG / DETRAN - Version: 1.8.1      State: Enabled

Offline

#2 2020-01-07 21:15:53

mecmav
Member
From: Brasil
Registered: 2019-03-22
Posts: 304

Re: Items of locations don't displayed

I've tested that behavior in the glpi 9.4.5 and work as expected. When I select "Ticket" it's applied the filter and I can see the tickets to that location, same for assets.

In GLPI 9.4.2 don't work as expected.

Any suggest or commit?

Offline

#3 2020-01-08 14:15:45

mecmav
Member
From: Brasil
Registered: 2019-03-22
Posts: 304

Re: Items of locations don't displayed

Hi, I can see on Debug mode, that information:

I have a SQL Request with error:

"SELECT `glpi_tickets`.`id`, `Ticket` AS `type`
FROM `glpi_tickets`
WHERE `glpi_tickets`.`locations_id` = '80' AND `is_deleted` = '0' LIMIT 20    0.000    Unknown column 'Ticket' in 'field list'"

I think because this error, I can't filter by type on this screen

Offline

#4 2020-01-08 14:40:12

mecmav
Member
From: Brasil
Registered: 2019-03-22
Posts: 304

Re: Items of locations don't displayed

mecmav wrote:

Hi, I can see on Debug mode, that information:

I have a SQL Request with error:

"SELECT `glpi_tickets`.`id`, `Ticket` AS `type`
FROM `glpi_tickets`
WHERE `glpi_tickets`.`locations_id` = '80' AND `is_deleted` = '0' LIMIT 20    0.000    Unknown column 'Ticket' in 'field list'"

I think because this error, I can't filter by type on this screen

Example 1:

https://ibb.co/4Wnnkmw


Example 2:

https://ibb.co/ZxfRpyy

Error Debug:

https://ibb.co/0JD9Bwm

Last edited by mecmav (2020-01-08 14:45:06)

Offline

Board footer

Powered by FluxBB