The new field is_displayed_onservicecatalog introduced in the latest news release is not automatically created when updating the plugin, generating an error when trying to access service catalog after the update.
I was able to fix the issue by uninstalling and reinstalling the plugin, but this fix comes with the loss of all plugin data.
Server
Operating system: Linux prod-glpi-v11 6.12.73+deb13-amd64 #1 SMP PREEMPT_DYNAMIC Debian 6.12.73-1 (2026-02-17) x86_64
PHP: 8.4.16 fpm-fcgi
PHP extensions: Core, date, libxml, openssl, pcre, zlib, filter, hash, json, random, Reflection, SPL, session, standard, sodium, cgi-fcgi, mysqlnd, PDO, xml, apcu, bcmath, bz2, calendar, ctype, curl, dom, mbstring, FFI, fileinfo, ftp, gd, gettext, iconv, intl, ldap, exif, mysqli, pdo_mysql, Phar, posix, readline, shmop, SimpleXML, sockets, sysvmsg, sysvsem, sysvshm, tokenizer, xmlreader, xmlrpc, xmlwriter, xsl, zip, 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.66 (Debian) (Apache/2.4.66 (Debian) Server at xxxx.xxx Port 80)
User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0
Database:
Server Software: -- Please help get to 10k stars at https://github.com/MariaDB/Server
Server Version: 11.8.3-MariaDB-0+deb13u1 from Debian
Server SQL Mode: STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
Parameters: glpi_user@localhost/glpi
Host info: Localhost via UNIX socket
Requirements:
PHP version (8.4.16) 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 (11.8.3) 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.7"
GLPI_SCHEMA_VERSION: "11.0.7@a797be2bef86f3888448b141fa810dba6fb67795"
GLPI_FILES_VERSION: "11.0.7-49a93008"
GLPI_MIN_PHP: "8.2"
GLPI_MAX_PHP: "8.5"
GLPI_YEAR: "2026"
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_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/"
Code of Conduct
Is there an existing issue for this?
GLPI Version
11.0.7
Plugin version
1.14.0
Bug description
The new field is_displayed_onservicecatalog introduced in the latest news release is not automatically created when updating the plugin, generating an error when trying to access service catalog after the update.
I was able to fix the issue by uninstalling and reinstalling the plugin, but this fix comes with the loss of all plugin data.
Relevant log output
An exception has been thrown during the rendering of a template ("MySQL query error: Unknown column 'glpi_plugin_news_alerts.is_displayed_onservicecatalog' in 'WHERE' (1054) in SQL query "SELECT DISTINCT `glpi_plugin_news_alerts`.* FROM `glpi_plugin_news_alerts` LEFT JOIN `glpi_plugin_news_alerts_users` ON (`glpi_plugin_news_alerts_users`.`plugin_news_alerts_id` = `glpi_plugin_news_alerts`.`id` AND `glpi_plugin_news_alerts_users`.`users_id` = '7' AND `glpi_plugin_news_alerts_users`.`state` = '1') INNER JOIN `glpi_plugin_news_alerts_targets` ON (`glpi_plugin_news_alerts_targets`.`plugin_news_alerts_id` = `glpi_plugin_news_alerts`.`id` AND ((((`glpi_plugin_news_alerts_targets`.`itemtype` = 'Profile' AND (`glpi_plugin_news_alerts_targets`.`items_id` = '4' OR `glpi_plugin_news_alerts_targets`.`all_items` = '1'))) OR ((`glpi_plugin_news_alerts_targets`.`itemtype` = 'Group' AND `glpi_plugin_news_alerts_targets`.`items_id` IN ('7'))) OR ((`glpi_plugin_news_alerts_targets`.`itemtype` = 'User' AND `glpi_plugin_news_alerts_targets`.`items_id` = '7'))))) WHERE (`glpi_plugin_news_alerts_users`.`id` IS NULL) AND (((`glpi_plugin_news_alerts`.`date_start` <= '2026-05-04 10:49:29') OR (`glpi_plugin_news_alerts`.`date_start` IS NULL))) AND (((`glpi_plugin_news_alerts`.`date_end` >= '2026-05-04 10:49:29') OR (`glpi_plugin_news_alerts`.`date_end` IS NULL))) AND `is_deleted` = '0' AND `is_active` = '1' AND ((`glpi_plugin_news_alerts`.`entities_id` IN ('0'))) AND (`glpi_plugin_news_alerts`.`is_displayed_onservicecatalog` = '1')".") in "pages/self-service/service_catalog.html.twig" at line 96. In ./templates/pages/self-service/service_catalog.html.twig(96) #0 ./files/_cache/11.0.7-49a93008-production/templates/38/389f285154495c6cf97a6d79fee3a878.php(80): Twig\Template->yieldBlock() #1 ./vendor/twig/twig/src/Template.php(446): __TwigTemplate_9ed24606472276a60388c0c28c1630e3->block_content() #2 ./files/_cache/11.0.7-49a93008-production/templates/8a/8a6b4d5f7826932beb2f6a62312cdd5c.php(62): Twig\Template->yieldBlock() #3 ./vendor/twig/twig/src/Template.php(402): __TwigTemplate_b986808873055910232e876e061fec97->doDisplay() #4 ./files/_cache/11.0.7-49a93008-production/templates/38/389f285154495c6cf97a6d79fee3a878.php(49): Twig\Template->yield() #5 ./vendor/twig/twig/src/Template.php(402): __TwigTemplate_9ed24606472276a60388c0c28c1630e3->doDisplay() #6 ./files/_cache/11.0.7-49a93008-production/templates/cf/cfe50fb56fdafec843589ef7489a8168.php(55): Twig\Template->yield() #7 ./vendor/twig/twig/src/Template.php(402): __TwigTemplate_67775d17c8e2ec3a974fce11dc472750->doDisplay() #8 ./vendor/twig/twig/src/Template.php(358): Twig\Template->yield() #9 ./vendor/twig/twig/src/Template.php(373): Twig\Template->display() #10 ./vendor/twig/twig/src/TemplateWrapper.php(51): Twig\Template->render() #11 ./src/Glpi/Application/View/TemplateRenderer.php(170): Twig\TemplateWrapper->render() #12 ./src/Glpi/Controller/AbstractController.php(68): Glpi\Application\View\TemplateRenderer->render() #13 ./src/Glpi/Controller/ServiceCatalog/IndexController.php(98): Glpi\Controller\AbstractController->render() #14 ./vendor/symfony/http-kernel/HttpKernel.php(181): Glpi\Controller\ServiceCatalog\IndexController->__invoke() #15 ./vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #16 ./vendor/symfony/http-kernel/Kernel.php(208): Symfony\Component\HttpKernel\HttpKernel->handle() #17 ./public/index.php(71): Symfony\Component\HttpKernel\Kernel->handle() #18 {main} Previous: MySQL query error: Unknown column 'glpi_plugin_news_alerts.is_displayed_onservicecatalog' in 'WHERE' (1054) in SQL query "SELECT DISTINCT `glpi_plugin_news_alerts`.* FROM `glpi_plugin_news_alerts` LEFT JOIN `glpi_plugin_news_alerts_users` ON (`glpi_plugin_news_alerts_users`.`plugin_news_alerts_id` = `glpi_plugin_news_alerts`.`id` AND `glpi_plugin_news_alerts_users`.`users_id` = '7' AND `glpi_plugin_news_alerts_users`.`state` = '1') INNER JOIN `glpi_plugin_news_alerts_targets` ON (`glpi_plugin_news_alerts_targets`.`plugin_news_alerts_id` = `glpi_plugin_news_alerts`.`id` AND ((((`glpi_plugin_news_alerts_targets`.`itemtype` = 'Profile' AND (`glpi_plugin_news_alerts_targets`.`items_id` = '4' OR `glpi_plugin_news_alerts_targets`.`all_items` = '1'))) OR ((`glpi_plugin_news_alerts_targets`.`itemtype` = 'Group' AND `glpi_plugin_news_alerts_targets`.`items_id` IN ('7'))) OR ((`glpi_plugin_news_alerts_targets`.`itemtype` = 'User' AND `glpi_plugin_news_alerts_targets`.`items_id` = '7'))))) WHERE (`glpi_plugin_news_alerts_users`.`id` IS NULL) AND (((`glpi_plugin_news_alerts`.`date_start` <= '2026-05-04 10:49:29') OR (`glpi_plugin_news_alerts`.`date_start` IS NULL))) AND (((`glpi_plugin_news_alerts`.`date_end` >= '2026-05-04 10:49:29') OR (`glpi_plugin_news_alerts`.`date_end` IS NULL))) AND `is_deleted` = '0' AND `is_active` = '1' AND ((`glpi_plugin_news_alerts`.`entities_id` IN ('0'))) AND (`glpi_plugin_news_alerts`.`is_displayed_onservicecatalog` = '1')". In ./src/DBmysql.php(416) #0 ./src/DBmysqlIterator.php(129): DBmysql->doQuery() #1 ./src/DBmysql.php(1088): DBmysqlIterator->execute() #2 ./marketplace/news/inc/alert.class.php(414): DBmysql->request() #3 ./marketplace/news/inc/alert.class.php(564): PluginNewsAlert::findAllToNotify() #4 ./marketplace/news/inc/alert.class.php(545): PluginNewsAlert::displayAlerts() #5 ./src/Plugin.php(1826): PluginNewsAlert::displayOnServiceCatalog() #6 ./src/Glpi/Application/View/Extension/PluginExtension.php(74): Plugin::doHook() #7 ./files/_cache/11.0.7-49a93008-production/templates/cf/cfe50fb56fdafec843589ef7489a8168.php(131): Glpi\Application\View\Extension\PluginExtension->callPluginHook() #8 ./vendor/twig/twig/src/Template.php(446): __TwigTemplate_67775d17c8e2ec3a974fce11dc472750->block_content_body() #9 ./files/_cache/11.0.7-49a93008-production/templates/38/389f285154495c6cf97a6d79fee3a878.php(80): Twig\Template->yieldBlock() #10 ./vendor/twig/twig/src/Template.php(446): __TwigTemplate_9ed24606472276a60388c0c28c1630e3->block_content() #11 ./files/_cache/11.0.7-49a93008-production/templates/8a/8a6b4d5f7826932beb2f6a62312cdd5c.php(62): Twig\Template->yieldBlock() #12 ./vendor/twig/twig/src/Template.php(402): __TwigTemplate_b986808873055910232e876e061fec97->doDisplay() #13 ./files/_cache/11.0.7-49a93008-production/templates/38/389f285154495c6cf97a6d79fee3a878.php(49): Twig\Template->yield() #14 ./vendor/twig/twig/src/Template.php(402): __TwigTemplate_9ed24606472276a60388c0c28c1630e3->doDisplay() #15 ./files/_cache/11.0.7-49a93008-production/templates/cf/cfe50fb56fdafec843589ef7489a8168.php(55): Twig\Template->yield() #16 ./vendor/twig/twig/src/Template.php(402): __TwigTemplate_67775d17c8e2ec3a974fce11dc472750->doDisplay() #17 ./vendor/twig/twig/src/Template.php(358): Twig\Template->yield() #18 ./vendor/twig/twig/src/Template.php(373): Twig\Template->display() #19 ./vendor/twig/twig/src/TemplateWrapper.php(51): Twig\Template->render() #20 ./src/Glpi/Application/View/TemplateRenderer.php(170): Twig\TemplateWrapper->render() #21 ./src/Glpi/Controller/AbstractController.php(68): Glpi\Application\View\TemplateRenderer->render() #22 ./src/Glpi/Controller/ServiceCatalog/IndexController.php(98): Glpi\Controller\AbstractController->render() #23 ./vendor/symfony/http-kernel/HttpKernel.php(181): Glpi\Controller\ServiceCatalog\IndexController->__invoke() #24 ./vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw() #25 ./vendor/symfony/http-kernel/Kernel.php(208): Symfony\Component\HttpKernel\HttpKernel->handle() #26 ./public/index.php(71): Symfony\Component\HttpKernel\Kernel->handle() #27 {main}Page URL
No response
Steps To reproduce
Your GLPI setup information
GLPI information
Server
GLPI constants
SQL replicas
Plugins list
Anything else?
No response