Skip to content

Issue - Can't transfer items between entities #23596

@Giorgio6846

Description

@Giorgio6846

Code of Conduct

  • I agree to follow this project's Code of Conduct

Disable plugins

  • I reproduce the issue with all plugins disabled

Is there an existing issue for this?

  • I have searched the existing issues

Version

11.0.6

Bug description

GLPI returns errors when it tries to transfer items between entities.

What is expected to happen is for the item to transfer between another entity.

Relevant log output

[2026-03-24 09:07:51] glpi.CRITICAL:   *** Uncaught PHP Exception RuntimeException: "MySQL query error: Unknown column 'glpi_items_devicegenerics.name' in 'field list' (1054) in SQL query "SELECT `glpi_items_devicegenerics`.`id`, `glpi_items_devicegenerics`.`name`, `entities`.`completename` AS `entname`, `entities`.`id` AS `entID` FROM `glpi_items_devicegenerics` LEFT JOIN `glpi_entities` AS `entities` ON (`entities`.`id` = `glpi_items_devicegenerics`.`entities_id`) WHERE `glpi_items_devicegenerics`.`id` IN ('2', '3', '4', '8', '9', '10', '11') ORDER BY `entname`, `glpi_items_devicegenerics`.`name`"." at DBmysql.php line 416
  Backtrace :
  .\src\DBmysql.php:416                              
  .\src\DBmysqlIterator.php:129                      DBmysql->doQuery()
  .\src\DBmysql.php:1088                             DBmysqlIterator->execute()
  .\src\Transfer.php:3918                            DBmysql->request()
  .\front\transfer.action.php:69                     Transfer->showTransferList()
  ...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                              Symfony\Component\HttpKernel\Kernel->handle()

[2026-03-24 09:11:18] glpi.CRITICAL:   *** Uncaught PHP Exception RuntimeException: "MySQL query error: Unknown column 'glpi_items_devicegenerics.name' in 'field list' (1054) in SQL query "SELECT `glpi_items_devicegenerics`.`id`, `glpi_items_devicegenerics`.`name`, `entities`.`completename` AS `entname`, `entities`.`id` AS `entID` FROM `glpi_items_devicegenerics` LEFT JOIN `glpi_entities` AS `entities` ON (`entities`.`id` = `glpi_items_devicegenerics`.`entities_id`) WHERE `glpi_items_devicegenerics`.`id` IN ('2', '3', '4', '8', '9', '10', '11') ORDER BY `entname`, `glpi_items_devicegenerics`.`name`"." at DBmysql.php line 416
  Backtrace :
  .\src\DBmysql.php:416                              
  .\src\DBmysqlIterator.php:129                      DBmysql->doQuery()
  .\src\DBmysql.php:1088                             DBmysqlIterator->execute()
  .\src\Transfer.php:3918                            DBmysql->request()
  .\front\transfer.action.php:69                     Transfer->showTransferList()
  ...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                              Symfony\Component\HttpKernel\Kernel->handle()

Page URL

front/devices.php

Steps To reproduce

  1. Go to any component
  2. Select items
  3. Select add to transfer list
  4. Gives out error
Image Image Image Image

Your GLPI setup information

GLPI information
GLPI: 11.0.6 ( => C:\glpi)
Installation mode: TARBALL
Current language: en_US
Source Integrity: N/A
Server
Operating system: Windows NT SVRLIMGLPI 10.0 build 26100 (Windows Server 2025) AMD64

PHP: 8.5.1 cgi-fcgi

PHP extensions: Core, bcmath, calendar, ctype, date, hash, iconv, json, lexbor, uri, pcre, random, readline, Reflection, SPL, session, tokenizer, zlib, standard, filter, mysqlnd, Zend OPcache, PDO, bz2, libxml, SimpleXML, dom, xml, xmlreader, xmlwriter, cgi-fcgi, openssl, curl, mbstring, fileinfo, gd, intl, exif, mysqli, Phar, pdo_mysql, soap, xsl, zip

