Skip to content

GLPI 11 - Error when assigning items to a ticket #21953

New issue
New issue
Open
Bug
#21983
Open
GLPI 11 - Error when assigning items to a ticket#21953
Bug
#21983
Assignees
cedric-anne
@brusilva84

Description

@brusilva84
brusilva84
opened on Nov 17, 2025

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

Version

11

Bug description

When trying to assign a item with a ticket, I get the message "Results cant be loaded"
Investigating the log file I get this error

[2025-11-17 10:32:10] glpi.CRITICAL: *** Uncaught PHP Exception RuntimeException: "MySQL query error: Unknown column 'groups_id' in 'WHERE' (1054) in SQL query "SELECT * FROM glpi_computersWHEREgroups_id IN ('38') AND ((glpi_computers.entities_id = '0' OR (glpi_computers.is_recursive= '1' ANDglpi_computers.entities_idIN ('0')))) ANDis_deleted= '0' ANDis_template= '0' ORDER BYname"." at DBmysql.php line 371 Backtrace : ./src/DBmysql.php:371 ./src/DBmysqlIterator.php:123 DBmysql->doQuery() ./src/DBmysql.php:1040 DBmysqlIterator->execute() ./src/Dropdown.php:4312 DBmysql->request() ./ajax/getDropdownMyDevices.php:42 Dropdown::getDropdownMyDevices() ...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()

The column groups_id doesn't exist in glpi_computers table

Relevant log output

[2025-11-17 10:32:10] glpi.CRITICAL:   *** Uncaught PHP Exception RuntimeException: "MySQL query error: Unknown column 'groups_id' in 'WHERE' (1054) in SQL query "SELECT * FROM `glpi_computers` WHERE `groups_id` IN ('38') AND ((`glpi_computers`.`entities_id` = '0' OR (`glpi_computers`.`is_recursive` = '1' AND `glpi_computers`.`entities_id` IN ('0')))) AND `is_deleted` = '0' AND `is_template` = '0' ORDER BY `name`"." at DBmysql.php line 371
  Backtrace :
  ./src/DBmysql.php:371
  ./src/DBmysqlIterator.php:123                      DBmysql->doQuery()
  ./src/DBmysql.php:1040                             DBmysqlIterator->execute()
  ./src/Dropdown.php:4312                            DBmysql->request()
  ./ajax/getDropdownMyDevices.php:42                 Dropdown::getDropdownMyDevices()
  ...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

  1. Open a ticket
  2. got to Items
  3. Try to add an item assigned with requester

Your GLPI setup information

GLPI information
GLPI: 11.0.2 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language: en_GB
Source Integrity: 2 files changed
  A: public/logo-GLPI-250-black.png
  A: public/toyota.pac
Server
Operating system: Linux vmlinux20-01 6.1.0-41-amd64 #​1 SMP PREEMPT_DYNAMIC Debian 6.1.158-1 (2025-11-09) x86_64

PHP: 8.2.29 apache2handler


PHP extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard, sodium,

apache2handler, mysqlnd, PDO, xml, bcmath, bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv,

igbinary, intl, ldap, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm,

tokenizer, xmlreader, xmlwriter, xsl, zip, redis, Zend OPcache


Setup: disable_functions="" max_execution_time="600" max_input_vars="1000" memory_limit="1024M" post_max_size="8M"

session.cookie_secure="1" session.cookie_httponly="1" session.cookie_samesite="" session.save_handler="files"

upload_max_filesize="2M"


Web server: Apache/2.4.65 (Debian) (Apache/2.4.65 (Debian) Server at helpdesk.mcoutinho.pt Port 443)


User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36

Edg/142.0.0.0


Database:


Server Software: Debian 12


Server Version: 10.11.14-MariaDB-0+deb12u2-log


Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


Parameters: [email protected]/glpi


Host info: 127.0.0.1 via TCP/IP


Requirements:

PHP version (8.2.29) is supported.

OS and PHP are relying on 64 bits integers.

Sessions configuration is OK.

Allocated memory is sufficient.

Following extensions are installed: dom, fileinfo, filter, libxml, simplexml, tokenizer, xmlreader,

xmlwriter.

mysqli extension is installed

curl extension is installed

gd extension is installed

intl extension is installed

mbstring extension is installed

zlib extension is installed

bcmath extension is installed

The constant

SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.

openssl extension is installed

Database engine version (10.11.14) is

supported.

The log file has been created successfully.

Write access to

/srv/glpi/files/_cache has been validated.

Write access to /srv/glpi/files/_cron has been validated.

Write access to /srv/glpi/files has been validated.

Write access to /srv/glpi/files/_graphs has been validated.

Write access to /srv/glpi/files/_lock has been validated.

Write access to /srv/glpi/files/_pictures has been validated.

Write access to /srv/glpi/files/_plugins has been validated.

Write access to /srv/glpi/files/_rss has been validated.

Write access to /srv/glpi/files/_sessions has been validated.

Write access to /srv/glpi/files/_tmp has been validated.

Write access to /srv/glpi/files/_uploads has been validated.


Sessions configuration is secured.

exif extension is installed

ldap extension is installed

Following extensions are installed: bz2,

Phar, zip.

Zend OPcache extension is installed

Following extensions are installed:

ctype, iconv, sodium.

Write access to

/var/www/html/glpi/marketplace has been validated.

Timezones seems loaded in database.
GLPI constants
GLPI_ROOT: "/var/www/html/glpi"

GLPI_VERSION: "11.0.2"

GLPI_SCHEMA_VERSION: "11.0.2@ea2dbba0e1edbf5128d73bdb23c2c9b9f68468ba"

GLPI_FILES_VERSION: "11.0.2-52505ef9"

GLPI_MIN_PHP: "8.2"

GLPI_MAX_PHP: "8.5"

GLPI_YEAR: "2025"

GLPI_I18N_DIR: "/var/www/html/glpi/locales"

GLPI_LOG_DIR: "/var/log/glpi"

GLPI_VAR_DIR: "/srv/glpi/files"

GLPI_ENVIRONMENT_TYPE: "production"

GLPI_CONFIG_DIR: "/var/www/html/glpi/config"

GLPI_MARKETPLACE_DIR: "/var/www/html/glpi/marketplace"

GLPI_ALLOW_IFRAME_IN_RICH_TEXT: false

GLPI_SERVERSIDE_URL_ALLOWLIST: ["^\n                        (http|https|feed)://

# protocol\n                        (\n                            (?:\n

(?:xn--[a-z0-9-]++\.)*+xn--[a-z0-9-]++                      # a domain name using punycode\n

|\n                                (?:[\pL\pN\pS\pM\-\]++\.)+[\pL\pN\pM]++                    # a multi-level domain

name\n                                    |\n                                [a-z0-9\-\]++

# a single-level domain name\n                            )\.?\n                                |

# or\n                            \d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}

# an IP address\n                                |                                                           #

or\n                            \[\n

(?:(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){6})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:::(?:(?:(?:[0-9a-f]{1,4})):){5})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:[0-9a-f]{1,4})))?::(?:(?:(?:[0-9a-f]{1,4})):){4})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,1}(?:(?:[0-9a-f]{1,4})))?::(?:(?:(?:[0-9a-f]{1,4})):){3})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,2}(?:(?:[0-9a-f]{1,4})))?::(?:(?:(?:[0-9a-f]{1,4})):){2})(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,3}(?:(?:[0-9a-f]{1,4})))?::(?:(?:[0-9a-f]{1,4})):)(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,4}(?:(?:[0-9a-f]{1,4})))?::)(?:(?:(?:(?:(?:[0-9a-f]{1,4})):(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9]))\.){3}(?:(?:25[0-5]|(?:[1-9]|1[0-9]|2[0-4])?[0-9])))))))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,5}(?:(?:[0-9a-f]{1,4})))?::)(?:(?:[0-9a-f]{1,4})))|(?:(?:(?:(?:(?:(?:[0-9a-f]{1,4})):){0,6}(?:(?:[0-9a-f]{1,4})))?::))))\n

\]                                                              # an IPv6 address\n

)\n                        (?:/ (?:[\pL\pN\pS\pM\-._\!$&'()+,;=:@]|%[0-9A-Fa-f]{2}) )*     # a path\n

(?:\? (?:[\pL\pN\-._\~!$&'\\+,;=:@/?]|%[0-9A-Fa-f]{2}) )?    # a query (optional)\n

$~ixuD"]

GLPI_DISALLOWED_UPLOADS_PATTERN: "/\.(php\d*|phar)$/i"

GLPI_TELEMETRY_URI: "https://telemetry.glpi-project.org"

GLPI_INSTALL_MODE: "TARBALL"

GLPI_NETWORK_MAIL: "[email protected]"

GLPI_NETWORK_SERVICES: "https://services.glpi-network.com"

GLPI_MARKETPLACE_ENABLE: 3

GLPI_MARKETPLACE_PRERELEASES: false

GLPI_MARKETPLACE_ALLOW_OVERRIDE: true

GLPI_MARKETPLACE_MANUAL_DOWNLOADS: true

GLPI_USER_AGENT_EXTRA_COMMENTS: ""

GLPI_DOCUMENTATION_ROOT_URL: "https://links.glpi-project.org"

GLPI_DISABLE_ONLY_FULL_GROUP_BY_SQL_MODE: "1"

GLPI_LOG_LVL: "warning"

GLPI_SKIP_UPDATES: false

GLPI_STRICT_ENV: false

GLPI_AJAX_DASHBOARD: "1"

GLPI_CALDAV_IMPORT_STATE: 0

GLPI_CENTRAL_WARNINGS: "1"

GLPI_SYSTEM_CRON: false

GLPI_TEXT_MAXSIZE: "4000"

GLPI_WEBHOOK_ALLOW_RESPONSE_SAVING: "0"

GLPI_WEBHOOK_CRA_MANDATORY: false

GLPI_ALTCHA_MODE: "interactive"

GLPI_ALTCHA_MAX_NUMBER: 50000

GLPI_ALTCHA_EXPIRATION_INTERVAL: "PT20M"

GLPI_DOC_DIR: "/srv/glpi/files"

GLPI_CACHE_DIR: "/srv/glpi/files/_cache"

GLPI_CRON_DIR: "/srv/glpi/files/_cron"

GLPI_GRAPH_DIR: "/srv/glpi/files/_graphs"

GLPI_LOCAL_I18N_DIR: "/srv/glpi/files/_locales"

GLPI_LOCK_DIR: "/srv/glpi/files/_lock"

GLPI_PICTURE_DIR: "/srv/glpi/files/_pictures"

GLPI_PLUGIN_DOC_DIR: "/srv/glpi/files/_plugins"

GLPI_RSS_DIR: "/srv/glpi/files/_rss"

GLPI_SESSION_DIR: "/srv/glpi/files/_sessions"

GLPI_TMP_DIR: "/srv/glpi/files/_tmp"

GLPI_UPLOAD_DIR: "/srv/glpi/files/_uploads"

GLPI_INVENTORY_DIR: "/srv/glpi/files/_inventories"

GLPI_THEMES_DIR: "/srv/glpi/files/_themes"

GLPI_PLUGINS_DIRECTORIES: ["/var/www/html/glpi/marketplace","/var/www/html/glpi/plugins"]

GLPI_NETWORK_REGISTRATION_API_URL: "https://services.glpi-network.com/api/registration/"

GLPI_MARKETPLACE_PLUGINS_API_URI: "https://services.glpi-network.com/api/marketplace/"
LDAP directories
Server: '10.1.1.212',

Port: '389',

BaseDN: 'OU=Users,OU=MCoutinho,DC=mcoutinho,DC=local',

Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',

RootDN: 'mcoutinho\ad_sync_glpi',

Use TLS: none


Server: '10.1.19.2',

Port: '389',

BaseDN: 'OU=Users,OU=MultiAuto,DC=multiauto,DC=local',

Connection filter: '(&(objectClass=user)(objectCategory=person)(!(userAccountControl:1.2.840.113556.1.4.803:=2)))',

RootDN: 'multiauto\ad_sync_glpi',

Use TLS: none
SQL replicas
Not active
Notifications
Way of sending emails: SMTP(smtp://helpdesk%40mcoutinho.pt:********@smtp.office365.com:587?verify_peer=0)

Name: '[email protected]'

Active: Yes

Server: '{outlook.office365.com/imap-oauth-1/ssl}'

Login: '[email protected]'

Password: No
Plugins list
actualtime           Name: ActualTime                     Version: 3.2.0      State: Installed / not activated

Install Method: Marketplace

advancedplanning     Name: advancedplanning               Version: 1.1.1      State: Installed / not activated

Install Method: Marketplace

behaviors            Name: Behaviours                     Version: 3.0.1      State: Enabled

Install Method: Marketplace

fields               Name: Campos adicionais              Version: 1.23.0     State: Enabled

Install Method: Marketplace

uninstall            Name: Ciclo de vida do item (desinst Version: 2.9.4      State: Installed / not activated

Install Method: Marketplace

accounts             Name: Contas                         Version: 3.0.4      State: Installed / not activated

Install Method: Marketplace

gantt                Name: gantt                          Version: 1.2.0      State: Enabled

Install Method: Marketplace

glpiinventory        Name: GLPI Inventory                 Version: 1.6.2      State: Enabled

Install Method: Marketplace

addressing           Name: IP Addressing                  Version: 3.0.3      State: Installed / not activated

Install Method: Marketplace

itremote             Name: IT Remote                      Version: 2.0        State: Installed / not activated

Install Method: Manual

mailanalyzer         Name: Mail Analyzer                  Version: 3.2.2      State: Installed / not activated

Install Method: Marketplace

mouvements           Name: Movements                      Version: 1.3.0      State: Enabled

Install Method: Manual

mydashboard          Name: O meu Painel                   Version: 2.2.2      State: Enabled

Install Method: Marketplace

oauthimap            Name: Oauth IMAP                     Version: 1.5.0      State: Enabled

Install Method: Marketplace

protocolsmanager     Name: Protocols manager              Version: 1.6.0.2    State: Enabled

Install Method: Manual

taskdrop             Name: TaskDrop                       Version: 2.1.0      State: Installed / not activated

Install Method: Marketplace

tasklists            Name: Tasks list                     Version: 2.1.1      State: Installed / not activated

Install Method: Marketplace

timelineticket       Name: Timeline of tickets            Version: 10.0+1.2   State: Installed / not activated

Install Method: Marketplace

treeview             Name: Vista em árvore                Version: 1.20.0     State: Enabled

Install Method: Marketplace

Anything else?

No response

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

Bug

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions