Problem Duplicate entry in assignRole

[BehroozBvk]

Hello
I have added two fields organization_id,organizer_id to the model_has_roles table And I want a user to have different roles in different organizations.
This means that a user can play the role of manager in both organization a and organization b.

But the problem is that when assigning a new role, I encounter the following error:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '2-1-App\Models\User' for key 'model_has_roles.PRIMARY' (SQL: insert into model_has_roles (role_id, model_id, model_type, organization_id) values (2, 1, App\Models\User, 3))

Thank you for your guidance on how to create a role-based system for different organizations using this package.

[erikn69]

You have to change the composite primary key, adding your new ids

laravel-permission/database/migrations/create_permission_tables.php.stub

Lines 69 to 70 in 7711587

	$table->primary(['role_id', $columnNames['model_morph_key'], 'model_type'],
	'model_has_roles_role_model_type_primary');

$table->primary(['role_id', $columnNames['model_morph_key'], 'model_type','organization_id','organizer_id','others....'], 
        'model_has_roles_role_model_type_primary'); 

Also, #1782 can help you

[BehroozBvk]

Thanks.solved.