Skip to content

Errors when trying to update Plugins fields. Custom objects fields are not migrating successfully. #1061

New issue
New issue
Closed
Closed
Errors when trying to update Plugins fields. Custom objects fields are not migrating successfully.#1061
@oraki23

Description

@oraki23
oraki23
opened on Oct 27, 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

GLPI Version

11.0.1

Plugin version

1.22.2

Bug description

Hi,

I have been trying to migrate on my pre-production to GLPI 11, but I'm stuck since the migration of custom fields data of custom objects are not migrating properly.

Here are the steps I'm doing:

  • Migrate from GLPI 10 to 11
  • Update the files of the plugin Generic Object to 3.0.0
  • Update the files of the plugin Fields to 1.22.2
  • Run the command php /var/www/html/glpi/bin/console glpi:plugin:install genericobject
  • Run the command php /var/www/html/glpi/bin/console glpi:plugin:activate genericobject (even if I activate it later it does the same problem)
  • Run the command php /var/www/html/glpi/bin/console migration:genericobject_plugin_to_core
  • Run the command php /var/www/html/glpi/bin/console glpi:plugin:install fields

Once I run this command, I'm getting the following output:

Traitement du plugin "fields"...
MySQL tables installation

In DBmysql.php line 371:
                                                                                                                                                                                        
  MySQL query error: Unknown column 'glpi_plugin_fields_containers.itemtypes' in 'WHERE' (1054) in SQL query "SELECT * FROM `glpi_plugin_genericobject_types` WHERE glpi_plugin_fields  
  _containers.itemtypes LIKE '%PluginGenericobject%'".

Here is a screenshot of relevant tables:
glpi_plugin_fields_containers
Image

glpi_plugin_genericobject_types
Image

All my fields table after the GenericObject migration (But install of fields is failing)

Image

Please let me know if you need more informations !

Relevant log output



Page URL


No response


Steps To reproduce


    

  • Migrate from GLPI 10 to 11
    • 

  • Update the files of the plugin Generic Object to 3.0.0
    • 

  • Update the files of the plugin Fields to 1.22.2
    • 

  • Run the command php /var/www/html/glpi/bin/console glpi:plugin:install genericobject
    • 

  • Run the command php /var/www/html/glpi/bin/console glpi:plugin:activate genericobject (even if I activate it later it does the same problem)
    • 

  • Run the command php /var/www/html/glpi/bin/console migration:genericobject_plugin_to_core
    • 

  • Run the command php /var/www/html/glpi/bin/console glpi:plugin:install fields
    • 



Your GLPI setup information


GLPI information
GLPI: 11.0.1 ( => /var/www/html/glpi)
Installation mode: TARBALL
Current language: fr_CA
Source Integrity: OK
Server
Operating system: Linux 1355e4339a3e 6.12.5-linuxkit #​1 SMP Tue Jan 21 10:23:32 UTC 2025 x86_64

PHP: 8.3.14 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, imap, intl, ldap, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem,

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


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: Apache/2.4.62 (Debian) (Apache/2.4.62 (Debian) Server at services.localhost Port 80)


User agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0

Safari/537.36


Database:


Server Software: mariadb.org binary distribution


Server Version: 12.0.2-MariaDB-ubu2404


Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION


Parameters: glpi_admin@mariadb/glpidb


Host info: mariadb via TCP/IP


Requirements:

PHP version (8.3.14) 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 (12.0.2) is supported.

The log file has been created successfully.

Write access to /var/www/html/glpi/files/_cache has been validated.

Write access to /var/www/html/glpi/files/_cron has been validated.

Write access to /var/www/html/glpi/files has been validated.

Write access to /var/www/html/glpi/files/_graphs has been validated.

Write access to /var/www/html/glpi/files/_lock has been validated.

Write access to /var/www/html/glpi/files/_pictures has been validated.

Write access to /var/www/html/glpi/files/_plugins has been validated.

Write access to /var/www/html/glpi/files/_rss has been validated.

Write access to /var/www/html/glpi/files/_sessions has been validated.

Write access to /var/www/html/glpi/files/_tmp has been validated.

Write access to /var/www/html/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.1"

GLPI_SCHEMA_VERSION: "11.0.1@ea2dbba0e1edbf5128d73bdb23c2c9b9f68468ba"

GLPI_FILES_VERSION: "11.0.1-3a9929cf"

GLPI_MIN_PHP: "8.2"

GLPI_MAX_PHP: "8.5"

GLPI_YEAR: "2025"

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

GLPI_ENVIRONMENT_TYPE: "production"

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

GLPI_VAR_DIR: "/var/www/html/glpi/files"

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_DOC_DIR: "/var/www/html/glpi/files"

GLPI_CACHE_DIR: "/var/www/html/glpi/files/_cache"

GLPI_CRON_DIR: "/var/www/html/glpi/files/_cron"

GLPI_GRAPH_DIR: "/var/www/html/glpi/files/_graphs"

GLPI_LOCAL_I18N_DIR: "/var/www/html/glpi/files/_locales"

GLPI_LOCK_DIR: "/var/www/html/glpi/files/_lock"

GLPI_LOG_DIR: "/var/www/html/glpi/files/_log"

GLPI_PICTURE_DIR: "/var/www/html/glpi/files/_pictures"

GLPI_PLUGIN_DOC_DIR: "/var/www/html/glpi/files/_plugins"

GLPI_RSS_DIR: "/var/www/html/glpi/files/_rss"

GLPI_SESSION_DIR: "/var/www/html/glpi/files/_sessions"

GLPI_TMP_DIR: "/var/www/html/glpi/files/_tmp"

GLPI_UPLOAD_DIR: "/var/www/html/glpi/files/_uploads"

GLPI_INVENTORY_DIR: "/var/www/html/glpi/files/_inventories"

GLPI_THEMES_DIR: "/var/www/html/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/"
Réplicats SQL
Not active
Notifications
Way of sending emails: SMTP(smtp://informatique%40lachapelle.me:********@smtp.gmail.com:465?verify_peer=0)

Name: 'Informatique @ laChapelle'

Active: Yes

Server: '{imap.gmail.com:993/imap/ssl}INBOX'

Login: 'informatique@lachapelle.me'

Password: Yes
Plugins list
actualtime           Name: ActualTime                     Version: 3.2.0      State: Installé / non activé

Install Method: Manual

fields               Name: Additional fields              Version: 1.22.2     State: A mettre à jour

Install Method: Manual

datainjection        Name: Data injection                 Version: 2.14.2     State: Installé / non activé

Install Method: Manual

formcreator          Name: Form Creator                   Version: 2.13.10    State: Installé / non activé

Install Method: Manual

gantt                Name: gantt                          Version: 1.1.1      State: Installé / non activé

Install Method: Manual

genericobject        Name: Generic Objects End-of-Life Up Version: 3.0.0      State: Activé

Install Method: Manual

glpiinventory        Name: GLPI Inventory                 Version: 1.5.3      State: Installé / non activé

Install Method: Manual

phpsaml              Name: PHP SAML                       Version: 1.2.1      State: Installé / non activé

Install Method: Manual


Anything else?


Before using the fields plugin 1.22.2, I was using version 1.22.0.

When migrating, I have the following warning messages (and the value of the fields were not migrating) time the number of items I have in my DB


PHP Warning (2): Undefined array key "is_recursive" at glpicustomassettabletteassetinfostablette.class.php line 152 in ./files/_plugins/fields/inc/glpicustomassettabletteassetinfostablette.class.php at line 152

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