Skip to content

Critical error on loading ticket actors #100

@tsmr

Description

@tsmr

Code of Conduct

  • [ X] 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

Last

Plugin version

Last

Bug description

[2026-03-31 19:30:23] glpi.CRITICAL: *** Uncaught PHP Exception RuntimeException: "MySQL query error: Champ 'MIN(level)' inconnu dans field list (1054) in SQL query "SELECT MIN(level) AS level FROM glpi_plugin_itilcategorygroups_categories_groups WHERE itilcategories_id = '233'"." at DBmysql.php line 416
Backtrace :
.\src\DBmysql.php:416
.\src\DBmysqlIterator.php:129 DBmysql->doQuery()
.\src\DBmysql.php:1088 DBmysqlIterator->execute()
...e\itilcategorygroups\inc\category.class.php:468 DBmysql->request()
...e\itilcategorygroups\inc\category.class.php:311 PluginItilcategorygroupsCategory::getFirst()
.\src\Plugin.php:1863 PluginItilcategorygroupsCategory::filterActors()
.\src\Dropdown.php:5106 Plugin::doHookFunction()
.\ajax\actors.php:41 Dropdown::getDropdownActors()
...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:208 Symfony\Component\HttpKernel\HttpKernel->handle()
.\public\index.php:71

'SELECT' => 'MIN(level) as level',

Must be replaced by

'SELECT' => ['MIN' => 'level AS level'],

Relevant log output

Page URL

No response

Steps To reproduce

No response

Your GLPI setup information

No response

Anything else?

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions