Base table or view not found: 1146 Table 'role_user' doesn't exist

Question

Base table or view not found: 1146 Table 'role_user' doesn't exist

mohitbabel opened this issue 4 months ago · 6 comments

I am using spatie version 5. Whenever I assign new role using this function $user->assignRole('Admin') but I am getting an exception that

Base table or view not found: 1146 Table 'cryo_renewal.role_user' doesn't exist (Connection: mysql, SQL: delete from role_user where role_user.user_id = 1) in spatie laravel problem. What is that error can anyone explain.

Answer 1 · 2024-01-09T14:06:59.000Z

#1507 (comment)
https://spatie.be/laravel-permission/prerequisites#content-must-not-have-a-role-or-roles-property

Answer 2 · 2024-01-10T20:32:51.000Z

https://spatie.be/docs/laravel-permission/v6/prerequisites#content-must-not-have-a-role-or-roles-property-nor-a-roles-method

Answer 3 · 2024-01-30T14:09:09.000Z

php artisan vendor:publish --provider="Spatie\Permission\PermissionServiceProvider"
run this command it should work

Answer 4 · 2024-04-05T21:40:37.000Z

Hello everyone!!!. I have problem with laravel permission on migrating , how you can see in the picture

I need your help friends