php - 如何解决 "SQLSTATE[42S22]: Column not found"？

Question

我将我的“id”重命名为“teams_id”

现在当我更新时它显示以下错误

我也尝试在我的模型中使用 declare it 但它不起作用

这是我的更新代码:

{
     $this->validate(request(), [
        'coach' => 'required',
       'team' => "required|unique:teams,team,$id",
       'manager' => "required|unique:teams,manager,$id",
    ]);

    $team=Team::findorfail($id);

    $team->team = $request->input('team');
    $team->coach = $request->input('coach');
    $team->manager = $request->input('manager');

    $team->save();
    Toastr::success('Team info was updated','Success!');
    return redirect('/teams');

}

Answer 1

验证失败。 The unique validation rule正在检查 id 列。它不使用模型主键。相反，将您的验证规则更改为以下内容:

    $this->validate(request(), [
       'coach' => 'required',
       'team' => "required|unique:teams,team,$id,teams_id",
       'manager' => "required|unique:teams,manager,$id",
    ]);