Project

General

Profile

Actions

Bug #98561

closed

Styleguide updated menu dataprocessor do not work with PostgresSQL

Added by Stefan Bürk about 2 years ago. Updated almost 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
-
Target version:
-
Start date:
2022-10-09
Due date:
% Done:

100%

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

Description

Using PostgresSQL backend leads to error in menu processing, which can
be seen using the ext:styleguide extension frontend demo pages.

The background of this issue is, the PostgreSQL seems to lowercase fieldnames
if they are not properly quoted, and than cannot find them if the field is in
upper case, like for example pages.SYS_LASTCHANGED.

Due the nature of the system desing and historical reasons, sql parts are manually
build and injected in QueryBuilder instances, which prevents proper quoting of
identifiers and values - leading to this issue.


Files

clipboard-202210092324-6atuj.png (32.4 KB) clipboard-202210092324-6atuj.png Stefan Bürk, 2022-10-09 21:24
Actions #1

Updated by Gerrit Code Review about 2 years ago

  • Status changed from Accepted to Under Review

Patch set 1 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/+/76035

Actions #2

Updated by Gerrit Code Review about 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/+/76054

Actions #3

Updated by Stefan Bürk about 2 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions #4

Updated by Benni Mack almost 2 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF