PostgreSQL ERROR: operator does not exist: boolean = integer

cartalyst / sentinel

A framework agnostic authentication & authorization system.

BSD 3-Clause "New" or "Revised" License

1.51k stars 238 forks source link

PostgreSQL ERROR: operator does not exist: boolean = integer #557

Closed Aslam97 closed 3 years ago

Aslam97 commented 3 years ago

OS and Version: Ubuntu 20.4
PHP Version: 7.4
Sentinel Version: 2

I am using postgres.

Sentinel::authenticate([], remember) gives error boleean = integer, seem like laravel transfrom true to 1 which produce error boolean = integer

Screenshot

I was able to fix this issue by changing this line inside Cartalyst\Sentinel\Activations\ActivationRepositoryInterface from

->where('completed', true)

->where('completed', 'true')

brunogaspar commented 3 years ago

Hello

This seems to be a bug on Eloquent itself, i think.

Aslam97 commented 3 years ago

I couldn't find any solutions for this without changing the vendor file. but for temporary solution I will just use VCS repository. btw great package!

brunogaspar commented 3 years ago

Not sure if this is extremely relevant for your case https://github.com/laravel/framework/issues/37247