Project

General

Profile

Actions
Copy link

Bug #71979

closed

SQL Error in "Page" view using TYPO3 7 LTS and PostgreSQL

Added by Lars Peter Søndergaard over 8 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Morton Jonuschat
Category:
Database API (Doctrine DBAL)
Target version:
Candidate for patchlevel
Start date:
2015-11-30
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.5
Tags:
postgresql
Complexity:
Is Regression:
No
Sprint Focus:

Description

On a completely fresh installation of TYPO3 7 LTS (7.6.0) I get the following error after creating a single page and trying to access it via the "Page" view in backend:

ADOdb could not run this query: SELECT "uid" FROM "sys_category" WHERE FIND_IN_SET('0', CAST("parent" AS CHAR)) != 0 OR = ''

As you can see, the OR statement at the end looks odd.
After enabling Debug settings the traceback says, it called exec_SELECTquery with following arguments:

TYPO3\CMS\Dbal\Database\DatabaseConnection::exec_SELECTquery("uid", "sys_category", "FIND_IN_SET('0',parent) OR CAST(parent AS CHAR) = ''", "", "", "")

After tracing it a bit, the incorrect query seems to be built by \TYPO3\CMS\Dbal\Database\SqlCompilers\Adodb::compileWhereClause But I didn't bother looking any further.

#67172 and related issues don't look like the same issue, but might be related.

Actions
Copy link

Also available in: Atom PDF