Setup: disable_functions="" max_execution_time="30" max_input_vars="1000" memory_limit="128M" post_max_size="8M" session.cookie_secure="0" session.cookie_httponly="1" session.cookie_samesite="" session.save_handler="files" upload_max_filesize="2M"

Web server: Microsoft-IIS/10.0 ()

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

Database:

Server Software: MySQL Community Server - GPL

Server Version: 8.0.45

Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

Parameters: glpi@localhost:3306/glpi

Host info: localhost via TCP/IP

Requirements:
PHP version (8.5.1) 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 (8.0.45) is supported.
The log file has been created successfully.
Write access to C:\glpi/files/_cache has been validated.
Write access to C:\glpi/files/_cron has been validated.
Write access to C:\glpi/files has been validated.
Write access to C:\glpi/files/_graphs has been validated.
Write access to C:\glpi/files/_lock has been validated.
Write access to C:\glpi/files/_pictures has been validated.
Write access to C:\glpi/files/_plugins has been validated.
Write access to C:\glpi/files/_rss has been validated.
Write access to C:\glpi/files/_sessions has been validated.
Write access to C:\glpi/files/_tmp has been validated.
Write access to C:\glpi/files/_uploads has been validated.

Sessions configuration is secured.
exif extension is installed
ldap extension is not present
Following extensions are installed: bz2, Phar, zip.
Zend OPcache extension is installed
Following extensions are installed: ctype, iconv.
Following extensions are not present: sodium.
Write access to C:\glpi/marketplace has been validated.
Timezones seems loaded in database.


GLPI constants

GLPI_ROOT: "C:\glpi"
GLPI_VERSION: "11.0.6"
GLPI_SCHEMA_VERSION: "11.0.6"
GLPI_FILES_VERSION: "11.0.6-15c577a4"
GLPI_MIN_PHP: "8.2"
GLPI_MAX_PHP: "8.5"
GLPI_YEAR: "2026"
GLPI_I18N_DIR: "C:\glpi/locales"
GLPI_ENVIRONMENT_TYPE: "production"
GLPI_CONFIG_DIR: "C:\glpi/config"
GLPI_VAR_DIR: "C:\glpi/files"
GLPI_MARKETPLACE_DIR: "C:\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: "glpi@teclib.com"
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: "C:\glpi/files"
GLPI_CACHE_DIR: "C:\glpi/files/_cache"
GLPI_CRON_DIR: "C:\glpi/files/_cron"
GLPI_GRAPH_DIR: "C:\glpi/files/_graphs"
GLPI_LOCAL_I18N_DIR: "C:\glpi/files/_locales"
GLPI_LOCK_DIR: "C:\glpi/files/_lock"
GLPI_LOG_DIR: "C:\glpi/files/_log"
GLPI_PICTURE_DIR: "C:\glpi/files/_pictures"
GLPI_PLUGIN_DOC_DIR: "C:\glpi/files/_plugins"
GLPI_RSS_DIR: "C:\glpi/files/_rss"
GLPI_SESSION_DIR: "C:\glpi/files/_sessions"
GLPI_TMP_DIR: "C:\glpi/files/_tmp"
GLPI_UPLOAD_DIR: "C:\glpi/files/_uploads"
GLPI_INVENTORY_DIR: "C:\glpi/files/_inventories"
GLPI_THEMES_DIR: "C:\glpi/files/_themes"
GLPI_PLUGINS_DIRECTORIES: ["C:\glpi/marketplace","C:\glpi/plugins"]
GLPI_NETWORK_API_URL: "https://services.glpi-network.com/api"
GLPI_NETWORK_REGISTRATION_API_URL: "https://services.glpi-network.com/api/registration/"
GLPI_MARKETPLACE_PLUGINS_API_URI: "https://services.glpi-network.com/api/marketplace/"

SQL replicas

Not active

Notifications

Way of sending emails: PHP

Anything else?

No response

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions