Method addEagerConstraints does not exist

laravel eloquent lumen
Louis Etienne picture Louis Etienne · Jan 6, 2018 · Viewed 12.9k times · Source

I have two models, User and Event. I made a pivot table, invitations between User and Event with a status column. In my Event model definition, I wrote this :

public function invited()
{
    return $this->belongsToMany(User::class, 'invitations', 'event_id', 'user_id')
        ->withTimestamps()
        ->withPivot('status')
        ->orderByDesc('invitations.updated_at');
}

public function participants()
{
    $event = $this->with([
        'invited' => function ($query) {
            $query->where('invitations.status', InvitationStatus::ACCEPTED)->get();
        }
    ])->first();

    return $event->invited;
}

But when in my controller I do :

$event = Event::where('id', $id)->with(['owner', 'participants'])->first();

I have the following error :

(1/1) BadMethodCallException
Method addEagerConstraints does not exist.

Does someone know why?

Answer

Alexey Mezenin picture Alexey Mezenin · Jan 6, 2018

When you're trying to do this:

->with('participants')

Laravel expects to get a relationship instance. In other words, you can't use this method as a relation.

Related questions

PHP Lumen Call to a member function connection() on null

Call to a member function connection() on null is the error I'm receiving when trying to use an Eloquent Model in Lumen. Controller func: /** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $employees = …

Read More
How to Create Multiple Where Clause Query Using Laravel Eloquent?

I'm using the Laravel Eloquent query builder and I have a query where I want a WHERE clause on multiple conditions. It works, but it's not elegant. Example: $results = User::where('this', '=', 1) ->where('that', '=', 1) …

Read More
Get the Last Inserted Id Using Laravel Eloquent

I'm currently using the below code to insert data in a table: <?php public function saveDetailsCompany() { $post = Input::All(); $data = new Company; $data->nombre = $post['name']; $data->direccion = $post['address']; $data->telefono = $post['phone']; $data->…

Read More