Error displaying the graph #337

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

When displaying the "quantitative by group" graph, we encounter the red glpi message "An error has occurred". With the debug method, we have this message which appears

"MySQL query error: Unknown column 'glpi_groups_tickets.groups_id' in 'ON' (1054) in SQL query "SELECT COUNT(*) AS nb, glpi_groups.completename AS group_name FROM glpi_tickets LEFT JOIN glpi_groups_tickets AS gt ON (gt.tickets_id = glpi_tickets.id AND gt.type = '2') LEFT JOIN glpi_groups ON ​​(glpi_groups.id = glpi_groups_tickets.groups_id) WHERE glpi_tickets.entities_id IN ('0', '10', '6', '11', '5', '4', '7', '3', '8', '9', '1', '2') AND glpi_tickets.is_deleted = '0' AND glpi_tickets.status = '1' AND glpi_tickets.type IN ('1', '2') AND ((glpi_tickets.date >= '2025-01-01 00:00:00') AND (glpi_tickets.date <= '2025-05-22')) GROUP BY group_name ORDER BY group_name".
In ./src/DBmysql.php(392)
#0 ./src/DBmysqlIterator.php(125): DBmysql->doQuery()
#1 ./src/DBmysql.php(1061): DBmysqlIterator->execute()
#2./marketplace/mreporting/inc/helpdeskplus.class.php(588): DBmysql->request()
#3./marketplace/mreporting/inc/common.class.php(676): PluginMreportingHelpdeskplus->reportVstackbarTicketsgroups()
#4./marketplace/mreporting/front/graph.php(41): PluginMreportingCommon->showGraph()
#5 ./src/Glpi/Controller/LegacyFileLoadController.php(64): require('...')
#6./vendor/symfony/http-kernel/HttpKernel.php(181): Glpi\Controller\LegacyFileLoadController->__invoke()
#7 ./vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 ./vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 ./public/index.php(70): Symfony\Component\HttpKernel\Kernel->handle()
#10 {hand}

Relevant log output

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

Operating system: Linux SRV-GLP-04 6.12.57+deb13-amd64 #​1 SMP PREEMPT_DYNAMIC Debian 6.12.57-1 (2025-11-05) x86_64

PHP: 8.4.16 fpm-fcgi

PHP extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard, sodium,
cgi-fcgi, 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

Anything else?

No response