'testspatie.role_user' doesn't exist

[tzriqat]

Hi guys,
I'm recieving this error when trying to assign roles to a user
Base table or view not found: 1146 Table 'testspatie.role_user' doesn't exist (SQL: delete from role_user where user_id = 18)

DD for user id is correct, and checkbox values are returning roles id are correct as well.

    public function roleAssignToUsers(Request $request)
    {
        $user = User::find($request->user_id);
        //dd($user);
        //dd($request->input('roles'));

        $inputroles = $request->input('roles');
        $user->syncRoles($inputroles);
        
        return view('cp.roles.index'));
    }

[drbyte]

It seems like you have other relations coded into your app and Laravel is self-determining a table-name for those relationships.
In short: your app's code conflicts with (is overriding) method names and relations and models that this package provides.

[tzriqat]

Yes indeed. thanks @drbyte It is resolved now.

[anuragyantra]

@drbyte
Can you please share, how you resolved this issue ?

[danti96]

como resolvió este problema

[mohitbabel]

Same problem faced please tell how to resolve that problem

[drbyte]

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