glpi-project/glpi

Errors when attempting to update financial information for GLPI 11 RC5 assets

Closed this issue · 1 comments

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).

Image Image

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

@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.