Mapping "Computers - Groups" not available in Data Injection plugin (GLPI 11.0.0)

[aviefriann]

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

GLPI Version

11.0.0

Plugin version

2.15.0

Bug description

Hello,
I found that in the Data Injection plugin version 2.15.0, when trying to import computer data, there is no mapping option for "Computers - Groups".
The only available option related to groups is "Group in Charge (Group)", which seems different from the intended field.

This makes it impossible to automatically assign computers to groups during import.

Relevant log output

MySQL query error: Unknown column 'groups_id' in 'WHERE' (1054) in SQL query "SELECT *
                    FROM `glpi_computers` WHERE 1  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'  AND `name`='SMF-202501OP006' AND `states_id`='1' AND `manufacturers_id`='55' AND `computermodels_id`='17' AND `serial`='PC04DMQD' AND `users_id`='306' AND `groups_id`='72' AND `locations_id`='1'".
In ./src/DBmysql.php(381)
#0 ./marketplace/datainjection/inc/commoninjectionlib.class.php(1949): DBmysql->doQuery()
#1 ./marketplace/datainjection/inc/commoninjectionlib.class.php(1507): PluginDatainjectionCommonInjectionLib->dataAlreadyInDB()
#2 ./marketplace/datainjection/inc/computerinjection.class.php(107): PluginDatainjectionCommonInjectionLib->processAddOrUpdate()
#3 ./marketplace/datainjection/inc/engine.class.php(156): PluginDatainjectionComputerInjection->addOrUpdateObject()
#4 ./marketplace/datainjection/inc/clientinjection.class.php(219): PluginDatainjectionEngine->injectLine()
#5 ./marketplace/datainjection/inc/clientinjection.class.php(169): PluginDatainjectionClientInjection::processInjection()
#6 ./marketplace/datainjection/front/clientinjection.form.php(43): PluginDatainjectionClientInjection::showInjectionForm()
#7 ./src/Glpi/Controller/LegacyFileLoadController.php(64): require('...')
#8 ./vendor/symfony/http-kernel/HttpKernel.php(181): Glpi\Controller\LegacyFileLoadController->__invoke()
#9 ./vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#10 ./vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#11 ./public/index.php(70): Symfony\Component\HttpKernel\Kernel->handle()
#12 {main}

Page URL

http://192.168.xxx.xxx/plugins/datainjection/front/clientinjection.form.php

Steps To reproduce

1. Go to Setup → Plugins → Data Injection
2. Create a new model for Computers
3. In the Mapping section, check the available fields
4. Notice that "Computers - Groups" is missing

Your GLPI setup information

GLPI information

GLPI: 11.0.0 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language: en_US

Server

Operating system: Linux glpi-srv-samir 6.8.0-85-generic #​85-Ubuntu SMP PREEMPT_DYNAMIC Thu Sep 18 15:26:59 UTC 2025 x86_64
PHP: 8.3.6 apache2handler
PHP extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard, sodium,

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

iconv, igbinary, imap, intl, ldap, exif, mysqli, pdo_mysql, Phar, posix, readline, redis, shmop, SimpleXML, soap, sockets,

sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlrpc, xmlwriter, xsl, zip, Zend OPcache
Setup: disable_functions="" max_execution_time="120" max_input_vars="5000" memory_limit="512M" post_max_size="25M"

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

upload_max_filesize="20M"
Web server: Apache/2.4.58 (Ubuntu) (Apache/2.4.58 (Ubuntu) Server at 192.168.3.106 Port 80)
User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36
Database:
Server Software: Ubuntu 24.04
Server Version: 10.11.13-MariaDB-0ubuntu0.24.04.1
Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Parameters: glpi_samir@localhost/glpi_samir
Host info: Localhost via UNIX socket
Requirements:

PHP version (8.3.6) 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.13) is

supported.

The log file has been created successfully.

Write access to /var/lib/glpi/_cache has been validated.

Write access to /var/lib/glpi/_cron has been validated.

Write access to /var/lib/glpi has been validated.

Write access to /var/lib/glpi/_graphs has been validated.

Write access to /var/lib/glpi/_lock has been validated.

Write access to /var/lib/glpi/_pictures has been validated.

Write access to /var/lib/glpi/_plugins has been validated.

Write access to /var/lib/glpi/_rss has been validated.

Write access to /var/lib/glpi/_sessions has been validated.

Write access to /var/lib/glpi/_tmp has been validated.

