Issue Bug Closed

#17551Error message when creating a record in draft WS with a "double" field

Oliver Klee 08/22/07, 11:25 updated 10/02/18, 12:32

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)

Reviews 3