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

Also available in: Atom PDF