Notifications Table not found
Just upgraded from v2 to v3 and all is good except for this message i am getting.
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ncm.notifications' doesn't exist
https://flareapp.io/share/o7AeD3x7
Flare
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ncm.notifications' doesn't exist (SQL: select * from
notifications where notifications.notifiable_type = App\Models\User and notifications.notifiable_id = 3 and notifications.notifiable_id is not null and json_unquote(json_extract(data, '$."format"')) = filament order by ...Solution:Jump to solution
@jacquesvanwyk
AdminPanelProvider.php has databaseNotifications() method. So if you want to have database notifications, you should keep it and check official Laravel documentation to migrate notification table: https://laravel.com/docs/10.x/notifications#database-prerequisites
php artisan notifications:table
php artisan migrate...2 Replies
Solution
@jacquesvanwyk
AdminPanelProvider.php has databaseNotifications() method. So if you want to have database notifications, you should keep it and check official Laravel documentation to migrate notification table: https://laravel.com/docs/10.x/notifications#database-prerequisites
php artisan notifications:table
php artisan migrateThank you!!!