Errors when attempting to update financial information for GLPI 11 RC5 assets
Closed this issue · 1 comments
lucaslevi-consultor-glpi commented
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 RC5
Bug description
Good evening everyone, I was testing the inventory here and came across the following:
The financial information tab is not working properly. When trying to update the purchase date, item value, depreciation type, etc., this error appears on the screen and the log shows what I will send below.
PS: I tested the same operation on computers and also on generic assets (financial information tab).
Relevant log output
glpi.CRITICAL: *** Uncaught PHP Exception RuntimeException: "MySQL query error: Incorrect decimal value: '' for column `glpi_11provadefogo`.`glpi_infocoms`.`value` at row 1 (1366) in SQL query "UPDATE `glpi_infocoms` SET `delivery_date` = '2025-08-01', `inventory_date` = '2025-08-01', `value` = '', `date_mod` = '' WHERE `id` = '9'"." at DBmysql.php line 381
Backtrace :
./src/DBmysql.php:381
./src/DBmysql.php:1456 DBmysql->doQuery()
./src/CommonDBTM.php:733 DBmysql->update()
./src/CommonDBTM.php:1760 CommonDBTM->updateInDB()
...c/Glpi/Controller/GenericFormController.php:147 CommonDBTM->update()
./src/Glpi/Controller/GenericFormController.php:83 Glpi\Controller\GenericFormController->handleFormAction()
./vendor/symfony/http-kernel/HttpKernel.php:181 Glpi\Controller\GenericFormController->__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
Financial information on assets in general
Steps To reproduce
No response
Your GLPI setup information
No response
Anything else?
No response
lucaslevi-consultor-glpi commented
@trasher Thanks for getting back to me. Sometimes it's hard to find out whether the problem in question has already been reported or not.