#75912PostgreSQL: Argument of AND must be type boolean, not type integer
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