Issue Bug Closed

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

Lars Peter Søndergaard 11/30/15, 11:49 updated 10/02/18, 11:26

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.

  1. and related issues don’t look like the same issue, but might be related.

Reviews 1