[GLPI 11] GenericAssets - Error after adding custom asset as dropdown to result view #1153
Description
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
GLPI 11
Plugin version
1.23.3
Bug description
After adding customasset (additional dropdown field) and adding this custom field as a column to the results view, we received the following exception:
An exception has been thrown during the rendering of a template ("MySQL query error: Table 'glpidb.glpi_customassets_produktassets' doesn't exist (1146) in SQL query in "pages/generic_list.html.twig" at line 37.
Values are stored in glpi.glpi_assets_assets and not in glpi_customassets_****
Maybe related to fix in commit fe1869f or 8b34f0f.
Relevant log output
An exception has been thrown during the rendering of a template ("MySQL query error: Table 'glpidb.glpi_customassets_produktassets' doesn't exist (1146) in SQL query in "pages/generic_list.html.twig" at line 37.
In ./templates/pages/generic_list.html.twig(37)
#0 ./vendor/twig/twig/src/Template.php(358): Twig\Template->yield()
#1 ./vendor/twig/twig/src/Template.php(373): Twig\Template->display()
#2 ./vendor/twig/twig/src/TemplateWrapper.php(51): Twig\Template->render()
#3 ./src/Glpi/Application/View/TemplateRenderer.php(170): Twig\TemplateWrapper->render()
#4 ./src/Glpi/Controller/AbstractController.php(68): Glpi\Application\View\TemplateRenderer->render()
#5 ./src/Glpi/Controller/GenericListController.php(51): Glpi\Controller\AbstractController->render()
#6 ./vendor/symfony/http-kernel/HttpKernel.php(181): Glpi\Controller\GenericListController->__invoke()
#7 ./vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
#8 ./vendor/symfony/http-kernel/Kernel.php(197): Symfony\Component\HttpKernel\HttpKernel->handle()
#9 ./public/index.php(71): Symfony\Component\HttpKernel\Kernel->handle()
#10 {main}Page URL
No response
Steps To reproduce
- GLPI: Create custom asset
- Fields: Create new block for associated item type licences and "insertion in the form (before save button)"
- Fileds: Add new dropdown for custom asset (1)
- GLPI: Add newly created column to licences result view.
Your GLPI setup information
GLPI: 11.0.5 ( => /var/www/glpi)
Installation mode: DOCKER
Current language: en_GB
Source Integrity: OK
Operating system: Linux 025f69dcd485 5.14.0-570.51.1.el9_6.x86_64 #1 SMP PREEMPT_DYNAMIC Sat Sep 27 01:10:11 EDT 2025 x86_64
PHP: 8.5.2 apache2handler
PHP extensions: Core, date, lexbor, openssl, pcre, sqlite3, zlib, ctype, curl, uri, json, fileinfo, filter, hash, iconv, SPL,
mbstring, Zend OPcache, session, standard, PDO, pdo_sqlite, bz2, posix, random, Reflection, libxml, SimpleXML, tokenizer, dom,
xml, xmlreader, xmlwriter, mysqlnd, apache2handler, apcu, bcmath, Phar, exif, gd, intl, ldap, mysqli, redis, soap, sodium, zip
Setup: disable_functions="" max_execution_time="30" max_input_vars="1000" memory_limit="256M" post_max_size="105M"
session.cookie_secure="0" session.cookie_httponly="1" session.cookie_samesite="Strict" session.save_handler="files"
upload_max_filesize="100M"
Web server: Apache ()
User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/145.0.0.0 Safari/537.36
Edg/145.0.0.0
Database:
Server Software: MySQL Community Server - GPL
Server Version: 9.6.0
Server SQL Mode: STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
Parameters: glpi_admin@db:3306/glpidb
Host info: db via TCP/IP
Requirements:
PHP version (8.5.2) is supported.PHP version (8.5.2) is supported.
OS and PHP are relying on 64 bits integers.OS and PHP are relying on 64 bits integers.
Sessions configuration is OK.Sessions configuration is OK.
Allocated memory is sufficient.Allocated memory is sufficient.
Following extensions are installed: dom, fileinfo, filter, libxml, simplexml, tokenizer,
xmlreader, xmlwriter.Following extensions are installed: dom, fileinfo, filter, libxml, simplexml, tokenizer, xmlreader,
xmlwriter.
mysqli extension is installedmysqli extension is installed
curl extension is installedcurl extension is installed
gd extension is installedgd extension is installed
intl extension is installedintl extension is installed
mbstring extension is installedmbstring extension is installed
zlib extension is installedzlib extension is installed
bcmath extension is installedbcmath extension is installed
The constant SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.The constant
SODIUM_CRYPTO_AEAD_XCHACHA20POLY1305_IETF_NPUBBYTES is present.
openssl extension is installedopenssl extension is installed
Database engine version (9.6.0) is supported.Database engine version (9.6.0) is supported.
The log file has been created successfully.The log file has been created successfully.
Write access to /var/glpi/files/_cache has been validated. Write access to
/var/glpi/files/_cron has been validated. Write access to /var/glpi/files has been validated. Write access to
/var/glpi/files/_graphs has been validated. Write access to /var/glpi/files/_lock has been validated. Write access to
/var/glpi/files/_pictures has been validated. Write access to /var/glpi/files/_plugins has been validated. Write access to
/var/glpi/files/_rss has been validated. Write access to /var/glpi/files/_sessions has been validated. Write access to
/var/glpi/files/_tmp has been validated. Write access to /var/glpi/files/_uploads has been validated.Write access to
/var/glpi/files/_cache has been validated.
Write access to /var/glpi/files/_cron has been validated.
Write access to /var/glpi/files has been validated.
Write access to /var/glpi/files/_graphs has been validated.
Write access to /var/glpi/files/_lock has been validated.
Write access to /var/glpi/files/_pictures has been validated.
Write access to /var/glpi/files/_plugins has been validated.
Write access to /var/glpi/files/_rss has been validated.
Write access to /var/glpi/files/_sessions has been validated.
Write access to /var/glpi/files/_tmp has been validated.
Write access to /var/glpi/files/_uploads has been validated.
Sessions configuration is secured.Sessions configuration is secured.
exif extension is installedexif extension is installed
ldap extension is installedldap extension is installed
Following extensions are installed: bz2, Phar, zip.Following extensions are installed: bz2,
Phar, zip.
Zend OPcache extension is installedZend OPcache extension is installed
Following extensions are installed: ctype, iconv, sodium.Following extensions are installed:
ctype, iconv, sodium.
Write access to /var/glpi/marketplace has been validated.Write access to
/var/glpi/marketplace has been validated.
Timezones seems loaded in database.Timezones seems loaded in database.
Anything else?
No response