Project

General

Profile

Actions

Bug #71979

closed

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

Added by Lars Peter Søndergaard almost 9 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
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 #1

Updated by Morton Jonuschat almost 9 years ago

  • Status changed from New to Accepted
  • Target version set to Candidate for patchlevel
Actions #2

Updated by Gerrit Code Review almost 9 years ago

  • Status changed from Accepted to Under Review

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

Actions #3

Updated by Gerrit Code Review almost 9 years ago

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

Actions #4

Updated by Morton Jonuschat almost 9 years ago

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

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF