SQLSTATE[42S22]：找不到列： 1054 Laravel 5.4中字段列表中的未知列标题[重复]

Question

谁能帮帮我我下面的数据插入代码是什么问题？

SQLSTATE[42S22]：找不到列： 1054字段列表中的未知列标题（SQL：插入到gallery_categories（标题，描述，category_id，图像，updated_at，created_at）值（测试标题，测试细节，1，1512370315.jpg，2017-12-04 06:51:55, 2017-12-04 06:51:55))

我有两个模型。其中一个是GalleryModel，另一个是Gallery类别模型。当我使用dd（$请求-

注：我是新来的。

画廊模型

class GalleryModel extends Model
    {
        protected $table      = 'galleries';
        protected $primaryKey = 'id';
        protected $fillable   = ['title', 'description', 'image', 'category_id'];
    }

这是我的GalleryCategoryModel模型

class GalleryCategoryModel extends Model
    {
        protected $table      = 'gallery_categories';
        protected $primaryKey = 'id';
        protected $fillable   = ['name'];

    }

我的控制器GalleriesController

public function create()
    {
        $categories = GalleryCategoryModel::all();
        return view('pages.backend.galleries.create')->withCategories($categories);
    }


public function store(StoreGalleryRequest $request)
    {
        $gallery = new GalleryCategoryModel;

        $gallery->title       = $request->title;
        $gallery->description = $request->description;
        $gallery->category_id = $request->category_id;

        if($request->hasFile('gallery_image')){
            $image = $request->file('gallery_image');
            $filename = time() . '.' .$image->getClientOriginalExtension();
            $location = public_path('assets/backend/images/' .$filename);
            Image::make($image)->resize(500, 350)->save($location);

            $gallery->image = $filename;
        }
        $gallery->save();
        Session::flash('success', "Data has been insert success");
        return redirect()->route('galleries.index', $gallery->id);
    }

这是我的HTML代码

<div class="br-section-wrapper">
      <h6 class="tx-gray-800 tx-uppercase tx-bold tx-14 mg-b-10">Create New Gallery</h6>
      {!! Form::open(array('route' => 'galleries.store', 'data-parsley-validate' => '', 'files' => true)) !!}
  {{ csrf_field() }}
    <div class="row">
      <div class="col-md-12">
        <div class="row">
          <div class="col-md-4">
            <div class="form-group margin-top15">
              <label for="title">Gallery Title: <span class="tx-danger">*</span></label>
              <input type="text" name="title" id="title" class="form-control" required>
            </div>
          </div>

           <div class="col-md-4">
             <div class="form-group margin-top15">
              <label for="category_id">Select Category: <span class="tx-danger">*</span></label>
              <select class="form-control select2 width-100" name="category_id" id="category_id" data-placeholder="Choose one" data-parsley-class-handler="#slWrapper" data-parsley-errors-container="#slErrorContainer" required>
                  <option label="Choose one"></option>
                  @foreach($categories as $category)
                    <option value="{{ $category->id }}">{{ $category->name }}</option>
                  @endforeach
                </select>
            </div>
          </div>
          <div class="col-md-4">
             <div class="form-group margin-top15">
              <label for="gallery_image">Gallery Image: <span class="tx-danger">*</span></label>
              <input type="file" name="gallery_image" id="gallery_image" class="form-control" required>
            </div>
          </div>
        </div>

        <div class="row">
          <div class="col-md-12">
            <label for="description">Description: <span class="tx-danger">*</span></label>
            <textarea name="description" id="description" class="form-control"></textarea>
          </div>
        </div>

        <div class="form-group margin-top15">
          <button type="submit" class="btn btn-info tx-11 pd-y-12 tx-uppercase tx-spacing-2">Create Gallery</button>
        </div>
      </div>
    </div>
  {!! Form::close() !!}
</div>




Answer 1

这是因为gallery_categories表中没有名为title的列。