Project

General

Profile

Actions

Bug #19131

closed

Warning 102 when saving record with hidden double fields in the BE

Added by Oliver Klee over 16 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Category:
-
Target version:
-
Start date:
2008-07-21
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.3
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Steps to reproduce:

1. Install the "seminars" extension.
2. Create a non-admin BE user who is allowed to create organizer and event records.
3. Log in as/sudo to that BE user.
4. Create an organizer record and save/close it.
5. Create a seminar record, enter a title and assign the organizer.
6. Save it.

This error message is displayed (although the rest of the data is saved okay):

102: These fields are not properly updated in database:
(price_regular_early,price_regular_board,price_special,price_special_early,price_special_board)
Probably value mismatch with fieldtype.

These fields are hidden and defined like this in SQL and TCA:

price_regular decimal(7,2) DEFAULT '0.00' NOT NULL,
'price_regular' => array(
'exclude' => 1,
'label' => 'LLL:EXT:seminars/locallang_db.xml:tx_seminars_seminars.price_regular',
'config' => array(
'type' => 'input',
'size' => '8',
'max' => '8',
'eval' => 'double2',
'checkbox' => '0.00',
'range' => array(
'upper' => '99999.99',
'lower' => '0'
),
'default' => 0
)
),

I guess that the problem is that hidden excludefields are saved to an empty string by default (this is a guess), which isn't a valid value for DECIMAL.

This might be related to bug 6194.
(issue imported from #M9016)

Actions

Also available in: Atom PDF