syncPermissions In Spatie showing error

@Armani Still showing

There is no permission named f6bc4ae5-f08c-4c9c-8d2b-c7ced151a1dd for guard web.

Instead of Spatie which method your are using for manage roles and permissions

@radhamadhavamhostel I use mine, it is easy to implement same thing but this package is popular and very good. I think you have to debug your code before judging this package. for example use dd() function to see you get the right data from server:

$user = User::create([
            'fname' => 'Super', 
            'lname' => 'Admin', 
            'email' => '[email protected]',
            'username' => 'Superadmin',
            'password' => Hash::make('mypassword'),
            'user_type' => 'admin'
        ]);
    
        $role = Role::create(['name' => 'admin']);
     
        $permissions = Permission::pluck('id'); 

		dd($permissions);
   
        $role->syncPermissions($permissions);
     
        $user->assignRole([$role->id]);

and check it syncPermissions method needs collection or array as parameter. I think you can do it like this:

$permissions = Permission::pluck('name'); 

or this:

$permissions = Permission::pluck('name')->toArray(); 

@Armani Yes permission id are getting

  0 => "f6bc4ae5-f08c-4c9c-8d2b-c7ced151a1dd"
  1 => "6dfc266d-bdfa-4955-8a14-6eaed784e6a0"
  2 => "d9ae80a1-25af-4fae-bfbe-511148f69d9b"
  3 => "6479aef2-aeee-4e06-bd0a-cae32530ef79"
  4 => "d6607835-9ab5-46fe-9e1a-fa621d8e4a63"
  5 => "aa4c7532-607b-4e87-bda3-801328ecaea5"
  6 => "e9e6be77-00d8-483a-9745-19e986567465"
  7 => "d89048a9-f025-4a87-b4ff-80fe85caa176"]

Should we select name along with id

@radhamadhavamhostel Check this like

$all_roles_in_database = Role::all()->pluck('name');

you can use it like this:

$permissions = Permission::all()->pluck('name'); 

you need the permission names not id

@Armani No need to select roles , This is a seeder and we are creating a new role named 'admin' here and it is inserting into Db

$role = Role::create(['name' => 'admin']);
     
        $permissions = DB::table('permissions')->pluck('id')->toArray(); dd($permissions);
   
        $role->syncPermissions($permissions);
     
        $user->assignRole([$role->id]);

@radhamadhavamhostel it was an example just use it like this:

$user = User::create([
            'fname' => 'Super', 
            'lname' => 'Admin', 
            'email' => '[email protected]',
            'username' => 'Superadmin',
            'password' => Hash::make('mypassword'),
            'user_type' => 'admin'
        ]);
    
        $role = Role::create(['name' => 'admin']);
     
        $permissions = Permission::pluck('name'); 
   
        $role->syncPermissions($permissions);
     
        $user->assignRole([$role->id]);

@Armani When Pluck name instead of id. getting error

SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "role_id" of relation "role_has_permissions" violates not-null constraint DETAIL: Failing row contains (f6bc4ae5-f08c-4c9c-8d2b-c7ced151a1dd, null). (Connection: pgsql, SQL: insert into "role_has_permissions" ("permission_id", "role_id") values (f6bc4ae5-f08c-4c9c-8d2b-c7ced151a1dd, ?))

Table: role_has_permissions
Column	                Type
permission_id	uuid	
role_id	                  uuid ```

@radhamadhavamhostel because you don't have name column. please read this because you are using uuid

@Armani This is what I have followed. Table : roles_has_perm,ission have only 2 fileds.

Schema::create($tableNames['role_has_permissions'], function (Blueprint $table) use ($tableNames) {
       $table->uuid('permission_id');
       $table->uuid('role_id');

Above one is from documentation.

When we pluck 'name' from permissions role_is is missing.

null value in column "role_id" of relation "role_has_permissions" violates not-null constraint DETAIL: Failing row contains (f6bc4ae5-f08c-4c9c-8d2b-c7ced151a1dd, null).

@radhamadhavamhostel do you know how to use tinker? if you know try to use that to get a better understanding what is going on. run your code line by line to see the issue.

$user = User::create([
            'fname' => 'Super', 
            'lname' => 'Admin', 
            'email' => '[email protected]',
            'username' => 'Superadmin',
            'password' => Hash::make('mypassword'),
            'user_type' => 'admin'
        ]);
    
        $role = Role::create(['name' => 'admin']);
     
        $permissions = Permission::pluck('id'); 
   
        $role->syncPermissions($permissions);
     
        $user->assignRole([$role->id]);