Issue Bug Closed

#96940Postgres: Translation of page content fails with SQL Error

Gerald Z 02/17/22, 09:15 updated 10/04/22, 14:14

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

Reviews 2