Forum GLPI-Project

ec2311

Member

Registered: 2016-04-07

Posts: 309

[Mreporting 1.8.5] Memory capacity of 8388608 bytes for 'range_optimiz

Bonjour

warnings lors de l'execution de la requete sql

...
                        OR (NOT `glpi_users`.`phone2` = ''
                        AND `glpi_users`.`phone2` IS NOT NULL)
                        OR (NOT `glpi_users`.`mobile` = ''
                        AND `glpi_users`.`mobile` IS NOT NULL))
                        ORDER BY `realname`, `firstname` ASC
  Warnings:
3170: Memory capacity of 8388608 bytes for 'range_optimizer_max_mem_size' exceeded. Range optimization was not done for this query.
  Backtrace :
  plugins\mydashboard\inc\helper.class.php:2032     
  ...mydashboard\reports\reports_table.class.php:171 PluginMydashboardHelper::getWidgetsFromDBQuery()
  plugins\mydashboard\inc\widget.class.php:328       PluginMydashboardReports_Table->getWidgetContentForItem()
  plugins\mydashboard\inc\widget.class.php:276       PluginMydashboardWidget::loadWidget()
  plugins\mydashboard\ajax\refreshWidget.php:46      PluginMydashboardWidget::getWidget()

Recupération des users_id (nombreux) issus de la requete 147 à 155 de reports_table.php

---

GLPI 10.0.10
GLPIinventory 1.3.4

Agents : FI (2.6, 2.5) et Glpiagents (1.7)