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: stackoverflow.com/a/39681353/4771277 — Autista_z
Shouldn't withCount('post_images') be withCount('postimages') ? — linktoahref

Robin Choffardet Robin Choffardet · Accepted Answer · 2017-05-26T08:53:26

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

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

1 Answers