Laravel - it is looking for a column "deleted_at" even if I didn't created that column

Question

I am having this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'deleted_at' in 'where clause' (SQL: select * from `events` where `events`.`deleted_at` is null)

I didn't create a deleted_at column in that table but Laravel is looking for that column, how can I disable that?

Thanks!

Does this answer your question? [Laravel still expects to find deleted\_at column after I remove softDelete](https://stackoverflow.com/questions/48478645/laravel-still-expects-to-find-deleted-at-column-after-i-remove-softdelete) — SergkeiM, Jan 07 '20 at 12:21
https://stackoverflow.com/questions/48478645/laravel-still-expects-to-find-deleted-at-column-after-i-remove-softdelete?answertab=oldest#tab-top — Harpal Singh, Jan 07 '20 at 12:31

Foued MOUSSI · Accepted Answer · 2020-01-07T12:27:36.400

8

Remove the trait from your App\Event model:

use SoftDeletes;

From the docs:

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

edited Jan 07 '20 at 12:27

answered Jan 07 '20 at 12:22

Foued MOUSSI

4,643
3
19
39

score 2 · Answer 2 · answered Jan 07 '20 at 12:23

2

Perhaps you haven't removed the soft delete trait from your model (Event class):

use SoftDeletes;

answered Jan 07 '20 at 12:23

Tarus

126
6

score 0 · Answer 3 · answered Mar 03 '22 at 20:11

What does your Eloquent query look like? Are you using SoftDeletes? If not the above solutions are what you are looking for.

If you are using SoftDelete trait and have all columns in place then:
I had the same issue when I used the from method on my model. There is also an issue on GitHub when using the from method.
My solution was to re-write my query without from.

Laravel - it is looking for a column "deleted_at" even if I didn't created that column

3 Answers3

Linked