Skip to content

Number of calls by category and entity GLPI 11 #342

New issue
New issue
Open
Open
Number of calls by category and entity GLPI 11#342
@whamulti

Description

@whamulti
whamulti
opened on Feb 3, 2026

Code of Conduct

  • I agree to follow this project's Code of Conduct

Is there an existing issue for this?

  • I have searched the existing issues

GLPI Version

11.0.4

Plugin version

1.9.3

Bug description

Hello, when I click on the item "Number of calls by category and entity", an error message appears.

Relevant log output

Empty IN are not allowed
In ./src/DBmysqlIterator.php(612)
#0 ./src/DBmysqlIterator.php(578): DBmysqlIterator->analyseCriterion()
#1 ./src/DBmysqlIterator.php(309): DBmysqlIterator->analyseCrit()
#2 ./src/DBmysqlIterator.php(124): DBmysqlIterator->buildQuery()
#3 ./src/DBmysql.php(1061): DBmysqlIterator->execute()
#4 /var/lib/glpi/plugins/mreporting/inc/helpdesk.class.php(198): DBmysql->request()
#5 /var/lib/glpi/plugins/mreporting/inc/common.class.php(676): PluginMreportingHelpdesk->reportHgbarTicketNumberByCatAndEntity()
#6 /var/lib/glpi/plugins/mreporting/front/graph.php(41): PluginMreportingCommon->showGraph()
#7 ./src/Glpi/Controller/LegacyFileLoadController.php(64): require('...')
#8 ./vendor/symfony/http-kernel/HttpKernel.php(181): Glpi\Controller\LegacyFileLoadController->__invoke()
#9 ./vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#10 ./vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#11 ./public/index.php(70): Symfony\Component\HttpKernel\Kernel->handle()
#12 {main}

Page URL

plugins/mreporting/front/graph.php?short_classname=Helpdesk&f_name=reportHgbarTicketNumberByCatAndEntity&gtype=hgbar

Steps To reproduce

  1. Tools
  2. More Reporting
  3. Number of ticket per category and entity

Your GLPI setup information

GLPI information
GLPI: 11.0.4 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language: pt_BR
Source Integrity: N/A
Server
Operating system: Linux glpi 6.1.0-41-amd64 #​1 SMP PREEMPT_DYNAMIC Debian 6.1.158-1 (2025-11-09) x86_64

PHP: 8.2.29 apache2handler


PHP extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard, sodium,

apache2handler, mysqlnd, PDO, xml, apcu, bcmath, bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext,

iconv, intl, ldap, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm,

tokenizer, xmlreader, xmlwriter, xsl, zip, Zend OPcache


Setup: disable_functions="" max_execution_time="600" max_input_vars="1000" memory_limit="256M" post_max_size="100M"

session.cookie_secure="0" session.cookie_httponly="1" session.cookie_samesite="" session.save_handler="files"

upload_max_filesize="100M"


Web server: Apache/2.4.65 (Debian) (Apache/2.4.65 (Debian) Server at 10.2.17.26 Port 80)


User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/144.0.0.0 Safari/537.36

Edg/144.0.0.0


Database:


Server Software: Debian 12


Server Version: 10.11.14-MariaDB-0+deb12u2


Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


Parameters: glpiuser@localhost/glpidb


Host info: Localhost via UNIX socket


Requirements:

PHP version (8.2.29) is supported.

OS and PHP are relying on 64 bits integers.

Sessions configuration is OK.

Allocated memory is sufficient.

Following extensions are installed: dom, fileinfo, filter, libxml, simplexml, tokenizer, xmlreader,

xmlwriter.

mysqli extension is installed

curl extension is installed

gd extension is installed

intl extension is installed

mbstring extension is installed

zlib extension is installed

bcmath extension is installed

The constant

SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.

openssl extension is installed

Database engine version (10.11.14) is

supported.

The log file has been created successfully.

Write access

to /var/lib/glpi/files/_cache has been validated.

Write access to /var/lib/glpi/files/_cron has been validated.

Write access to /var/lib/glpi/files has been validated.

Write access to /var/lib/glpi/files/_graphs has been validated.

Write access to /var/lib/glpi/files/_lock has been validated.

Write access to /var/lib/glpi/files/_pictures has been validated.

Write access to /var/lib/glpi/files/_plugins has been validated.

Write access to /var/lib/glpi/files/_rss has been validated.

Write access to /var/lib/glpi/files/_sessions has been validated.

Write access to /var/lib/glpi/files/_tmp has been validated.

Write access to /var/lib/glpi/files/_uploads has been validated.


Sessions configuration is secured.

exif extension is installed

ldap extension is installed

Following extensions are installed: bz2,

Phar, zip.

Zend OPcache extension is installed

Following extensions are installed:

ctype, iconv, sodium.

Write access to

/var/lib/glpi/plugins has been validated.

Timezones seems loaded in database.
GLPI constants
GLPI_ROOT: "/var/www/html/glpi"

GLPI_VERSION: "11.0.4"

GLPI_SCHEMA_VERSION: "11.0.4"

GLPI_FILES_VERSION: "11.0.4-1d4fbe9a"

GLPI_MIN_PHP: "8.2"

GLPI_MAX_PHP: "8.5"

GLPI_YEAR: "2025"

GLPI_I18N_DIR: "/var/www/html/glpi/locales"

GLPI_CONFIG_DIR: "/etc/glpi/"

GLPI_VAR_DIR: "/var/lib/glpi/files"

GLPI_LOG_DIR: "/var/log/glpi"

GLPI_MARKETPLACE_DIR: "/var/lib/glpi/plugins"

GLPI_ENVIRONMENT_TYPE: "production"

GLPI_ALLOW_IFRAME_IN_RICH_TEXT: false

