Project

General

Profile

Actions

Bug #24498

closed

Errormessage if you insert a new record on a workspace and the label is mapped to an integer field

Added by Sascha almost 14 years ago. Updated over 9 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2011-01-07
Due date:
% Done:

0%

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

Description

I get an error while inserting new elements on a workspace with a self-written extbase extension, when I configure TCA[ctrl][label] to an integer field.

Error Message: 102: These fields are not properly updated in database: (weekday) Probably value mismatch with fieldtype.

Although an error mesage is shown, all fields get properly inserted and updated in DB.

This happens only on a draft workspace not on live workspace. This error happens only, when the label is mapped to an integer field in DB. When I change the label mapping to a varchar field in DB, no error occurs.

Looking through the code, the error occurs in function checkStoredRecord in class.t3lib_tcemain.php, Line 6159 ff.

There are also some forum entries regarding this problem, for example:
http://www.typo3forum.net/forum/typo3-4-x-fragen-probleme/41808-fehlermeldung-anlegen-datensatzes-draft-custom-workspace.html

Parts of my TCA configuration:

$TCA['tx_iostorefinder_domain_model_openinghours'] = array (
'ctrl' => array (
'title' => 'LLL:EXT:io_storefinder/Resources/Private/Language/locallang_db.xml:tx_iostorefinder_domain_model_openinghours',
'label' => 'weekday',
'tstamp' => 'tstamp',
'crdate' => 'crdate',
'versioningWS' => 2,
'versioning_followPages' => TRUE,
'origUid' => 't3_origuid',
'languageField' => 'sys_language_uid',
'transOrigPointerField' => 'l18n_parent',
'transOrigDiffSourceField' => 'l18n_diffsource',
'delete' => 'deleted',
'enablecolumns' => array(
'disabled' => 'hidden'
),
'default_sortby' => 'ORDER BY store,weekday',
'dynamicConfigFile' => t3lib_extMgm::extPath($_EXTKEY) . 'Configuration/TCA/OpeningHours.php',
'iconfile' => t3lib_extMgm::extRelPath($_EXTKEY) . 'Resources/Public/Icons/tx_iostorefinder_domain_model_openinghours.gif'
)
);
(issue imported from #M16943)


Files

draft.png (7.5 KB) draft.png Alex Kellner, 2014-01-21 11:04
Actions #1

Updated by Alex Kellner almost 11 years ago

I can confirm this issue in current TYPO3 4.5.32
We're using an extension and the message comes up, if we save new records with integer fields.
It doesn't matter if I try to change the TCA-Settings.
The only thing that helps, is to change the field from integer to varchar in the database.

Actions #2

Updated by Mathias Schreiber almost 10 years ago

  • Description updated (diff)
  • Status changed from New to Needs Feedback
  • Assignee set to Mathias Schreiber
  • Is Regression set to No

is this still the case?

If so, could you attach a small extension so we can speed up the review process?

Thanks in advance

Actions #3

Updated by Alexander Opitz over 9 years ago

  • Status changed from Needs Feedback to Closed
  • Assignee deleted (Mathias Schreiber)

No feedback within the last 90 days => closing this issue.

If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.

Actions

Also available in: Atom PDF