-
-
Notifications
You must be signed in to change notification settings - Fork 1.5k
Open
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
Version
GLPI 11.0.0-rc5
Bug description
After creating an asset definition and creating a view with a custom field on it I get the following error:
Error 500
Relevant log output
[2025-09-26 10:01:34] glpi.CRITICAL: *** Uncaught PHP Exception Twig\Error\RuntimeError: "An exception has been thrown during the rendering of a template ("MySQL query error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'JSON), '$.\"2\"')) WHERE (1) AND `glpi_assets_assets`.`is_deleted` = 0 AND ...' at line 2 (1064) in SQL query "SELECT DISTINCT `glpi_assets_assets`.`id` AS id, 'bmendes' AS currentuser,
`glpi_assets_assets`.`entities_id`, `glpi_assets_assets`.`is_recursive`, `glpi_assets_assets`.`name` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_1`, `glpi_assets_assets`.`id` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_1_id`, `glpi_assets_assettypes`.`name` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_4`, `glpi_assets_assetmodels`.`name` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_40`, `glpi_assets_assets`.`serial` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_5`, `glpi_manufacturers`.`name` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_23`, `glpi_states`.`completename` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_31`, `glpi_locations`.`completename` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_3`, `glpi_assets_assets`.`date_mod` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_19`, GROUP_CONCAT(DISTINCT CONCAT(`glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929`.`name`, '$#$', `glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929`.`id`) ORDER BY `glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929`.`id` SEPARATOR '$$##$$') AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_45002` FROM `glpi_assets_assets` LEFT JOIN `glpi_assets_assettypes` ON (`glpi_assets_assets`.`assets_assettypes_id` = `glpi_assets_assettypes`.`id`) LEFT JOIN `glpi_assets_assetmodels` ON (`glpi_assets_assets`.`assets_assetmodels_id` = `glpi_assets_assetmodels`.`id`) LEFT JOIN `glpi_manufacturers` ON (`glpi_assets_assets`.`manufacturers_id` = `glpi_manufacturers`.`id`) LEFT JOIN `glpi_states` ON (`glpi_assets_assets`.`states_id` = `glpi_states`.`id`) LEFT JOIN `glpi_locations` ON (`glpi_assets_assets`.`locations_id` = `glpi_locations`.`id`) LEFT JOIN `glpi_dropdowns_dropdowns` AS `glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929` ON (JSON_CONTAINS(`glpi_assets_assets`.`custom_fields`, CAST(`glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929`.`id` AS JSON), '$.\"2\"')) WHERE (1) AND `glpi_assets_assets`.`is_deleted` = 0 AND `glpi_assets_assets`.`is_template` = 0 AND (`glpi_assets_assets`.`assets_assetdefinitions_id` = '2') GROUP BY `glpi_assets_assets`.`id` LIMIT 0, 40".") in "pages/generic_list.html.twig" at line 37." at generic_list.html.twig line 37
Backtrace :
./templates/pages/generic_list.html.twig:37
./vendor/twig/twig/src/Template.php:358 Twig\Template->yield()
./vendor/twig/twig/src/Template.php:373 Twig\Template->display()
./vendor/twig/twig/src/TemplateWrapper.php:51 Twig\Template->render()
.../Glpi/Application/View/TemplateRenderer.php:170 Twig\TemplateWrapper->render()
./src/Glpi/Controller/AbstractController.php:68 Glpi\Application\View\TemplateRenderer->render()
./src/Glpi/Controller/GenericListController.php:51 Glpi\Controller\AbstractController->render()
./vendor/symfony/http-kernel/HttpKernel.php:181 Glpi\Controller\GenericListController->__invoke()
./vendor/symfony/http-kernel/HttpKernel.php:76 Symfony\Component\HttpKernel\HttpKernel->handleRaw()
./vendor/symfony/http-kernel/Kernel.php:197 Symfony\Component\HttpKernel\HttpKernel->handle()
./public/index.php:70 Symfony\Component\HttpKernel\Kernel->handle()
Previous: MySQL query error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'JSON), '$.\"2\"')) WHERE (1) AND `glpi_assets_assets`.`is_deleted` = 0 AND ...' at line 2 (1064) in SQL query "SELECT DISTINCT `glpi_assets_assets`.`id` AS id, 'bmendes' AS currentuser,
`glpi_assets_assets`.`entities_id`, `glpi_assets_assets`.`is_recursive`, `glpi_assets_assets`.`name` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_1`, `glpi_assets_assets`.`id` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_1_id`, `glpi_assets_assettypes`.`name` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_4`, `glpi_assets_assetmodels`.`name` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_40`, `glpi_assets_assets`.`serial` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_5`, `glpi_manufacturers`.`name` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_23`, `glpi_states`.`completename` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_31`, `glpi_locations`.`completename` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_3`, `glpi_assets_assets`.`date_mod` AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_19`, GROUP_CONCAT(DISTINCT CONCAT(`glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929`.`name`, '$#$', `glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929`.`id`) ORDER BY `glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929`.`id` SEPARATOR '$$##$$') AS `ITEM_Glpi\CustomAsset\NumeroMovelAsset_45002` FROM `glpi_assets_assets` LEFT JOIN `glpi_assets_assettypes` ON (`glpi_assets_assets`.`assets_assettypes_id` = `glpi_assets_assettypes`.`id`) LEFT JOIN `glpi_assets_assetmodels` ON (`glpi_assets_assets`.`assets_assetmodels_id` = `glpi_assets_assetmodels`.`id`) LEFT JOIN `glpi_manufacturers` ON (`glpi_assets_assets`.`manufacturers_id` = `glpi_manufacturers`.`id`) LEFT JOIN `glpi_states` ON (`glpi_assets_assets`.`states_id` = `glpi_states`.`id`) LEFT JOIN `glpi_locations` ON (`glpi_assets_assets`.`locations_id` = `glpi_locations`.`id`) LEFT JOIN `glpi_dropdowns_dropdowns` AS `glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929` ON (JSON_CONTAINS(`glpi_assets_assets`.`custom_fields`, CAST(`glpi_dropdowns_dropdowns_custom_fields_22b71b877f8218e5eb326c37464b5929`.`id` AS JSON), '$.\"2\"')) WHERE (1) AND `glpi_assets_assets`.`is_deleted` = 0 AND `glpi_assets_assets`.`is_template` = 0 AND (`glpi_assets_assets`.`assets_assetdefinitions_id` = '2') GROUP BY `glpi_assets_assets`.`id` LIMIT 0, 40".
./src/DBmysql.php:381
./src/Glpi/Search/Provider/SQLProvider.php:4910 DBmysql->doQuery()
./src/Glpi/Search/SearchEngine.php:654 Glpi\Search\Provider\SQLProvider::constructData()
./src/Glpi/Search/SearchEngine.php:669 Glpi\Search\SearchEngine::getData()
./src/Glpi/Search/SearchEngine.php:626 Glpi\Search\SearchEngine::showOutput()
: Glpi\Search\SearchEngine::show()
.../Application/View/Extension/PhpExtension.php:93 call_user_func_array()
...ates/d2/d2b37832bf51af0b62c74e19009d9f3a.php:55 Glpi\Application\View\Extension\PhpExtension->call()
./vendor/twig/twig/src/Template.php:402 __TwigTemplate_b40120a834b3391b61c2a12879a3687d->doDisplay()
./vendor/twig/twig/src/Template.php:358 Twig\Template->yield()
./vendor/twig/twig/src/Template.php:373 Twig\Template->display()
./vendor/twig/twig/src/TemplateWrapper.php:51 Twig\Template->render()
.../Glpi/Application/View/TemplateRenderer.php:170 Twig\TemplateWrapper->render()
./src/Glpi/Controller/AbstractController.php:68 Glpi\Application\View\TemplateRenderer->render()
./src/Glpi/Controller/GenericListController.php:51 Glpi\Controller\AbstractController->render()
./vendor/symfony/http-kernel/HttpKernel.php:181 Glpi\Controller\GenericListController->__invoke()
./vendor/symfony/http-kernel/HttpKernel.php:76 Symfony\Component\HttpKernel\HttpKernel->handleRaw()
./vendor/symfony/http-kernel/Kernel.php:197 Symfony\Component\HttpKernel\HttpKernel->handle()
./public/index.php:70 Symfony\Component\HttpKernel\Kernel->handle()
Page URL
No response
Steps To reproduce
No response
Your GLPI setup information
No response
Anything else?
No response
Metadata
Metadata
Assignees
Type
Projects
Status
Backlog