1.8.8 - Error opening report

[andrepetinga]

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

10.0.18

Plugin version

1.8.8

Bug description

When I open the "BackLog" report, it won't return any results if I choose any "Group in charge of the ticket".
Activating the debug mode, it shows several errors:

Relevant log output

[2025-08-29 14:48:49] glpisqllog.ERROR: DBmysql::doQuery() in /glpi/src/DBmysql.php line 395
  *** MySQL query error:
  SQL: SELECT COUNT(*) AS nb, DATE_FORMAT(list_date.period_l, '%y%m%d') as period, DATE_FORMAT(list_date.period_l, '%d %b') as period_name FROM (SELECT DISTINCT `period_l` FROM ((SELECT DISTINCT DATE_FORMAT(`date`, '%Y-%m-%d 23:59:59') as period_l FROM `glpi_tickets`) UNION ALL (SELECT DISTINCT DATE_FORMAT(`solvedate`, '%Y-%m-%d 23:59:59') as period_l FROM `glpi_tickets`)) AS `list_date_union`) AS `list_date` LEFT JOIN `glpi_tickets` ON (((glpi_tickets.solvedate > list_date.period_l) OR glpi_tickets.solvedate IS NULL OR `glpi_tickets`.`date` <= 'list_date.period_l')) 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` ON (`glpi_groups_tickets`.`tickets_id` = `glpi_tickets`.`id` AND `glpi_groups_tickets`.`type` = '1') WHERE `glpi_tickets`.`entities_id` IN ('1') AND `glpi_tickets`.`is_deleted` = '0' AND DATE_FORMAT(list_date.period_l, '%y%m%d') >= '250101' AND DATE_FORMAT(list_date.period_l, '%y%m%d') <= '250815' AND `glpi_tickets`.`type` = '2' AND `glpi_groups_tickets`.`groups_id` IN ('32') GROUP BY `period`
  Error: Incorrect TIMESTAMP value: 'list_date.period_l'
  Backtrace :
  src/DBmysqlIterator.php:112                        DBmysql->doQuery()
  src/DBmysql.php:1105                               DBmysqlIterator->execute()
  plugins/mreporting/inc/helpdeskplus.class.php:382  DBmysql->request()
  plugins/mreporting/inc/common.class.php:670        PluginMreportingHelpdeskplus->reportGlineBacklogs()
  plugins/mreporting/front/graph.php:43              PluginMreportingCommon->showGraph()
  public/index.php:82                                require()
  {"user":"5647@suporte"}

Page URL

front/graph.php?short_classname=Helpdeskplus&f_name=reportGlineBacklogs&gtype=gline

Steps To reproduce

1. Open the report
2. Activate the Debug Mode
3. Fill the "Group in charge of the ticket" and call the report

Your GLPI setup information

No response

Anything else?

No response

[stonebuzz]

Hi @andrepetinga

can you try this -> #293

Best regards

[andrepetinga]

Hi @andrepetinga

can you try this -> #293

Best regards

Hello @stonebuzz.
Installed main.zip and applied this #295 (not 293 as you mentioned).
The previous errrors are gone, but now if I activate debug mode I see this:

And yes, in fact I have no vendor folder inside mreporting...
But on the previous folder of 1.8.7 I have that folder present.

[stonebuzz]

Can you just apply patch with latest version ? Main branch version need composer to download dependencies and get vendor folder

[andrepetinga]

Can you just apply patch with latest version ? Main branch version need composer to download dependencies and get vendor folder

So now I downloaded the 1.8.8 version and applied the #295 patch.
In this case it doesn't work. It generates new errors:

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

[andrepetinga]

Any news?

[dannyaguilargil]

Any news?

[RomainLvr]

try this one : #294