If I enter a custom field, typed Currency, with a comma (,) as decimal separator, I get an Sql error (extract hereafter).
It would be nice to manage the translation of the decimal separator to the correct value (a dot .) before insert into the db, just like it is done for amounts entered in the 'financial and admin information' tab.
SQL: UPDATE glpi_plugin_customfields_monitors
SET typecurrency = \'4,13\' WHERE id =\'1\'
Error: Incorrect decimal value: '4,13' for column 'typecurrency' at row 1
Backtrace :
inc/commondbtm.class.php:353
inc/commondbtm.class.php:1108 CommonDBTM->updateInDB()
plugins/customfields/front/field.form.php:49 CommonDBTM->update()
v1.7 for GLPI 0.85
If I enter a custom field, typed Currency, with a comma (,) as decimal separator, I get an Sql error (extract hereafter). It would be nice to manage the translation of the decimal separator to the correct value (a dot .) before insert into the db, just like it is done for amounts entered in the 'financial and admin information' tab.
SQL: UPDATE
glpi_plugin_customfields_monitorsSETtypecurrency= \'4,13\' WHEREid=\'1\' Error: Incorrect decimal value: '4,13' for column 'typecurrency' at row 1 Backtrace : inc/commondbtm.class.php:353inc/commondbtm.class.php:1108 CommonDBTM->updateInDB() plugins/customfields/front/field.form.php:49 CommonDBTM->update()
( redmine : https://forge.glpi-project.org/issues/5423 )