Default for time columns

TYPO3 Questions Extensions
1

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. :frowning:

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 :wink:

/**
 * 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)