Laravel still expects to find deleted_at column after I remove softDelete

Dan picture Dan · Jan 27, 2018 · Viewed 7.5k times · Source

I just removed softDelete from a table with this migration:

   Schema::table("items", function ($table) {
      $table->dropSoftDeletes();
   });

But now every query results in:

Column not found: 1054 Unknown column 'items.deleted_at' in 'where clause' 

Nowhere does the code explicitly refer to this column. Has it been cached somewhere, and if so, how to clear it?

Answer

Alexey Mezenin picture Alexey Mezenin · Jan 27, 2018

You also need to remove the trait from the model:

use SoftDeletes;

From the docs:

To enable soft deletes for a model, use the Illuminate\Database\Eloquent\SoftDeletes trait on the model