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

Question

I am trying this Query in Laravel 5.2

User::with(['posts'])
  ->withCount('post_images')
  ->orderBy('post_images_count', 'desc')
  ->take(8)
  ->get();

After that I got this error Call to undefined method Illuminate\Database\Query\Builder::post_images()

I did not understand what mistake is here.

Here users table has relation with posts Table and Posts table has relation with post_images table

public function posts()
{
    return $this->hasMany(Post::class);
}

public function postimages()
{
    return $this->hasManyThrough(PostImage::class, Post::class);
}

Please guide How can I fix this.

You can make `User::with() / User::withCount()` only on related Models. And you dont have related User with post_images table. But you can make somthing like this: https://stackoverflow.com/a/39681353/4771277 — Autista_z, May 26 '17 at 08:21
Shouldn't `withCount('post_images')` be `withCount('postimages')` ? — linktoahref, May 26 '17 at 08:43

score 1 · Accepted Answer · answered May 26 '17 at 08:53

1

As @linktoahref said, withCount is taking a relation method names as argument, not a table nor a column name.

withCount('postimages')should fix your problem

answered May 26 '17 at 08:53

Robin Choffardet

430
2
9

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

1 Answers1