Issue Bug New Quiet

#93643Database Analyzer Length of Double not synchronized

varioous OG 03/04/21, 08:35 updated 10/17/26, 09:40

Description

Hello,

when i have Number definitions in ext_tables.sql like that:

weight_self double(11,4) NOT NULL DEFAULT '0.0000',

After synchronizing with the “Analyze Database Structure” the field is created, but without the correct length is ignored (see attached screenshot). When changing the field to

weight_self double(9,2) NOT NULL DEFAULT '0.00',

the Analyse Database Structure tools does not detect any changes.

Problem is, if we set the weight of the object to 4.246 and trying to save ($repository->update()) a error message is thrown:

{exception“Doctrine\\DBAL\\Driver\\Mysqli\\Exception\\StatementError: Data truncated for column ‘weight’ at row 1 in
……..
{closure}()\n#23 {main}\n\nNext Doctrine\\DBAL\\Exception\\DriverException: An exception occurred while executing ‘UPDATE `tx_xxxxxxx` SET `weight` = ? WHERE `uid` = ?’ with params [\“0,878\”, 1629]:\n\nData truncated for column ‘weight’ at row 1 in

Reviews 1

Fix this issue

Start the commit message of your patch with this. Add what the patch does, and the versions it goes to in "Releases:". The changes above were merged or abandoned: read them before you start. How to create a patch

Commit message
[BUGFIX] Database Analyzer Length of Double not synchronized Resolves: #93643 Releases: main

Files 1

History 46