GLPI_SERVERSIDE_URL_ALLOWLIST: ["^\n                        (http|https|feed)://

# protocol\n                        (\n                            (?:\n

(?:xn--[a-z0-9-]++\.)*+xn--[a-z0-9-]++                      # a domain name using punycode\n

|\n                                (?:[\pL\pN\pS\pM\-\]++\.)+[\pL\pN\pM]++                    # a multi-level domain

name\n                                    |\n                                [a-z0-9\-\]++

# a single-level domain name\n                            )\.?\n                                |

# or\n                            \d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}

# an IP address\n                                |                                                           #

or\n                            \[\n

(?:(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){6})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:::(?:(?:(?:[0-9a-f]{1,4})):){5})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:[0-9a-f]{1,4})))?::(?:(?:(?:[0-9a-f]{1,4})):){4})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,1}(?:(?:[0-9a-f]{1,4})))?::(?:(?:(?:[0-9a-f]{1,4})):){3})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,2}(?:(?:[0-9a-f]{1,4})))?::(?:(?:(?:[0-9a-f]{1,4})):){2})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,3}(?:(?:[0-9a-f]{1,4})))?::(?:(?:[0-9a-f]{1,4})):)(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,4}(?:(?:[0-9a-f]{1,4})))?::)(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,5}(?:(?:[0-9a-f]{1,4})))?::)(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,6}(?:(?:[0-9a-f]{1,4})))?::))))\n

\]                                                              # an IPv6 address\n

)\n                        (?:/ (?:[\pL\pN\pS\pM\-._\!$&'()+,;=:@]|%[0-9A-Fa-f]{2}) )*     # a path\n

(?:\? (?:[\pL\pN\-._\~!$&'\\+,;=:@/?]|%[0-9A-Fa-f]{2}) )?    # a query (optional)\n

$~ixuD"]

GLPI_DISALLOWED_UPLOADS_PATTERN: "/\.(php\d*|phar)$/i"

GLPI_TELEMETRY_URI: "https://telemetry.glpi-project.org"

GLPI_INSTALL_MODE: "TARBALL"

GLPI_NETWORK_MAIL: "glpi@teclib.com"

GLPI_NETWORK_SERVICES: "https://services.glpi-network.com"

GLPI_MARKETPLACE_ENABLE: 3

GLPI_MARKETPLACE_PRERELEASES: false

GLPI_MARKETPLACE_ALLOW_OVERRIDE: true

GLPI_MARKETPLACE_MANUAL_DOWNLOADS: true

GLPI_USER_AGENT_EXTRA_COMMENTS: ""

GLPI_DOCUMENTATION_ROOT_URL: "https://links.glpi-project.org"

GLPI_DISABLE_ONLY_FULL_GROUP_BY_SQL_MODE: "1"

GLPI_LOG_LVL: "warning"

GLPI_SKIP_UPDATES: false

GLPI_STRICT_ENV: false

GLPI_AJAX_DASHBOARD: "1"

GLPI_CALDAV_IMPORT_STATE: 0

GLPI_CENTRAL_WARNINGS: "1"

GLPI_SYSTEM_CRON: false

GLPI_TEXT_MAXSIZE: "4000"

GLPI_WEBHOOK_ALLOW_RESPONSE_SAVING: "0"

GLPI_WEBHOOK_CRA_MANDATORY: false

GLPI_ALTCHA_MODE: "interactive"

GLPI_ALTCHA_MAX_NUMBER: 50000

GLPI_ALTCHA_EXPIRATION_INTERVAL: "PT20M"

GLPI_DOC_DIR: "/var/lib/glpi/files"

GLPI_CACHE_DIR: "/var/lib/glpi/files/_cache"

GLPI_CRON_DIR: "/var/lib/glpi/files/_cron"

GLPI_GRAPH_DIR: "/var/lib/glpi/files/_graphs"

GLPI_LOCAL_I18N_DIR: "/var/lib/glpi/files/_locales"

GLPI_LOCK_DIR: "/var/lib/glpi/files/_lock"

GLPI_PICTURE_DIR: "/var/lib/glpi/files/_pictures"

GLPI_PLUGIN_DOC_DIR: "/var/lib/glpi/files/_plugins"

GLPI_RSS_DIR: "/var/lib/glpi/files/_rss"

GLPI_SESSION_DIR: "/var/lib/glpi/files/_sessions"

GLPI_TMP_DIR: "/var/lib/glpi/files/_tmp"

GLPI_UPLOAD_DIR: "/var/lib/glpi/files/_uploads"

GLPI_INVENTORY_DIR: "/var/lib/glpi/files/_inventories"

GLPI_THEMES_DIR: "/var/lib/glpi/files/_themes"

GLPI_PLUGINS_DIRECTORIES: ["/var/lib/glpi/plugins","/var/www/html/glpi/plugins"]

GLPI_NETWORK_API_URL: "https://services.glpi-network.com/api"

GLPI_NETWORK_REGISTRATION_API_URL: "https://services.glpi-network.com/api/registration/"

GLPI_MARKETPLACE_PLUGINS_API_URI: "https://services.glpi-network.com/api/marketplace/"
Réplicas SQL
Not active
Notifications
Way of sending emails: SMTP(smtp://outlook.pensomail.com.br:25?verify_peer=0)
Plugins list
mreporting           Name: More Reporting                 Version: 1.9.3      State: Habilitado

Install Method: Marketplace

ocsinventoryng       Name: OCS Inventory NG               Version: 2.1.8      State: Habilitado

Install Method: Marketplace
OCS Inventory NG
Host: 10.2.17.22<br>Conexão: Ok<br>Usar o dicionário de softwares do OCSNG: No

Image
Image

Anything else?

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions