Bug #71979
closedSQL Error in "Page" view using TYPO3 7 LTS and PostgreSQL
100%
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.
Updated by Morton Jonuschat almost 9 years ago
- Status changed from New to Accepted
- Target version set to Candidate for patchlevel
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
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
Updated by Morton Jonuschat almost 9 years ago
- Status changed from Under Review to Resolved
- % Done changed from 0 to 100
Applied in changeset 8af444f2a97bed1cc2973e120439a0b03e8f924c.