Bug #24498
closedErrormessage if you insert a new record on a workspace and the label is mapped to an integer field
0%
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
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.
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
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.