Skip to content

Backlog report "No data" #323

New issue
New issue
Closed
#330
Closed
Backlog report "No data"#323
#330
Labels
need feedback
@BadouDream

Description

@BadouDream
BadouDream
opened on Dec 8, 2025

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;
    Image
  • 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
Metadata
Metadata
Assignees
No one assigned
    Labels
    need feedback
    Type
    No type
    Projects
    No projects
    Milestone
    No milestone
    Relationships
    None yet
    Development
    No branches or pull requests
    Issue actions