Project

General

Profile

Actions
Copy link

Bug #75912

closed

PostgreSQL: Argument of AND must be type boolean, not type integer

Added by Jan Pascal Maas over 8 years ago. Updated about 2 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Morton Jonuschat
Category:
Database API (Doctrine DBAL)
Target version:
Candidate for patchlevel
Start date:
2016-04-25
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
9
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Yes
Sprint Focus:

Description

Just ran into this issue with error #1421053336 with current LTS version (7.6.5) and this query:

SELECT "uid" FROM "pages" WHERE "pid" = 7 AND "pages"."deleted" = 0 AND 1

Happened directly after I inserted an record onto my page. Postgres log tells me:

ERROR: argument of AND must be type boolean, not type integer at character 77.

Looks like this is caused by line 1535 in the QueryGenerator:

$res = $databaseConnection->exec_SELECTquery('uid', 'pages', 'pid=' . $id . ' ' . BackendUtility::deleteClause('pages') . ' AND ' . $perms_clause);

Quick and dirty fix: remove the "AND $perms_clause" part. But I believe that the issue lies in the deep as it might cause side effects.

Best regards

Related issues 1 (0 open — 1 closed)

Related to TYPO3 Core - Bug #102397: PostgreSQL: Argument of AND must be type boolean, not type integerClosed2023-11-17

Actions
Actions
Copy link

Also available in: Atom PDF