Error displaying the graph

[Sousou-cloud]

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

[stonebuzz]

Hi @Sousou-cloud,

Could you please try again using the latest version, 1.9.3?

It should be available on the marketplace very soon.

Best regards,

[github-actions]

There has been no activity on this issue for some time and therefore it is considered stale and will be closed automatically in 10 days.

If this issue is related to a bug, please try to reproduce on latest release. If the problem persist, feel free to add a comment to revive this issue.
If it is related to a new feature, please open a topic to discuss with community about this enhancement on suggestion website.

You may also consider taking a subscription to get professionnal support or contact GLPI editor team directly.