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

0
votes

I'm trying to nake a simple to save a simple Product in my db but for a reason I don't understand, I get this error each time I try to save.

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

The thing is that I don't have any Files column and I don't want to have one.

Here's my migration file :

 public function up()
{
    Schema::create('formations', function (Blueprint $table) {
        $table->id();
        $table->string('name')->unique();
        $table->string('subtitle');
        $table->text('description');
        $table->integer('price');
        $table->integer('category_id');
        $table->integer('level_id');
        $table->timestamps();
    });
}

Here's my comtroller file :

public function store(Request $request)
{
    $request->validate(([
        'name' => 'required|string',
        'price' => 'required',
        'description' => 'required',
        'subtitle' => 'required',
        'category_id' => 'required',
        'level_id' => 'required',
    ]));

    Formation::create($request->all());

    return redirect()->route('admin.formations.index')->with('success','Formation ajoutée');
}

I'm confused!

Edit :

Here's the dd of $request

   array:8 [▼
  "_token" => "AGHU3QcTxNEd29ZVJ2mNM1lGMwAHDMqbIQEG4XxU"
  "name" => "Lh  lU"
  "price" => "125"
  "category_id" => "1"
  "level_id" => "2"
  "subtitle" => "Inke hune us kogru wuwuvat kerudowe anuzti gosvili dutoc wiv dufeaba job. Vaamcoj zodli kecuh wu ri hari sisalal gajesma ate ihloef egkes li zu. Ezfaaw uzared c ▶"
  "description" => "<p>gg<br></p>"
  "files" => null
]

It says "files" => null, but I don't know where that Files field comes from.

Nothing in my migrations and nothing in the db (PhpMyAdmin).

Really strange!

2
phplaravel
You got this, because on your blade you have a input field with name='files' ? – sta
Hey sta. That's the strange thing : I don't g=have any html imput with name"file" I checked like 10 times – user13652637
Check the output of dd($request->all()); – sta
Thanks sta. I edited my question with the result of dd($request->all()); – user13652637
I give an answer, try this instead of Formation::create($request->all()); – sta

2 Answers

0
votes

Use $request->validated() instead of $request->all()

public function store(Request $request)
{
    // ...
    Formation::create($request->validated());
    // ...
}
0
votes

There is a files in your request, so you get this error. You can save your query in this way, to prevent extra field :

$q = new Formation();
$q->name = $request->name;
$q->price = $request->price;
$q->description = $request->description;
$q->subtitle = $request->subtitle;
$q->category_id = $request->category_id;
$q->level_id = $request->level_id;
$q->save();