Bug #17551
closedError message when creating a record in draft WS with a "double" field
100%
Description
Steps to reproduce:
1. Install the attached extension ux_wstest. It basically creates a new database table including this line of SQL:
amount decimal(7,2) DEFAULT '0.00' NOT NULL,
... and these lines in tca.php:
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '8',
'eval' => 'double2',
'checkbox' => '0.00',
'range' => array(
'upper' => '99999.99',
'lower' => '0'
),
'default' => 0
)
2. In the live WS, go to a system folder and create a test record. (This works fine.)
3. Switch to the draft WS.
4. Edit and save the just-created record, creating a new version. (This works as well.)
5. Create and save a new record, using e.g. an amount of "1.23". The record will be saved correctly, but the following error message will be displayed nontheless:
102: These fields are not properly updated in database: (amount) Probably value mismatch with fieldtype.
I suppose the problem may occur when the placeholder record is created, trying to write an empty string into the DECIMAL field. (This is just a guess; I haven't looked that up yet.)
(issue imported from #M6194)
Files