Base table or view not found: 1146 Table 'unified.role_has_permissions' doesn't exist
KennedyMatanda91 opened this issue · 0 comments
KennedyMatanda91 commented
When running migrations, i get this error. seems there is a table missing. Please help
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'unified.role_has_permissions' doesn't exist (SQL: select roles
.id
, roles
.id
as i
, roles
.name
as n
, roles
.guard_name
as g
, role_has_permissions
.permission_id
as pivot_permission_id
, role_has_permissions
.role_id
as pivot_role_id
from roles
inner join role_has_permissions
on roles
.id
= role_has_permissions
.role_id
where role_has_permissions
.permission_id
in (1))