You are not logged in.
Pages: 1
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: EnabledOffline
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
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
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:
Example 2:
Error Debug:
Last edited by mecmav (2020-01-08 14:45:06)
Offline
Pages: 1