Hello,
I would like to report this error on forge.typo3.org and also the correction right away. But it is no longer possible for me to log in to forge.typo3.org.
Maybe one of the core developers here reads my problem:
Since the change from Typo3 10 to 11, the column is no longer pre-populated with time in my extension.
The following settings worked fine with Typo3 10:
tx_participants_domain_model_event.php :
'time' => [
'label' => 'LLL:EXT:participants/Resources/Private/Language/locallang_db.xlf:tx_participants_domain_model_event.time',
'config' => [
'type' => 'input',
'renderType' => 'inputDateTime',
'dbType' => 'time',
'eval' => 'time',
'default' => 68400, // 19:00h
'mode' => 'useOrOverridePlaceholder'
]
],
ext_tables.sql
#
# Table structure for table 'tx_participants_domain_model_event'
#
CREATE TABLE tx_participants_domain_model_event (
uid int(11) UNSIGNED DEFAULT '0' NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
record_type VARCHAR(255) DEFAULT '' NOT NULL,
title VARCHAR(1) DEFAULT '' NOT NULL,
canceled SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
description TEXT DEFAULT '',
show_public_description SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
public_description TEXT DEFAULT '',
event_type int (11) UNSIGNED DEFAULT '0' NOT NULL,
usergroups SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
show_public_usergroups SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
public_usergroups SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
public SMALLINT (5) UNSIGNED DEFAULT '2' NOT NULL,
full_day SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
date VARCHAR(10) DEFAULT '0000-00-00' NOT NULL,
time VARCHAR(10) DEFAULT '00:00:00' NOT NULL,
duration SMALLINT (5) UNSIGNED DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
According to my analysis the problem is only one line in
TYPO3\CMS\Core\Database\Query\QueryHelper#getDateTimeFormats()
Here would be a patch of the fixed again:
@@ -196,7 +196,7 @@
'time' => [
'empty' => '00:00:00',
'format' => 'H:i:s',
- 'reset' => 0,
+ 'reset' => null,
],
];
}
The comment on this method says a lot
/**
* Returns the date and time formats compatible with the given database.
*
* This simple method should probably be deprecated and removed later.
*
* @return array
*/
How do I get this fix into the core of Typo3?
Greetings
Clemens
Translated with DeepL Translate: The world's most accurate translator (free version)