telescope icon indicating copy to clipboard operation
telescope copied to clipboard

SQL error "operator does not exist: boolean = integer" with Postgres

Open allantatter opened this issue 5 months ago • 2 comments

Telescope Version

5.2.1

Laravel Version

11.21.0

PHP Version

8.2.21

Database Driver & Version

psql (PostgreSQL) 14.12 (Homebrew)

Description

Telescope views do not load with Postgres as a database driver. Tested with different Postges versions: 14 and 16.

SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer
LINE 1: ... "type" = 'command' and "should_display_on_index" = 1 order ...
                                                             ^
HINT:  No operator matches the given name and argument types. You might need to add explicit type casts. (Connection: pgsql, SQL: select * from "telescope_entries" where "type" = command and "should_display_on_index" = 1 order by "sequence" desc limit 50) {"userId":1,"exception":"[object] (Illuminate\\Database\\QueryException(code: 42883): SQLSTATE[42883]: Undefined function: 7 ERROR:  operator does not exist: boolean = integer

Steps To Reproduce

Fresh Laravel and Laravel Telescope install with Postgres.

allantatter avatar Aug 26 '24 13:08 allantatter