You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello, I need to get all permission of a role, I'm using $role->permission I get this error message
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_db_1.permission_role' doesn't exist (Connection: mysql, SQL: select permissions.*, permission_role.role_id as pivot_role_id, permission_role.permission_id as pivot_permission_id from permissions inner join permission_role on permissions.id = permission_role.permission_id where permission_role.role_id = 3)
Everything seems to work except this command.
I successfully seeded roles permissions and users , clearing cache before and after as suggested.
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hello, I need to get all permission of a role, I'm using
$role->permission
I get this error messageSQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_db_1.permission_role' doesn't exist (Connection: mysql, SQL: select
permissions
.*,permission_role
.role_id
aspivot_role_id
,permission_role
.permission_id
aspivot_permission_id
frompermissions
inner joinpermission_role
onpermissions
.id
=permission_role
.permission_id
wherepermission_role
.role_id
= 3)Everything seems to work except this command.
I successfully seeded roles permissions and users , clearing cache before and after as suggested.
Any idea? Thanks!
Laravel Framework: 10.48.14
laravel/jetstream: 4.3.1
spatie/laravel-permission: 6.9.0
Mysql: innodb
Beta Was this translation helpful? Give feedback.
All reactions