Laravel-permission: Integrity constraint violation: 1048 Column 'model_id' cannot be null

[musman92]

my package details are
"laravel/framework": "5.6.*",
"spatie/laravel-permission": "^2.19"

when i assign a role
$user->syncRoles(['role']);
$user->assignRole('role');

IlluminateDatabaseQueryException : SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'model_id' cannot be null (SQL: insert into model_has_roles (model_id, model_type, role_id) values (, AppUser, 2))

thanks in advance

[drbyte]

In your Eloquent model for App\User, what is the column-type for your id field?

This package expects it to match the model_id type of the model_has_roles table.

[musman92]

id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
how I match model_id?

[drbyte]

What is the value for model_morph_key in your config/permission.php?

https://github.com/spatie/laravel-permission/blob/master/config/permission.php#L83

[musman92]

the value is
'model_morph_key' => 'model_id',
do i need to change it to "id"? right?

[drbyte]

No, it should be model_id.

This is puzzling. I think you've changed something in your App\User model that's causing it.
It's hard to troubleshoot this without seeing your code.

[musman92]

below is the my user model`

namespace App;

use IlluminateNotificationsNotifiable;
use IlluminateFoundationAuthUser as Authenticatable;
use SpatiePermissionTraitsHasRoles;

class User extends Authenticatable
{
use Notifiable, HasRoles;

/**

• The attributes that are mass assignable.
  *
• @var array
  */
  protected $fillable = [
  'name', 'email', 'password',
  ];

/**

• The attributes that should be hidden for arrays.
  *
• @var array
  */
  protected $hidden = [
  'password', 'remember_token',
  ];

}
`

[drbyte]

Can you share the code where you're trying to assign and sync roles to users?

[musman92]

$user = new \App\User(); $user->name = 'dev'; $user->email = ''; $user->password = bcrypt(''); $user->syncRoles(['role']); $user->assignRole('role'); $user->save();

its in seeds
this is how i create roles in seed
$role = Role::create(['name' => 'admin']);

[drbyte]

You can't sync something to a model that hasn't been persisted yet.

You must call $user->save() before you sync or assign.

[musman92]

@drbyte thank you it works. but it should send a proper message. thank you anyway

[IgorRadovic]

Thank you @drbyte you saved my day.
You are my hero :D

[brenoassp]

Hello,
I have a similar problem, but $user->save(); didn't fix the problem for me.
Can I describe it here or need to create a new issue?

[drbyte]

@brenoassp Please open a new issue for it, containing as much information as possible to recreate your problem with a fresh Laravel install.