Laravel：尝试上传多张图片时出错

Question

I'm trying to allow a registered user to create a post and in that post, they should be able to upload multiple images. The image path should then be stored in the images table with the post_id. Indicating which post the image is for. However, when I click the submit button I am presented with this error:

 Illuminate \ Database \ QueryException (HY000)
SQLSTATE[HY000]: General error: 1364 Field 'cover_image' doesn't have a default value (SQL: insert into `posts` (`title`, `type`, `subtype`, `body`, `user_id`, `updated_at`, `created_at`) values (caged football, sport, Football, this is a description, 1, 2018-04-23 17:14:06, 2018-04-23 17:14:06))

Here is my PostController method:

public function postCreatePost(Request $request){
    $this->validate($request, [
        'title' => 'required',
        'type' => 'required',
        'subtype' => 'required',
        'body' => 'required',
        'cover_image' => 'required'
    ]);

    $post = new Post(); 
    $post->title = $request['title'];
    $post->type = $request['type'];
    $post->subtype = $request['subtype'];
    $post->body = $request['body'];



    $message = 'There was an error';
    if($request->user()->posts($post)->save($post)){

        if($request->hasFile('cover_image')){
            foreach($request->file('cover_image') as $file){
                $filenameWithExt = $file->getClientOriginalName();
                $filename = pathinfo($filenameWithExt, PATHINFO_FILENAME);
                $extension = $file->getClientOriginalExtension();
                $fileNameToStore = $filename . '_' . time() . '.' . $extension; 
                $path = $file->storeAs('public/cover_images', $fileNameToStore);
                $image = new Image();
                $image->cover_image = $fileNameToStore;
                $image->post_id = $post->id;
                $image->save();
            }
        }

        $message = 'post successfully created';
    }

    return redirect()->route('dashboard')->with(['message' => $message]);
}

Here is my file form control:

<div class="form-group">
    <label for="cover_image">Upload Image</label>
    <input type="file" name="cover_image[]" class="form-control" id="cover_image" multiple>
</div>

Answer 1

do you have a field named cover_image in the posts table? I think it's a SQL error