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)
The error only occurs on translated elements, not on the originals.
What could be the problem?
I'm on OpenBSD, with Nginx and Postgres.
Update:
It must have to do with the l18n_diffsource field in the tt_content table because it is the only bytea field.
Table "public.tt_content"
Column | Type | Collation | Nullable | Default | Storage | Stats target | Description
-------------------------------------+-------------------------+-----------+----------+-----------------------------------------+----------+--------------+-------------
uid | integer | | not null | nextval('tt_content_uid_seq'::regclass) | plain | |
rowDescription | text | | | | extended | |
pid | integer | | not null | 0 | plain | |
......
l18n_parent | integer | | not null | 0 | plain | |
l10n_source | integer | | not null | 0 | plain | |
l10n_state | text | | | | extended | |
t3_origuid | integer | | not null | 0 | plain | |
l18n_diffsource | bytea | | | | extended | |
t3ver_oid | integer | | not null | 0 | plain | |
t3ver_wsid | integer | | not null | 0 | plain | |
t3ver_state | smallint | | not null | 0 | plain | |
t3ver_stage | integer | | not null | 0 | plain | |
Update 2:
I reported this as a bug in TYPO3. See bugreport.