Issue Bug Closed

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

Jan Pascal Maas 04/25/16, 17:24 updated 10/11/22, 03:14

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

Reviews 2