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
 #1

Updated by Peter Kraume almost 3 years ago

  • Subject changed from Translation of page content fails with SQL Error to Postgres: Translation of page content fails with SQL Error
  • Category set to Database API (Doctrine DBAL)
  • Tags set to acc
Actions
Copy link
 #2

Updated by Peter Kraume almost 3 years ago

  • Tags deleted (acc)
Actions
Copy link
 #3

Updated by Gerald Z almost 3 years ago

I also did a fresh install on debian 11, with php7.4 and postgresql, and the same error occours.
So I guess it has nothing to do with the installation on OpenBSD.

Actions
Copy link
 #4

Updated by Stefan Bürk almost 3 years ago

  • Assignee set to Stefan Bürk
Actions
Copy link
 #5

Updated by Stefan Bürk almost 3 years ago

Thanks for reporting this issue, I have taken some time to test this through different constellation. So to say,
issue confirmed. Will dive deeper into this, but can take some time.

I can confirm the reported error:

TYPO3 v11-dev PHP7.4 Postgres 13 Styleguide + Introduction Package ( Linux Mint 20/Ubuntu + DEBIAN 11) confirmed
TYPO3 v11-dev PHP8.0 Postgres 13 Styleguide + Introduction Package ( Linux Mint 20/Ubuntu + DEBIAN 11) confirmed
TYPO3 v11-dev PHP8.1 Postgres 13 Styleguide + Introduction Package ( Linux Mint 20/Ubuntu + DEBIAN 11) confirmed
TYPO3 v12-dev PHP8.1 Postgres 13 Styleguide ( Linux Mint 20/Ubuntu + DEBIAN 11) confirmed
TYPO3 v12-dev PHP8.1 Postgres 10 Styleguide ( Linux Mint 20/Ubuntu + DEBIAN 11) confirmed

Tested but reported error not occuring:

TYPO3 v10-dev PHP7.4 Postgres 13 Introduction Package ( Linux Mint 20/Ubuntu + DEBIAN 11) not confirmed

Some minor "details":

  • v12 shows the error only on creating a new page translation, not on saving a translated content element.
    v11 showed that error on page translation and saving an edited content element which had been translated
    (connected mode)
  • occurs with Styleguide OR Introduction packages (tested in clean reruns, not in a mixed installation)
  • v11 styleguide creating frontend page records throws an database exception / error. This should have been
    fixed in sytleguide already (sidefinding -> check if fix was backported or if release is missing)
  • seems not related to Postgres v13, as at least on main Postgres v10 shows same error

attached error message:

Actions
Copy link
 #6

Updated by Gerrit Code Review almost 3 years ago

  • Status changed from Accepted to Under Review

Patch set 2 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/73636

Actions
Copy link
 #7

Updated by Gerrit Code Review almost 3 years ago

Patch set 3 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/73636

Actions
Copy link
 #8

Updated by Gerrit Code Review almost 3 years ago

Patch set 4 for branch main of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/73636

Actions
Copy link
 #9

Updated by Gerrit Code Review over 2 years ago

Patch set 1 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/73551

Actions
Copy link
 #10

Updated by Stefan Bürk over 2 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions
Copy link
 #11

Updated by Gerrit Code Review over 2 years ago

  • Status changed from Resolved to Under Review

Patch set 2 for branch 11.5 of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at https://review.typo3.org/c/Packages/TYPO3.CMS/+/73551

Actions
Copy link
 #12

Updated by Stefan Bürk over 2 years ago

  • Status changed from Under Review to Resolved
Actions
Copy link
 #13

Updated by Gerald Z over 2 years ago

I just tried 11.5.7 on two installations and everything looks fine now.
Thanks!

Actions
Copy link
 #14

Updated by Benni Mack about 2 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF