SQLSTATE[HY000]: General error: 1364 Field 'user_id' doesn't have a default value (SQL

Question

I am trying to save my data against my userid but I am getting this error.

My code is:

        \App\Keys::create([
         $user = \Illuminate\Support\Facades\Auth::user(),
        'user_id' => $user,
        'accessTokenKey' => $accessTokenKey,
        'accessTokenSecret' => $accessTokenSecret
    ]);
    return 'You have successfully granted';

I am getting error user_id does not have a default value and when I passed Auth::user()->id it says trying to get properties of non-object id.

Any help would be appreciated!

Answer 1

That's because you do not have any authenticated user

if(Auth::check()){
        \App\Keys::create([
          $user = \Illuminate\Support\Facades\Auth::user(),
          'user_id' => Auth::id(),
          'accessTokenKey' => $accessTokenKey,
          'accessTokenSecret' => $accessTokenSecret
      ]);
}else{
    //logged in the user or
    return 'User is not logged in ';
}