#71979SQL Error in "Page" view using TYPO3 7 LTS and PostgreSQL
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.
- and related issues don’t look like the same issue, but might be related.