Error displaying the graph #337
Description
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