Call to undefined method Illuminate\Database\Query\Builder::withTrashed()

Question

Not sure what im doing wrong but im getting this error, and im not sure how to solve it.

i referenced this, but im still unsure, maybe its my schema migration

im using laravel 5.5

laravel 5.2 Call to undefined method Illuminate\Database\Query\Builder::associate()

Call to undefined method Illuminate\Database\Query\Builder::withTrashed()

PostController.php

public function isLikedByMe($id)
{
    $post = Post::findOrFail($id)->first();
    if (Like::whereUserId(auth()->id())->wherePostId($post->id)->exists()){
        return 'true';
    }
    return 'false';
}

public function like(Post $post)
{
    $existing_like = Like::withTrashed()->wherePostId($post->id)->whereUserId(auth()->id())->first();

    if (is_null($existing_like)) {
        Like::create([
            'post_id' => $post->id,
            'user_id' => auth()->id()
        ]);
    } else {
        if (is_null($existing_like->deleted_at)) {
            $existing_like->delete();
        } else {
            $existing_like->restore();
        }
    }

Likes Model

class Like extends Model
{
    //
}

User model condensed to whats important

public function likes()
{
    return $this->belongsToMany('App\Post', 'likes', 'user_id', 'post_id');
}

Post model

public function likes()
{
    return $this->belongsToMany('App\User', 'likes');
}

Migration:

likes migration

public function up()
{
    Schema::create('likes', function (Blueprint $table) {
        $table->increments('id');
        $table->integer('post_id')->unsigned();
        $table->integer('user_id')->unsigned();
        $table->foreign('post_id')->references('id')->on('posts');
        $table->foreign('user_id')->references('id')->on('users');
        $table->softDeletes();
        $table->timestamps();

    });
}

Posts migration

public function up()
{
    Schema::create('posts', function (Blueprint $table) {
        $table->increments('id');
        $table->string('title');
        $table->text('body');
        $table->integer('user_id')->unsigned();
        $table->foreign('user_id')->references('id')->on('users');
        $table->timestamps();
    });
}

did you use this in your model use SoftDeletes; ?

Onix
– Onix

2017-11-27 21:46:40 +00:00
Commented Nov 27, 2017 at 21:46 — Onix
– Onix, Commented Nov 27, 2017 at 21:46

score 36 · Accepted Answer · 2017-11-27 21:46:32Z

36

Your Eloquent model should use the Illuminate\Database\Eloquent\SoftDeletes trait to make use of the withTrashed() method.

Like::class

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use Illuminate\Database\Eloquent\SoftDeletes;

class Like extends Model
{
    use SoftDeletes;
}

edited Nov 27, 2017 at 21:46

answered Nov 27, 2017 at 21:42

user6705732

Sign up to request clarification or add additional context in comments.

6 Comments

BARNOWL Over a year ago

i just updated let me know if you think im missing something

BARNOWL Over a year ago

in the meanwhile im going to add that because i didn't have that

BARNOWL Over a year ago

let me try it now

BARNOWL Over a year ago

so the second edit is gets me closer to the objective.

BARNOWL Over a year ago

would you have any idea what the mass assignment is pointing to

|

Ngugi Kiarie · Accepted Answer · 2022-01-17 06:59:28Z

-1

Had the same issue, the problem was that I used DB::table($table_name) instead of calling the model, using the model helped.

Regards

answered Jan 17, 2022 at 6:59

Ngugi Kiarie

1,45613 silver badges9 bronze badges

Collectives™ on Stack Overflow

Call to undefined method Illuminate\Database\Query\Builder::withTrashed()

2 Answers 2

6 Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

Comments

Linked

Related