SQLSTATE[42S22]：找不到列： 1054未知列'id'in'where cluse'

Question

我得到以下错误SQLSTATE[42S22]：未找到列：1054“where子句”中的未知列“id”（SQL:选择count（*）作为来自类别的聚合，其中name=Men和id

Category.php

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Category extends Model
{
        protected $fillable = ['name'];

        protected $primaryKey = 'category_id';

    public function products()
    {
        return $this->hasMany(Product::class);
    }
}

CategoryController.php

public function edit($id)
{
    $category = Category::findOrFail($id);
    return view('admin.category.edit', compact('category'));
}

/**
 * Update the specified resource in storage.
 *
 * @param  \Illuminate\Http\Request  $request
 * @param  int  $id
 * @return \Illuminate\Http\Response
 */
public function update(Request $request, $id)
{
    $category = Category::findOrFail($id);
    $this->validate($request, [
        'name' => 'required|string|max:255|unique:categories,name,'. $category->category_id
    ]);

    $category->update($request->all());
    Flash::success('Kategori berhasil diubah');
    return redirect()->route('category.index');
}




Answer 1

您将主键定义为category_id，然后使用

category_id

而不是

身份证件

在查询中

SQL: select count(*) as aggregate from categories where name = Men and id <> 1