Project

General

Profile

Actions
Copy link

Bug #96940

closed

Postgres: Translation of page content fails with SQL Error

Added by Gerald Z almost 3 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Stefan Bürk
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2022-02-17
Due date:
% Done:

100%

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

Description

I'm setting up a new website with TYPO3 11.5.6 and the introduction package.

When I add a translation for a page everything works as expected. Then I use the translation wizard to translate the content in connected mode.

Then the problem occurs. I edit a content element and when I try to save the changes I get the following SQL Error:

SQL error: 'SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bytea' (pages:86)

It must have to do with the l18n_diffsource field in the tt_content table because it is the only bytea field.

The error only occurs on translated elements, not on the originals.

I'm on OpenBSD, with Nginx and Postgres.

See also https://stackoverflow.com/questions/71143613/typo3-11-5-6-postgres-translation-of-page-content-fails-with-sql-error

Files

typo3-96940-postgres13-issue.png (8.13 KB) typo3-96940-postgres13-issue.png Stefan Bürk, 2022-02-21 20:13
Actions
Copy link

Also available in: Atom PDF