I'm using GLPI 10.0.5 and I'm receiving the following error when attempting to generate the "Printers" report:
PHP error log:
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 363
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 367
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: DBmysql::query(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 372
[06-Dec-2022 17:11:00 America/Sao_Paulo] PHP Warning: DBmysql::fetchQueryWarnings(): Couldn't fetch mysqli in /home/robertinho/public_html/glpi/src/DBmysql.php on line 1913
[2022-12-06 17:11:00] glpisqllog.ERROR: DBmysql::query() in /home/robertinho/public_html/glpi/src/DBmysql.php line 370
*** MySQL query error:
SQL: SELECT COUNT(*) AS count FROM `glpi_users` LEFT JOIN `glpi_profiles_users` ON (`glpi_profiles_users`.`users_id` = `glpi_users`.`id`) WHERE `glpi_users`.`id` = '14' AND `glpi_users`.`is_active` = '1' AND `glpi_users`.`is_deleted` = '0' AND `glpi_profiles_users`.`profiles_id` = '4' AND (`glpi_profiles_users`.`entities_id` = '0')
Error:
Backtrace :
src/DBmysqlIterator.php:112
src/DBmysql.php:1056 DBmysqlIterator->execute()
src/Session.php:903 DBmysql->request()
src/Session.php:1022 Session::checkValidSessionId()
plugins/reports/inc/autoreport.class.php:304 Session::checkRight()
plugins/reports/report/printers/printers.php:129 PluginReportsAutoReport->execute()
{"user":"14@cloud.ifantasy.com.br"}
When I'd run the query through PHPMyAdmin it runs successfully, so I believe that the SELECT COUNT query isn't allowed through the DBmysqlIterator or maybe some problem related to the entities permission (#18)?
I'm using GLPI 10.0.5 and I'm receiving the following error when attempting to generate the "Printers" report:
PHP error log:
php-errors.log
:sql-errors.log
:When I'd run the query through PHPMyAdmin it runs successfully, so I believe that the
SELECT COUNT
query isn't allowed through theDBmysqlIterator
or maybe some problem related to the entities permission (#18)?