Tickets per group

[edalfa1]

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

Plugin version

1.9.0

Bug description

Hi, report "Tickets by Group" doesn´t work. I get "An unexpected error occurred". Any idea?
thank you!

Relevant log output

[2025-10-22 13:28:47] glpi.CRITICAL:   *** Uncaught PHP Exception RuntimeException: "MySQL query error: Unknown column 'glpi_groups_tickets.groups_id' in 'on clause' (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') AND `glpi_tickets`.`is_deleted` = '0' AND `glpi_tickets`.`status` = '1' AND `glpi_tickets`.`type` IN ('1', '2') AND ((`glpi_tickets`.`date` >= '2024-10-22 00:00:00') AND (`glpi_tickets`.`date` <= '2025-10-23')) GROUP BY `group_name` ORDER BY `group_name`"." at DBmysql.php line 381
  Backtrace :
  ./src/DBmysql.php:381
  ./src/DBmysqlIterator.php:123                      DBmysql->doQuery()
  ./src/DBmysql.php:1050                             DBmysqlIterator->execute()
  ...ugins/mreporting/inc/helpdeskplus.class.php:588 DBmysql->request()
  ./plugins/mreporting/inc/common.class.php:676      PluginMreportingHelpdeskplus->reportVstackbarTicketsgroups()
  ./plugins/mreporting/front/graph.php:41            PluginMreportingCommon->showGraph()
  ...Glpi/Controller/LegacyFileLoadController.php:64 require()
  ./vendor/symfony/http-kernel/HttpKernel.php:181    Glpi\Controller\LegacyFileLoadController->__invoke()
  ./vendor/symfony/http-kernel/HttpKernel.php:76     Symfony\Component\HttpKernel\HttpKernel->handleRaw()
  ./vendor/symfony/http-kernel/Kernel.php:197        Symfony\Component\HttpKernel\HttpKernel->handle()
  ./public/index.php:70                              Symfony\Component\HttpKernel\Kernel->handle()

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

[RaphaelVI]

Hello,

I do also encounter this issue