glpi-project / glpi

GLPI is a Free Asset and IT Management Software package, Data center management, ITIL Service Desk, licenses tracking and software auditing.
https://glpi-project.org
GNU General Public License v3.0
4.24k stars 1.29k forks source link

Incorrect KPIs compared to the GLPI filter #8955

Closed phamorais closed 3 years ago

phamorais commented 3 years ago

When upgrading to version 9.5.4 and using Mini Dashboards, incorrect results are displayed

Example below:

1 ticket with "Pending" status is shown but 8 is shown in the list.

image

2 Same behavior with "Closed Tickets" status

image

In version 9.5.3 was all fine.

System Operating system: Linux atendimento.nextflow.com.br 3.10.0-1160.21.1.el7.x86_64 #1 SMP Tue Mar 16 18:28:22 UTC 2021 x86_64 PHP 7.4.16 fpm-fcgi (Core, PDO, PDO_ODBC, Phar, Reflection, SPL, SimpleXML, Zend OPcache, apcu, bcmath, bz2, calendar, cgi-fcgi, ctype, curl, date, dba, dom, enchant, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, ionCube Loader, json, ldap, libxml, mbstring, mysqli, mysqlnd, odbc, openssl, pcntl, pcre, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, posix, pspell, session, shmop, soap, sockets, sodium, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib) Setup: max_execution_time="600" memory_limit="512M" post_max_size="8M" safe_mode="" session.save_handler="files" upload_max_filesize="8M" Software: Apache () Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/89.0.4389.114 Safari/537.36 Server Software: MariaDB Server Server Version: 10.3.28-MariaDB Server SQL Mode: Parameters: user_glpi@localhost/glpi Host info: Localhost via UNIX socket

PHP version is at least 7.2.0 - Perfect!PHP version is at least 7.2.0 - Perfect! Sessions support is available - Perfect!Sessions support is available - Perfect! Allocated memory > 64 Mio - Perfect!Allocated memory > 64 Mio - Perfect! mysqli extension is installedmysqli extension is installed ctype extension is installedctype extension is installed fileinfo extension is installedfileinfo extension is installed json extension is installedjson extension is installed mbstring extension is installedmbstring extension is installed iconv extension is installediconv extension is installed zlib extension is installedzlib extension is installed curl extension is installedcurl extension is installed gd extension is installedgd extension is installed simplexml extension is installedsimplexml extension is installed intl extension is installedintl extension is installed ldap extension is installedldap extension is installed apcu extension is installedapcu extension is installed Zend OPcache extension is installedZend OPcache extension is installed xmlrpc extension is installedxmlrpc extension is installed CAS extension is not presentCAS extension is not present exif extension is installedexif extension is installed zip extension is installedzip extension is installed bz2 extension is installedbz2 extension is installed sodium extension is installedsodium extension is installed Database version seems correct (10.3.28) - Perfect!Database version seems correct (10.3.28) - Perfect! Access to timezone database (mysql) is not allowed.Access to timezone database (mysql) is not allowed.

phamorais commented 3 years ago

After update to 9.5.5 the issue its resolved!