Write access to /var/lib/glpi/_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.0"

GLPI_SCHEMA_VERSION: "11.0.0@ea2dbba0e1edbf5128d73bdb23c2c9b9f68468ba"

GLPI_FILES_VERSION: "11.0.0-f682f73d"

GLPI_MIN_PHP: "8.2"

GLPI_MAX_PHP: "8.5"

GLPI_YEAR: "2025"

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

GLPI_CONFIG_DIR: "/etc/glpi/"

GLPI_VAR_DIR: "/var/lib/glpi"

GLPI_DOC_DIR: "/var/lib/glpi"

GLPI_CACHE_DIR: "/var/lib/glpi/_cache"

GLPI_CRON_DIR: "/var/lib/glpi/_cron"

GLPI_GRAPH_DIR: "/var/lib/glpi/_graphs"

GLPI_LOCAL_I18N_DIR: "/var/lib/glpi/_locales"

GLPI_LOCK_DIR: "/var/lib/glpi/_lock"

GLPI_PICTURE_DIR: "/var/lib/glpi/_pictures"

GLPI_PLUGIN_DOC_DIR: "/var/lib/glpi/_plugins"

GLPI_RSS_DIR: "/var/lib/glpi/_rss"

GLPI_SESSION_DIR: "/var/lib/glpi/_sessions"

GLPI_TMP_DIR: "/var/lib/glpi/tmp"

GLPI_UPLOAD_DIR: "/var/lib/glpi/uploads"

GLPI_INVENTORY_DIR: "/var/lib/glpi/inventories"

GLPI_THEMES_DIR: "/var/lib/glpi/themes"

GLPI_LOG_DIR: "/var/log/glpi"

GLPI_ENVIRONMENT_TYPE: "production"

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: "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_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/"

SQL Replicas

Not active

Notifications

Way of sending emails: PHP

Plugins list

fields               Name: Additional fields              Version: 1.22.0     State: Enabled

Install Method: Marketplace

datainjection        Name: Data injection                 Version: 2.15.0     State: Enabled

Install Method: Marketplace

Anything else?

Expected Behavior

There should be a mapping option for "Computers - Groups", allowing imported computers to be linked to their respective groups.

---

Actual Behavior

Only "Group in Charge (Group)" is shown in the mapping list.

[Lainow]

Hello,
The mapping Group in charge corresponds to the Group field on your computers page, as shown below:

In addition, I recommend updating the plugin to version 2.15.1. This update should resolve the issue related to the error message you are encountering.
Best regards,

[aviefriann]

I’ve updated the DataInjection plugin to the latest version (2.15.1),
but the same issue still occurs on GLPI 11.0.0

Error message:
MySQL query error: Unknown column 'groups_id' in 'WHERE' (1054)

Additional details:
After checking the plugin’s code to understand what might be happening,
it looks like the error appears during the duplicate-check step,
inside the function PluginDatainjectionCommonInjectionLib::dataAlreadyInDB() (inc/commoninjectionlib.class.php)
This function builds a SQL query dynamically based on the mapped fields,
and still includes a condition for the old column glpi_computers.groups_id, for example:

SELECT * FROM glpi_computers WHERE 1 AND is_deleted='0' AND is_template='0' AND users_id='306' AND groups_id='68' AND locations_id='1';

In GLPI 11, that column no longer exists,
since the relation between computers and groups is now stored in
the glpi_groups_items table (items_id, itemtype, groups_id).

Because of this, the duplicate check fails before the insertion happens.
If I unlink the “Group” field from the import mapping,
the import completes successfully so it seems related only to that field.

Observation / suggestion:

• Maybe the duplicate check could skip groups_id for computers, or adapt to use the new glpi_groups_items table when checking for existing records.
• I’m not entirely sure if this is the correct direction, but hopefully this information helps identify where the problem comes from.

[Lainow]

Hello,
I invite you to apply the patch from this Pull Request to your instance:
🔗 Link to PR #541
This should resolve the issue you previously reported.
Best regards,

[aviefriann]

Hello,

I have reviewed the patch code and applied the patch from PR #541.

After applying the patch manually under /var/www/html/glpi/marketplace/datainjection, the import process now runs successfully without any SQL errors

Test details:

• Import model: Computers
• Mapping fields: Name, Serial, Manufacturer, Model, User, Location, Group
• Previous result: MySQL query error: Unknown column 'groups_id'
• After patch: Import completed successfully

It seems to be stable now
Thanks again for the quick response and patch!