Project

General

Profile

Actions

Bug #69660

closed

Epic #64459: Make TYPO3 run on PostgreSQL

Invalid SQL query originating in BackendUtility::readPageAccess(1, 31)

Added by Morton Jonuschat about 9 years ago. Updated about 6 years ago.

Status:
Closed
Priority:
Should have
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2015-09-11
Due date:
% Done:

100%

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

Description

BackendUtility::readPageAccess(1, 31) results in the following SELECT call:

DatabaseConnection::exec_SELECTquery("*", "pages", "uid=1 AND pages.deleted=0 AND 31", "", "", "1")

The error happens somewhere between in the readPageAccess, the following call is possibly wrong:

BackendUtility::getRecord("pages", 1, "*", " AND 31")

Database: PostgreSQL 9.4.4
TYPO3 7.5-dev


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #67077: PHP error on page creationClosedMorton Jonuschat2015-05-21

Actions
Actions #1

Updated by Morton Jonuschat about 9 years ago

  • Description updated (diff)
Actions #2

Updated by Morton Jonuschat about 9 years ago

  • Status changed from New to In Progress

The actual origin of the wrong query seems to be further up the call chain...

Actions #3

Updated by Gerrit Code Review about 9 years ago

  • Status changed from In Progress 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 http://review.typo3.org/43186

Actions #4

Updated by Gerrit Code Review about 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 http://review.typo3.org/43186

Actions #5

Updated by Morton Jonuschat about 9 years ago

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

Updated by Morton Jonuschat about 9 years ago

  • Parent task set to #64459
Actions #7

Updated by Benni Mack about 6 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF