filamentphp
Database Notifications Not work When i Use Postgres
Package
filament/filament
Package Version
v3.2.117
Laravel Version
v11.27.2
Livewire Version
No response
PHP Version
PHP 8.2
Problem description
Database Notifications Not work When i Use Postgres
I get this error:
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text ->> unknown LINE 1:
...ifications"."notifiable_id" is not null and "data"->>'format... ^ HINT: No operator matches the given name and argument
types. You might need to add explicit type casts. (Connection: pgsql, SQL: select * from "notifications" where
"notifications"."notifiable_type" = App\Models\User\User and "notifications"."notifiable_id" = 1 and
"notifications"."notifiable_id" is not null and "data"->>'format' = filament order by "created_at" desc limit 51 offset 0)
Expected behavior
Work Normal
Steps to reproduce
- Clone Repository https://github.com/mstfkhazaal/postgres_notification/
- Install Postgres or use via Laravel Sail (
sail up -d) - Run this codes
cp .env.example .env
php artisan key:generate
php artisan migrate:fresh --seed
- Got To http://localhost/admin/login
- Login: Email: [email protected] Password: password
Reproduction repository (issue will be closed if this is not valid)
https://github.com/mstfkhazaal/postgres_notification/
Relevant log output
SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: text ->> unknown LINE 1:
...ifications"."notifiable_id" is not null and "data"->>'format... ^ HINT: No operator matches the given name and argument
types. You might need to add explicit type casts. (Connection: pgsql, SQL: select * from "notifications" where
"notifications"."notifiable_type" = App\Models\User\User and "notifications"."notifiable_id" = 1 and
"notifications"."notifiable_id" is not null and "data"->>'format' = filament order by "created_at" desc limit 51 offset 0)
Donate 💰 to fund this issue
- You can donate funding to this issue. We receive the money once the issue is completed & confirmed by you.
- 100% of the funding will be distributed between the Filament core team to run all aspects of the project.
- Thank you in advance for helping us make maintenance sustainable!
Hi there. It seems your repo does not have the Notifications table migration, according to the docs:
https://filamentphp.com/docs/3.x/notifications/database-notifications#setting-up-the-notifications-database-table
Setting up the notifications database table
Before we start, make sure that the Laravel notifications table is added to your database:
Laravel 11 and higher
php artisan make:notifications-table
Laravel 10
php artisan notifications:table
If you're using PostgreSQL, make sure that the data column in the migration is using json(): $table->json('data').
If you're using UUIDs for your User model, make sure that your notifiable column is using uuidMorphs(): $table->uuidMorphs('notifiable').
I had the same problem and solved it by changing:
$table->text('data');
to
$table->json('data');
in notifications migration!
I also have this problem. my finding is the operator not working in postgres 9.2 or earlier, the operator '->>' maybe only work in postgre 9.3 and newer.
