dongzi1959 2018-12-05 07:03
浏览 98
已采纳

SQLSTATE [42S22]:未找到列:1054 Laravel中“字段列表”中的未知列“会话”

I am getting a strange error! I did not create any field named 'session' in database and there is no such field in model named 'session'. I used SoftDeletes() in the model but whenever I am trying to insert data I get an error with this message:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'session' in 'field list'

Here is the model:

<?php 

namespace App\Models;

use Illuminate\Database\Eloquent\Model;

use Illuminate\Database\Eloquent\SoftDeletes;

class Article extends Model
{
use SoftDeletes;

protected $fillable = [
    'user_id', 'headline', 'summary', 'body', 'status', 'cover_image', 'image_caption', 'image_credit', 'cover_video', 'video_caption', 'video_credit', 'category', 'meta', 'tags',
]; 

protected $dates = ['deleted_at'];

public function user()
{
    return $this->belongsTo('App\User');
}

}

Here is the database: enter image description here

Here is the controller:

public function store(Request $request)
{
    $article = new Article;
    $article->user_id = $request->user_id;   
    $article->headline = $request->headline;  
    $article->summary = $request->summary;   
    $article->body = $request->body;   
    $article->status = $request->status;   
    $article->session = $request->session;
    $article->category = $request->category;
    $article->meta = $request->meta;
    $article->tags = $request->tags;


    //dd($request->session());


    $article->save();

    return back()->with('success', 'Article Successfully Added!');
}

How can I solve this problem?

  • 写回答

2条回答 默认 最新

  • dongzhi7641 2018-12-05 07:23
    关注

    hi because in your store function you do this

     $article->session = $request->session;
    

    delete this and it s work

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥100 求数学坐标画圆以及直线的算法
  • ¥100 c语言,请帮蒟蒻写一个题的范例作参考
  • ¥15 名为“Product”的列已属于此 DataTable
  • ¥15 安卓adb backup备份应用数据失败
  • ¥15 eclipse运行项目时遇到的问题
  • ¥15 关于#c##的问题:最近需要用CAT工具Trados进行一些开发
  • ¥15 南大pa1 小游戏没有界面,并且报了如下错误,尝试过换显卡驱动,但是好像不行
  • ¥15 自己瞎改改,结果现在又运行不了了
  • ¥15 链式存储应该如何解决
  • ¥15 没有证书,nginx怎么反向代理到只能接受https的公网网站