Since update to TYPO3 v11 there occurs a DBAL Exception when changing the slug of a page:

(1/3) Doctrine\DBAL\Exception\DriverException

An exception occurred while executing 'INSERT INTO `sys_redirect` (`pid`, `updatedon`, `createdon`, `createdby`, `deleted`, `disabled`, `starttime`, `endtime`, `source_host`, `source_path`, `is_regexp`, `force_https`, `respect_query_parameters`, `target`, `target_statuscode`, `hitcount`, `lasthiton`, `disable_hitcount`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14516, 1738235518, 1738235518, 1, 0, 0, 0, 210757111918, "mevo.dev.mehrdemokratie.de", "\/aktionen\/wahlpruefsteine-ob-wahl-rostock\/matthias-braeuer", 0, 0, 0, "t3:\/\/page?uid=14516&_language=0", 307, 0, 0, 0]: Out of range value for column 'endtime' at row 1

TYPO3 generates a redirect entry when changing the slug. But look at the endtime value: 210757111918! Which means: 17.08.8648 11:11:58 which is completely false. There is no entry in the endtime field!

When I examine the TCA for the redirects table I find:

endtime
    config
        type = input
        renderType = inputDateTime
        default = 0
        range
            upper = 2145913200
        eval = datetime,int

This means for the upper range: "01.01.2038 00:00:00" which is also crazy.

How can this be changed? I don't want to have an upper range, and I don't want to have false values for endtime. It seems to be an error in the redirects module.

Since update to TYPO3 v11 there occurs a DBAL Exception when changing the slug of a page:

(1/3) Doctrine\DBAL\Exception\DriverException

An exception occurred while executing 'INSERT INTO `sys_redirect` (`pid`, `updatedon`, `createdon`, `createdby`, `deleted`, `disabled`, `starttime`, `endtime`, `source_host`, `source_path`, `is_regexp`, `force_https`, `respect_query_parameters`, `target`, `target_statuscode`, `hitcount`, `lasthiton`, `disable_hitcount`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [14516, 1738235518, 1738235518, 1, 0, 0, 0, 210757111918, "mevo.dev.mehrdemokratie.de", "\/aktionen\/wahlpruefsteine-ob-wahl-rostock\/matthias-braeuer", 0, 0, 0, "t3:\/\/page?uid=14516&_language=0", 307, 0, 0, 0]: Out of range value for column 'endtime' at row 1

TYPO3 generates a redirect entry when changing the slug. But look at the endtime value: 210757111918! Which means: 17.08.8648 11:11:58 which is completely false. There is no entry in the endtime field!

When I examine the TCA for the redirects table I find:

endtime
    config
        type = input
        renderType = inputDateTime
        default = 0
        range
            upper = 2145913200
        eval = datetime,int

This means for the upper range: "01.01.2038 00:00:00" which is also crazy.

How can this be changed? I don't want to have an upper range, and I don't want to have false values for endtime. It seems to be an error in the redirects module.

• dbal
• typo3-11.x

1 Answer 1

In the sites configuration I found

settings
    redirects
        redirectTTL: 214000

This caused the problem. After setting redirectTTL to 0 the problem disappeared.