Project

General

Profile

Actions

Bug #92306

closed

Field with dbType = 'time' and eval 'time' not saved correctly to the database

Added by Thorben Nissen about 4 years ago. Updated 4 months ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
DataHandler aka TCEmain
Target version:
Start date:
2020-09-14
Due date:
% Done:

0%

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

Description

When using native timefield in database and input with eval 'time', the entered value is not correctly saved in the database. When showing the form again, that wrong value from the database is shown.

When the field is changed, the new value is internally stored as an integer in the backend interface. When submitted it is then used as date string, when converting the field value to a timestamp, which leads to a wrong datetime.

To reproduce configure a field as follows:
  • database field is set to time
  • field TCA type set to input
  • field TCA dbType set to time
  • field TCA eval set to time

This behaviour is present in v9, v10 and master.

Actions #1

Updated by Gerrit Code Review about 4 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65735

Actions #2

Updated by Gerrit Code Review about 3 years ago

Patch set 2 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65735

Actions #3

Updated by Gerrit Code Review almost 3 years ago

Patch set 3 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65735

Actions #4

Updated by Gerrit Code Review almost 3 years ago

Patch set 4 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65735

Actions #5

Updated by Gerrit Code Review over 1 year ago

Patch set 5 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/65735

Actions #6

Updated by Benni Mack over 1 year ago

  • Status changed from Under Review to Needs Feedback

Can you check if the problem still exists in v12+ ?

Actions #7

Updated by Georg Ringer 4 months ago

  • Status changed from Needs Feedback to Closed

closing cause lack of feedback. a lot changed in latest version.

if still valid in v13, please open a new issue and reference this one or contact me on slack. thanks

Actions

Also available in: Atom PDF