照明\数据库\查询异常SQLSTATE[23000]：完整性约束违反： 19非空约束失败

Question

我刚接触laravel，尝试存储数据，但不断出现以下错误：

   Illuminate\Database\QueryException
   SQLSTATE[23000]: Integrity constraint violation: 19 NOT NULL constraint failed: courses.user_id (SQL: insert into "courses" ("title", "image" "updated_at", "created_at") values (new title, ?, 2020-06-06 23:02:53, 2020-06-06 23:02:53))

在控制器中的存储方法：

   public function store(StoreCourseRequest $request) {
      $addCourse = Course::create($request->all());

       foreach ($request->input('course_images', []) as $file) {
          $addCourse->addMedia(storage_path('tmp/uploads/' . $file))->toMediaCollection('course_images');
          }

      if ($media = $request->input('ck-media', false)) {
          Media::whereIn('id', $media)->update(['model_id' => $addCourse->id]);
          }
      return redirect('/course');
    }

店铺请求：

   class StoreCourseRequest extends FormRequest
     {
     public function authorize()
      {
         return true;
      }

    public function rules()
     {
       return [
          'title'       => [
              'required',
           ], 
      ];
     }
 }

数据库：

 Schema::create('courses', function (Blueprint $table) {
        $table->id();
        $table->unsignedBigInteger('user_id');
        $table->string('title');
        $table->string('image')->nullable();
        $table->timestamps();
        $table->index('user_id');
        $table->softDeletes();
    });
}

错误指向控制器：

   $addCourse = Course::create($request->all());

但不确定怎么解决。请帮忙。提前谢谢。

Answer 1

将user\u id列设为外键，该外键引用用户表上的id列，如果不必为课程分配用户，则将其设为空

$table->unsignedBigInteger('user_id')->nullable();
$table->foreign('user_id')->references('id')->on('users');

您还需要更改索引，因为它可能为null

<罢工> $表-

• 要求用户登录以便创建课程

public function authorize()
{
  return auth()->check();
}

• 添加auth（）-

$course = $request->validated();
$course['user_id'] = auth()->id();
$addCourse = Course::create($request->all());