Backlog report "No data"

[BadouDream]

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.2

Bug description

Hi,
All reports some functional but Backlog reports display "No Data" since we are in GLPI v11. In some cases Backlog is functionnal (can't explain when). But with debug mode I see changes in SQL requests :

• When functional (return row = 13) : SELECT COUNT(*) AS nb, DATE_FORMAT(glpi_tickets.date, '%y%m') as period, DATE_FORMAT(glpi_tickets.date, '%b %Y') as period_name FROM glpi_tickets LEFT JOIN glpi_tickets_users ON (glpi_tickets_users.tickets_id = glpi_tickets.id AND glpi_tickets_users.type = '2') LEFT JOIN glpi_groups_tickets AS gt ON (gt.tickets_id = glpi_tickets.id AND gt.type = '2') LEFT JOIN glpi_groups_tickets AS gtr ON (gtr.tickets_id = glpi_tickets.id AND gtr.type = '1') WHERE glpi_tickets.entities_id IN ('0', '1') AND glpi_tickets.is_deleted = '0' AND glpi_tickets.type IN ('1', '2') AND ((glpi_tickets.date >= '2024-12-08 00:00:00') AND (glpi_tickets.date <= '2025-12-09')) GROUP BY period ORDER BY period;
  
• When not functional (return row = 0) : SELECT COUNT(*) AS nb, DATE_FORMAT(glpi_tickets.date, '%y%m') as period, DATE_FORMAT(glpi_tickets.date, '%b %Y') as period_name FROM glpi_tickets LEFT JOIN glpi_tickets_users ON (glpi_tickets_users.tickets_id = glpi_tickets.id AND glpi_tickets_users.type = '2') LEFT JOIN glpi_groups_tickets AS gt ON (gt.tickets_id = glpi_tickets.id AND gt.type = '2') LEFT JOIN glpi_groups_tickets AS gtr ON (gtr.tickets_id = glpi_tickets.id AND gtr.type = '1') WHERE glpi_tickets.entities_id IN ('0') AND glpi_tickets.is_deleted = '0' AND glpi_tickets.type IN ('1', '2') AND gt.groups_id = '' AND gtr.groups_id = '' AND ((glpi_tickets.date >= '2024-12-08 00:00:00') AND (glpi_tickets.date <= '2025-12-09')) GROUP BY period ORDER BY period

Changing between the two request is "AND gt.groups_id = '' AND gtr.groups_id = ''". Tested with mysql in command line and same comportment that describe above.

Thanks for your help.

Relevant log output

Page URL

https://glpi.domain.local/plugins/mreporting/front/graph.php?short_classname=Helpdeskplus&f_name=reportGlineBacklogs&gtype=gline

Steps To reproduce

No response

Your GLPI setup information

GLPI information

GLPI: 11.0.4 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language: fr_FR
Source Integrity: 1 files changed
  A: inc/downstream.php

Server

Operating system: Linux Infra-Tools.codra.local 5.14.0-570.55.1.el9_6.x86_64 #​1 SMP PREEMPT_DYNAMIC Fri Oct 24 10:42:20 UTC 2025
x86_64
PHP: 8.2.29 fpm-fcgi
PHP extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard,

cgi-fcgi, bcmath, bz2, calendar, ctype, curl, dom, mbstring, fileinfo, ftp, gd, gettext, iconv, imap, intl, ldap, exif, mysqlnd,

PDO, Phar, posix, shmop, SimpleXML, soap, sockets, sodium, sqlite3, sysvmsg, sysvsem, sysvshm, tokenizer, xml, xmlwriter, xsl,

mysqli, pdo_mysql, pdo_sqlite, xmlreader, xmlrpc, zip, apcu, Zend OPcache
Setup: disable_functions="" max_execution_time="300" max_input_vars="1000" memory_limit="256M" post_max_size="1000M"

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

upload_max_filesize="1000M"
Web server: Apache/2.4.62 (Rocky Linux) OpenSSL/3.2.2 mod_auth_gssapi/1.6.3 mod_perl/2.0.12 Perl/v5.32.1 ()
User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36
Database:
Server Software: MariaDB Server
Server Version: 10.11.10-MariaDB
Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Parameters: GLPI@127.0.0.1/glpidb
Host info: 127.0.0.1 via TCP/IP
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.10) is

supported.

The log file has been created successfully.

Write access to

/data/httpd/glpi/_cache has been validated.

Write access to /data/httpd/glpi/_cron has been validated.

Write access to /data/httpd/glpi has been validated.

Write access to /data/httpd/glpi/_graphs has been validated.

