Project

General

Profile

Bug #93643

Updated by varioous OG over 3 years ago

Hello, 

 when i have Number definitions in ext_tables.sql like that: 
 <pre><code class="php"> 
 weight_self double(11,4) NOT NULL DEFAULT '0.0000', 
 </code></pre> 

 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 

 <pre><code class="php"> 
 weight_self double(9,2) NOT NULL DEFAULT '0.00', 
 </code></pre> 

 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  

Back