"General error: 1364 Field 'user_id' doesn't have a default value" Laravel

Question

In my resource controller, in the store method, I do this:

public function store(Request $request)
    {
      $post = $request->all();
      $post['user_id'] = Auth::user()->id;

      Post::create($post);

        return redirect()->route('index');
    }

Why am I getting the error: General error: 1364 Field 'user_id' doesn't have a default value?

is your user actually logged in? return Auth::user()->id and see whats inside — milad hedayatpoor
– milad hedayatpoor, Commented Jan 20, 2021 at 7:18
Yes, he is logged in. The problem was that I hadn't added the user_id to the protected $fillable. — Hi_TecH
– Hi_TecH, Commented Jan 20, 2021 at 7:20

OMR · Accepted Answer · 2021-01-20 07:10:25Z

1

you should add 'user_id' to the $fillable attribute in your Post model to support mass assignment

class Postextends Model

{
protected $fillable=['user_id']; // not only user_id but also all the fill able columns
}

answered Jan 20, 2021 at 7:10

OMR

12.3k5 gold badges26 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hi_TecH Over a year ago

Really! Thank you! For some reason I thought that we need to add to $fillable only those fields that we get from input.

Irshad Khan · Accepted Answer · 2021-01-20 07:40:11Z

0

you shuold use user_id in fillable like this,

class Postextends Model
{
    protected $fillable=['user_id'];
}

And also you can set $guarded property as,

class Postextends Model
{
    protected $guarded=[];
}

Then you not need to set propertise filable.

Note: While $fillable serves as a “white list” of attributes that should be mass assignable, you may also choose to use $guarded. The $guarded property should contain an array of attributes that you do not want to be mass assignable. All other attributes not in the array will be mass assignable. So, $guarded functions like a “black list”. Of course, you should use either $fillable or $guarded — not both.

answered Jan 20, 2021 at 7:40

Irshad Khan

4325 silver badges13 bronze badges

Collectives™ on Stack Overflow

"General error: 1364 Field 'user_id' doesn't have a default value" Laravel

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related