Write access to /data/httpd/glpi/_lock has been validated.

Write access to /data/httpd/glpi/_pictures has been validated.

Write access to /data/httpd/glpi/_plugins has been validated.

Write access to /data/httpd/glpi/_rss has been validated.

Write access to /data/httpd/glpi/_sessions has been validated.

Write access to /data/httpd/glpi/_tmp has been validated.

Write access to /data/httpd/glpi/_uploads has been validated.

SELinux configuration is OK.
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/www/html/glpi/marketplace 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@9065df1ff6b8ff1d77b519d1c4856507d18258b0"

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: "/data/httpd/glpi"

GLPI_LOG_DIR: "/var/log/glpi"

GLPI_ENVIRONMENT_TYPE: "production"

GLPI_MARKETPLACE_DIR: "/var/www/html/glpi/marketplace"

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: "/data/httpd/glpi"

GLPI_CACHE_DIR: "/data/httpd/glpi/_cache"

GLPI_CRON_DIR: "/data/httpd/glpi/_cron"

GLPI_GRAPH_DIR: "/data/httpd/glpi/_graphs"

GLPI_LOCAL_I18N_DIR: "/data/httpd/glpi/_locales"

GLPI_LOCK_DIR: "/data/httpd/glpi/_lock"

GLPI_PICTURE_DIR: "/data/httpd/glpi/_pictures"

GLPI_PLUGIN_DOC_DIR: "/data/httpd/glpi/_plugins"

GLPI_RSS_DIR: "/data/httpd/glpi/_rss"

GLPI_SESSION_DIR: "/data/httpd/glpi/_sessions"

GLPI_TMP_DIR: "/data/httpd/glpi/_tmp"

GLPI_UPLOAD_DIR: "/data/httpd/glpi/_uploads"

GLPI_INVENTORY_DIR: "/data/httpd/glpi/_inventories"

GLPI_THEMES_DIR: "/data/httpd/glpi/_themes"

GLPI_PLUGINS_DIRECTORIES: ["/var/www/html/glpi/marketplace","/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/"

Annuaires LDAP

Server: 'ldaps://infra-dc1.codra.local',

Port: '636',

BaseDN: 'OU=CODRA,DC=CODRA,DC=Local',

Connection filter:

'(&(objectClass=user)(objectCategory=person)(memberOf=CN=GLPI-Utilisateurs,OU=GLPI,OU=Applications,OU=Utilisateurs-Groupes de

services,OU=CODRA,DC=CODRA,DC=LOCAL)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',

RootDN: 'LDAP_AD_Access@codra.local',

Use TLS: none

Server: 'codra.local',

Port: '389',

BaseDN: 'OU=CODRA,DC=CODRA,DC=Local',

Connection filter:

'(&(objectClass=user)(objectCategory=person)(memberOf=CN=GLPI-Utilisateurs,OU=GLPI,OU=Applications,OU=Utilisateurs-Groupes de

services,OU=CODRA,DC=CODRA,DC=LOCAL)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',

RootDN: 'LDAP_AD_Access@codra.local',

Use TLS: none

Réplicats SQL

Not active

Notifications

Way of sending emails: SMTP(smtp://smtp.infrastructure%40codra.local:********@smtp-infra.codra.local:587?verify_peer=0)

Name: 'GLPI@codra.local'

Active: Yes

Server: '{infra-mails2016.codra.local:993/imap/ssl/novalidate-cert/notls}INBOX'

Login: 'GLPI@codra.local'

Password: Yes

Plugins list

fields               Name: Champs supplémentaires         Version: 1.23.1     State: Activé

Install Method: Marketplace

formcreator          Name: Form Creator                   Version: 3.0.1      State: Erreur / à nettoyer

Install Method: Manual

mreporting           Name: More Reporting                 Version: 1.9.2      State: Activé

Install Method: Marketplace

ocsinventoryng       Name: OCS Inventory NG               Version: 2.1.3      State: Erreur / à nettoyer

Install Method: Manual

taskdrop             Name: TaskDrop                       Version: 2.1.0      State: Erreur / à nettoyer

Install Method: Manual

Anything else?

No response

[sylvainblanchouin]

Hi,

Same error here, also GLPI 11.0.4 and mreporting 1.9.2

I follow for solution 😉

[stonebuzz]

Hi @BadouDream @sylvainblanchouin

can you try this -> #330

Best regards

[BadouDream]

Hi,

Thanks it's Ok for us.

Many thanks

[sylvainblanchouin]

Hi,

It's OK for us too.

Thank you !